Microsoft Excel Master Class
About This Course
The Microsoft Excel Masterclass course is designed for professionals that want to learn the ins and outs of excel to help boost your productivity and skills for work.
I’m sure if you are looking at this course, you already have some experience with excel but don’t really know how to use excel to its full power.
There are so many different buttons and features in excel that it can become really overwhelming, confusing and frustrating.
I can relate.
I’ve been using excel since high school but it wasn’t until I started getting properly trained that I really understood the different options, tools and functionalities excel really had.
It was a shift in my career.
It has made my job much easier and I now have a highly developed skill desired by employers.
If you don’t understand how to really use excel, you’ll slowly get left behind. I encourage you to take the next step in separating yourself from your peers by learning how to really use excel.
Here’s what will be covered in this course:
- Ribbons and Features
- Saving and Printing
- Simple Math Operations
- Common Math Functions
- Large Data Functions
- Graphing and Data
- Graphing Math Functions
- Formatting and Types of Graphs
- Borders and Formatting
- Sample Applications of Excel
- Formula Calculation
- Matrix Math Operations
Our Promise to You
By the end of this course, you’ll have the knowledge to improve your use of Excel for personal and work related tasks. This is a powerful tool that can be used in many ways!
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and improve your skills with Excel!
Section 1 - IntroductionHide Lessons
What Excel Looks Like
Section 2 - Ribbon and FeaturesShow Lessons
Insert, Graphing, Page Layout, & Formulas
More Formulas, Data, Review, & Layout
Section 3 - Saving and PrintingShow Lessons
How to Save & Print
Section 4 - Simple Math OperationsShow Lessons
Entering & Calculating Simple Math
Section 5 - Common Math FunctionsShow Lessons
Sum & Average
Minimum, Trigonometry, Degrees, & Exponentials
Logarithms, Radians, Square Roots
Section 6 - Large Data FunctionsShow Lessons
Correlate, Count, GCD
If, Info, LCM, Median
Mode, Slope, Standard Deviation
Random Numbers, Rounding Up & Down
Section 7 - Graphing & DataShow Lessons
Formatting Data for Graphing
Scatter Plots, Editing a Data Series
Editing a Scatter Plot Chart, Isolating Plots
Section 8 - Graphing Math FunctionsShow Lessons
Equation Based Graphing & Chart Settings
More Chart Settings & Stylistics Intro
How to Change Chart Type
Section 9 - Formatting and Types of GraphsShow Lessons
Scatter Plot Formatting In-Depth
Intelligent Line & Data Point Formatting
Section 10 - Borders and FormattingShow Lessons
Cell Sizing, Font, Layout, & Merging
Grouping, Borders, Styling, & Visual Separation
Freeze Panes & Sorting
Section 11 - TrendlinesShow Lessons
What They Are & How They Work
Section 12 - Timesheet ExampleShow Lessons
Using Excel For Simple Bookkeeping
Section 13 - Formula CalculationShow Lessons
How to Calculate Formulas Easily in Excel
Section 14 - Matrix Math OperationsShow Lessons
Matrix Math & Complex Calculations