Excel Microsoft 365 Intermediate
Learn how to create and use Excel Tables, Charts, Graphics, and Layouts in Excel 365. This intermediate level course covers topics such as power functions, formulas, sorting and filtering data, and using functions like IF, VLOOKUP, and COUNTIF. You will also learn how to finalize, print, save, secure, and share your workbooks. This course is suitable for business employees and home office workers who use Excel 365 for both personal and professional purposes. A downloadable Test Quiz with an answer key is included.
What you’ll learn
- How to create and use Excel Tables, Charts, Graphics, Layouts
- How to use Excel power functions, and formulas
- How to Finalize, print, save, security and sharing in Excel 365
- IF, COUNTIF, IFS, VLOOKUP functions
- Sort and filter data, pictures
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
User Reviews
Be the first to review “Excel Microsoft 365 Intermediate”
You must be logged in to post a review.
There are no reviews yet.