Learn Excel from scratch to the point where you’ll be able to program your own macros!
Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance and accounting or administration, Microsoft Excel has the tools and libraries that will make your project come to life.
What you’ll learn
- Getting Started with Excel.
- Working with Formulas and Functions.
- Creating Charts and Other Visualizations.
- Managing and Analyzing Data.
- Understanding Power Pivot and Power Query.
- Automating Excel with Macros on VBA.
Course Content
- Getting Started with Excel –> 8 lectures • 50min.
- Working with Formulas and Functions –> 10 lectures • 1hr 39min.
- Creating Charts and Other Visualizations –> 5 lectures • 1hr 50min.
- Managing and Analyzing Data –> 9 lectures • 1hr 27min.
- Understanding Power Pivot and Power Query –> 4 lectures • 35min.
- Automating Excel –> 6 lectures • 51min.
Requirements
Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance and accounting or administration, Microsoft Excel has the tools and libraries that will make your project come to life.
If you have no knowledge whatsoever in this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.
This course is divided into 6 sections, and made up of 42 chapters. All the exercise files are provided with the videos so you can follow along with the instructor.
The course is divided into the following sections and chapters:
- Getting Started with Excel
- Introducing Excel
- Entering and Editing Worksheet Data
- Performing Basic Worksheet Operations
- Working with Excel Ranges and Tables
- Formatting Worksheets
- Understanding Excel Files and Templates
- Printing Your Work
- Customizing the Excel User Interface
- Working with Formulas and Functions
- Introducing Formulas and Functions
- Using Formulas for Common Mathematical Operations
- Using Formulas to Manipulate Text
- Using Formulas with Dates and Times
- Using Formulas for Conditional Analysis
- Using Formulas for Matching and Lookups
- Using Formulas for Financial Analysis
- Using Formulas for Statistical Analysis
- Understanding and Using Array Formulas
- Making Your Formulas Error-Free
- Creating Charts and Other Visualizations
- Getting Started with Excel Charts
- Using Advanced Charting Techniques
- Creating Sparkline Graphics
- Visualizing with Custom Number Formats and Shapes
- Implementing Excel Dashboarding Best Practices
- Managing and Analyzing Data
- Importing and Cleaning Data
- Using Data Validation
- Creating and Using Worksheet Outlines
- Linking and Consolidating Worksheets
- Introduction to PivotTables and Data Analysis
- Performing Spreadsheet What-If Analysis
- Analyzing Data Using Goal Seeking and Solver
- Analyzing Data with the Analysis ToolPak
- Protecting Your Work
- Understanding Power Pivot and Power Query
- Introducing Power Pivot
- Working Directly with the Internal Data Model
- Adding Formulas to Power Pivot
- Power Query
- Automating Excel
- Introducing Visual Basic for Applications
- Creating Custom Worksheet Functions
- Creating UserForms
- Using UserForm Controls in a Worksheet through an Example
- Working with Excel Events
- Creating Custom Excel Add-Ins