Learn Microsoft 365 Excel intermediate level going over basic table features, adding charts and graphs, working with functions, IF, VLOOKUP COUNTIF power functions, finalize printing saving workbooks, security and sharing workbooks. A downloadable Test Quiz is included with enclosed answer key.
What you will learn:
Introduction Excel 365 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 Charts and Graphs
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 Statistical functions
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
Downloadable Test Quiz is included with enclosed answer key
