Udemy – Excel Microsoft 365 Intermediate

What you’ll learn:
How to Finalize, print, save, security and sharing in Excel 365
How to create and use Excel Tables
How to create and use Excel Charts, Graphics
How to use Excel Functions and power functions
Requirements
Must know how to use Excel in a basic way and have access to Excel software
Description
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
Who this course is for
Business employees, home office workers for business or personal use of Excel 365
Homepage

https://www.udemy.com/course/microsoft-excel-365-intermediate