In this course, Excel 365 Pro, you will take your Excel knowledge to the ultimate level. First, you will learn how to format and work with data. Then you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros and form controls. When you’re finished with this course, you will have the skills needed to feel fully complete in creating professional spreadsheets (and complete preparation for the Office exams).
Display filters
Interested in attending? Have a suggestion about running this event near you?
Register your interest now
Description
Course Duration: 6 Hours
In this course, Excel 365 Pro, you will take your Excel knowledge to the ultimate level. First, you will learn how to format and work with data. Then you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros and form controls. When you’re finished with this course, you will have the skills needed to feel fully complete in creating professional spreadsheets (and complete preparation for the Office exams).
Course Outline:
Formatting
Working with Data
Power Query
Text Fucntions
Logical and Statistical Functions
Expanded Functions
Error Checking
Conditional Formatting
Charts
Pivot Tables
Advanced Options
Finalizing a Workbook
Macros and Form Controls
eTraining Course Navigation Strategies:
Beginners: Complete the course in order from beginning to end. Once any topic is completed, you will have full access to it at any time for one year after registration, to use as a resource.
Intermediate/Advanced Users: Use the course as a flexible resource tool to find what you need, whenever you need it. Try the assessment tests first, if you get 70%+ you can move to the next level, if you get less than 70% you should complete the lecture. This gives you a pre and post assessment score, which can be used to track your skills improvement.
Recommended Supported Browsers:
We recommend that you use the most current version of Internet Explorer, Google Chrome, Microsoft Edge, Maxthon, Firefox, Opera or Safari.
Other browsers, and some earlier versions of these browsers may be supported – but you may experience some limitations on certain Learning Management Systems or course functions.
New Course Concepts:
New concepts may be identified with a star icon. Our content is continuously updating, and therefore we ask that as you work through your course, you periodically review previously completed topics to ensure that you have successfully reviewed each slide. Updated slides, even if previously completed, will not be marked as complete until reviewed again.
