Overview

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

Skills

Reviews