Course Outline

Excel for Scientists & Engineers
High-powered Excel from an Expert! Math & Trig functions – permutations, random number generation, rounding. Statistical functions – avg, mode, median, std dev, curves, regression analysis, confidence intervals. Scientific functions – converting units, ranking data. Powerful formulas using Arrays. Solver, Goal Seek. VLOOKUP, IF, INDIRECT, OFFSET, ADDRESS, MATCH functions. Distributions. Analysis TookPak. Advanced Charting – scatter charts, trend lines, dual-axis charts, population histograms, floating column charts, templates. Database Analysis Techniques – DSUM, DAVERAGE, DSTDEV, pivot tables, querying Access. Symbols, special commands, shortcuts, customs functions with VBA. 12 hours
Prerequisites:  MS Excel Level 1 or equivalent experience.
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600