Microsoft Excel: Essentials for Finance & Controlling
Welcome to the second part of our online Excel tutorial! We recommend completing the MS Excel – Basics course first.
Here you’ll master Excel by doing, not just by reading books or watching videos. We believe that the best way to learn is by doing, so we encourage you to open Excel and recreate the learning content as you go. To get the most out of this course, make Excel part of your everyday life – use it at work to streamline tasks or, if you’re a student, use Excel to do your homework instead of relying on a calculator. Let’s dive in and unlock the power of Excel together!
- Advanced formulas: Nested functions and array formulas, advanced reference functions, financial functions, and statistical functions.
- Data analysis tools: PivotTables, Goal seek, data tables, and scenario manager.
- Analysis ToolPak and Excel Solver: Analysis ToolPak is an Excel add-in that provides a suite of powerful data analysis tools that allow users to perform advanced statistical and financial analysis without the need for complex formulas (descriptive statistics, Regression, t-Test, F-test, etc.).
The Solver add-in is a powerful optimization tool in Excel. - Importing data from text files: Import data into Excel and adjust the data.
- Structure and protect a workbook.
About Instructor
+14
enrolled
Not Enrolled
Course Includes
- 6 Lessons
Login
Accessing this course requires a login. Please enter your credentials below!
