Excel Power Skills
Excel Power Skills Course Details:
Just about everyone knows how to construct a simple spreadsheet. Most business users can add IF statements and SUM function to do heavy-duty number crunching. But if you really want to set your Excel skills apart from the rest of the pack, you have to move on to the advanced functions. Knowing how to create sophisticated spreadsheets capable of not only displaying data but of producing refined analysis of the data.
The Excel training class was designed with your real-world problem solving needs in mind. In each of its subject modules it first provides you with a quick overview of the concept followed by a step-by-step introduction as to how Excel implements the concept. Once these essentials have been mastered, you will move on to more sophisticated models that provide real-value to solving real-world situations. You will leave the course proficient in power functions and techniques that others do not even know exist. You will be set to immediately begin implementing what you have learned to the benefit of your job and your career.
Call (919) 283-1653 to get a class scheduled online or in your area!
The "Power" Functions - the basics for building power spreadsheets
- INDEX
- MATCH
- OFFSET
- INDIRECT
- Lab: Applying the functions
Linear Programming with Excel - optimizing everyday business solutions
- Problem Types
- Setting up the Solution
- Lab: Maximum/Minimum Solutions with Solver
Odds and Ends - a helpful collection of var
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
- Learn how to find optimal solutions to any number of business problems using Solver
- Master the use of Monte Carlo analysis for a wide range of estimating situations
- Develop predictive models that can incorporate both quantitative and qualitative factors
- Quickly standardize databases of information by applying text functions
- Discover information buried in your data that you did not know existed
- Be able to display data in a manner that enhances understanding
- Develop sophisticated risk models for your project, product, or operation
- Find relationships between data using correlations and statistical analysis
- Master the functions that will serve as the building blocks of your future databases
- Learn how to combine any number of functions and tools for one-of-a-kind Excel analysis
Lab: Applying the functions
Lab: Maximum/Minimum Solutions with Solver
Lab: Practice Worksheet
Lab: Cleaning up database entries
Lab: Trend analysis of business data
Lab: Evaluating Sales Data
Lab: Calculate correlations for a predictive model
Lab: Building one and two dimensional arrays
Lab: Statistical Analysis using Excel
Lab: Calculating Risk for uncertain events
- Product owners
- Project managers
- Product analysts
- Functional managers
- Small business owners
- Non-profit managers
- Professionals seeking deeper insights into their data