Microsoft 365 Excel Advanced class

Click link above to access class

Introduction Excel 365 advanced                              

Overview of entire course Excel 365 advanced                                

Chapter 1:  Introduction to Macros                           

Overview                               

Understanding and creating macros part 1                            

Understanding and creating macros part 2                            

Running and editing a macro                         

Chapter 2 Pivot Tables                                  

Overview                               

Creating Pivot Tables                         

Changing and Manipulating Pivot Table Data                                  

Grouping by date and time                            

Grouping by other factors                              

Using slicers to clarify and manipulate fields                       

Using Pivot Charts                             

Chapter 3 Working with lists                         

Overview                               

Query Data with Database functions                         

Outline and Subtotal data Part 1                                

Outline and Subtotal data Part 2                                

Outline and Subtotal data Part 3                                

Chapter 4 Data Analysis tools                                   

Overview                               

Using goal seek                                  

Using solver                           

Using scenario manager                                 

Using data tables                                

Chapter 5: Data management                        

Overview                               

Sorting data                           

Using filters                           

Splitting data into multiple columns                          

Using flash fill                                   

Removing duplicate records                          

Using validation tools                        

Chapter 6  Exchanging Excel data with other programs                               

Overview                               

Embedding objects from Excel                                  

Linking objects from Excel                           

Importing objects into Excel                          

Working with Raw data

Conclusion