This course will teach you how to use Microsoft Excel to solve common business problems. You’ll gain an in-depth understanding of the importance of advanced financial tools — and how they can empower or cripple a business — depending on your ability to use them.
How will you learn?The course is self-paced and includes a pre-assessment test and modules of interactive instruction based on videos, animations, case studies, discussion questions and knowledge assessments.
All participants who successfully complete the course will receive a MOTIF Certificate of Completion.
What will you learn?By the end of this course, you will be able to:
1. Create advanced financial reporting tools.
2. Construct and manipulate data in PivotTables through grouping techniques, modified field settings, sorting, and filtering options to assemble data for high level decision-making.
3. Export, import, and link data from external data sources.
4. Use advanced Excel tools to analyze industry scenarios and solve complex business problems.