Microsoft 365 Excel video instruction intermediate lessons

Microsoft 365 Intermediate class – Excel                                            

Click the link above to access class

Introduction Excel 365 Videos classes Intermediate                                                   

Overview of entire course Excel 365 Intermediate                                                    

Chapter 1 Basic Table features                                                          

Chapter 1 Overview                                                   

What tables are                                                          

Sort and filter data part 1                                                       

Sort and filter data part 2                                                       

Creating and using tables                                                       

Chapter 2  Adding charts and graphics                                                          

Chapter 2 Overview                                                   

What are Charts and Graphs and the difference                                                        

Creating a chart                                                          

Enhancing a chart                                                      

Modifying chart data                                                 

Changing chart types                                                 

Inserting shapes and other features                                                   

Working with chart elements                                                 

Formatting charts                                                       

Inserting pictures                                                       

Creating in-cell charts with sparklines                                                           

Chapter 3 Working with functions                                                    

Chapter 3: Overview                                                  

Using statistical functions                                                     

Calculating present value                                                       

Calculating loan payments and payoff                                                          

Calculating principle & interest paid                                                

Calculating interest rate, auto calculations                                                    

Working with text functions                                                  

Working with ranges                                                  

Using date and time functions                                                           

Working with logical functions                                                         

Copying formula values                                                         

Chapter 4 IF, VLOOKUP, COUNTIF, Power Functions                                                     

Chapter 4  Overview                                                  

Using the IF Function                                                

Using IF with relational operators                                                     

Using the IFS function                                                          

Using VLOOKUP                                                     

Using VLOOKUP approximate table data                                                    

Using VLOOKUP exact table data                                                   

Using COUNTIF Functions part 1                                                    

Using COUNTIF Functions part 2                                                    

Chapter 5 Finalize, Print and Save                                                    

Chapter 5  Overview                                                  

Use proofing help and research tools                                                

exploring the page layout and view tabs                                                       

working with layout and page setup                                                  

changing view options                                                           

Previewing and modifying page breaks                                                         

Adding headers and footers                                                   

previewing and printing the worksheet                                                         

Arranging multiple workbooks                                                          

Adding hyperlinks                                                     

Saving workbooks in different formats                                                         

Emailing a workbook                                                

Chapter 6 Security and Sharing in Excel 365                                                

Chapter 6 Overview                                                   

Unlocking cells and protecting worksheets                                                   

Protecting workbooks                                                

Assigning passwords to workbooks                                                  

Sharing workbooks part 1                                                      

Sharing workbooks part 2                                                      

Tracking Changes                                                      

Conclusion                             

Learn Microsoft 365 Office Excel – Beginner class

Longmont Computer Physicians learning series – Learn how to use and work with Excel 365 from Microsoft Office.  This is an in-depth beginner class and part one of 3 courses Beginner, Intermediate and Advanced.  This course covers new features of Excel 365, Starting up and working with Excel, creating new workbooks, Organizing your worksheet, Basic formulas, Using templates and themes, and a downloadable Test Quiz is included at the end.

This Excel 365 class is taught by a Microsoft Certified Professional and Comptia A+ Computer consultant from Longmont, Colorado. He has been the President and owner of Computer Physicians, a Longmont, CO computer repair, networking and software company for the past 20 years. He has 3 college degrees in computers which include computer science, programming, networking and GIS. He has programmed, designed, and created professional software programs. He has helped and taught over 3,000 clients how to use Microsoft computer software, hardware and peripherals in Longmont, Boulder, Denver, Erie Colorado as well as across the country.

Microsoft 365 Beginner class – Excel
Microsoft 365 Intermediate class – Excel
Microsoft 365 Advanced class – Excel


Chapter 1: New Features for 365
Overview
How Excel is different from older versions
What is new in Excel 365
How new features are added
365 using Office and Excel
365 in the Cloud
Example of a Excel wookbook/worksheet
Chapter 2: Starting up Excel
Overview
Opening up a workbook and worksheet
The Excel Screen
Difference between a workbook, worksheet and spreadsheet
cells, gridlines, entering data, sheet tabs
The Title bar, Quick access tool bar and namebox
File tab, backstage minitool bar
Customizing and using the Ribbon and KeyTips
Finding and replacing data, undo/redo,  copy and paste, selecting cells
scrolling, adjusting columns, rows
 inserting and deleting rows and columns, adjusting cells
Using Autofill
Using Comments
The file, view tab,  workbook window, status bar
zoom slider
font styles and effects
Chapter 3: Creating new workbooks
Overview
Entering text, numbers and dates
Editing data
More on Editing data
Designing borders and backgrounds
opening and saving workbooks
excel file formats
using conditional formatting
Chapter 4: Organizing your worksheet
Overview
Freeze panes
Split panes
creating, renaming hiding, unhiding worksheets
Format Painter
Alignment and wrap text
Formatting numbers and dates
copying and moving worksheets
hiding and unhiding rows and columns
copying and pasting data numbers, using paste special
Chapter 5: Basic Formulas
Overview
Formulas and functions
Creating basic formulas
Sum a column of numbers, autosum
copying a formula to other cells
simple formula syntax
inserting functions
auto calculate
add, subtract, multiply and divide cells
editing a range of cells
Chapter 6: Using a Template
Overview
Creating and using templates
Applying styles and themes
Conclusion