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 Power Skills 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.
Top 10 Reasons to Take This Course
- Move beyond displaying information to understanding it
- Learn how to produce sophisticated analysis quickly and accurately
- Significantly add to your understanding of Excel's potential
- Capture information about risk that you did not even know existed
- Upgrade existing spreadsheets to add real value above their current use
- Set your Excel skills apart from your peers
- Build a solid foundation of skills that can serve as the foundation for further learning
- Become the "go to" person when it comes to Excel use
- Go to the next level of sophistication with your spreadsheets
- Display information in forms that can be easily understood by others
What You Will Learn:
- 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
Industry Background
- In tight job markets you have to make yourself stand out from the crowd
- Excel skills are continually ranked high by current and prospective employers
- MS Office skills are overwhelmingly called for in job postings and especially Excel mastery
- The skills learned in this course are transferrable to any number of related areas and jobs
- Mastery of Excel can result in the sort of recognition that enhances not only careers but salaries
