Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX)
Learn to Create spreadsheets , Formulas ,Functions,Tables ,Charts and input data
What you’ll learn
-
Enter data in a spreadsheet
-
Save and open spreadsheet
-
Create formulas and functions
-
Format rows, columns, cells, and data
-
Align text in a cell
-
Adjust rows and columns
-
Find and replace data
-
Insert and delete sheets
-
Sort data
-
Add Borders and Fill Colours
-
Use Number Formatting
-
Use AutoSum
-
Insert Functions
-
Create and edit Macros
-
Create lookups with DAX
-
VBA Scripting
-
Debugging Macros
-
Connect to data sources
-
Analyze data with Pivot Tables and Pivot Charts
-
Prep data with Power Query
-
Consume data with Power Pivot
-
Create queries
-
Create reports
Requirements
-
You should be able to use a PC at a beginner level
Who this course is for:
- Beginners to spreadsheets and excel
- Those who need a refresher to excel.
