About This CourseBeginner
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 in Excel!
Microsoft Excel Master Class Practice PackAdd to Cart
Section 1 - Introduction
What Excel Looks Like
Section 2 - Ribbon and Features
Insert, Graphing, Page Layout, & Formulas
More Formulas, Data, Review, & Layout
Section 3 - Saving and Printing
How to Save & Print
Section 4 - Simple Math Operations
Entering & Calculating Simple Math
Section 5 - Common Math Functions
Sum & Average
Minimum, Trigonometry, Degrees, & Exponentials
Logarithms, Radians, Square Roots
Section 6 - Large Data Functions
Correlate, Count, GCD
If, Info, LCM, Median
Mode, Slope, Standard Deviation
Random Numbers, Rounding Up & Down
Section 7 - Graphing & Data
Formatting Data for Graphing
Scatter Plots, Editing a Data Series
Editing a Scatter Plot Chart, Isolating Plots
Section 8 - Graphing Math Functions
Equation Based Graphing & Chart Settings
More Chart Settings & Stylistics Intro
How to Change Chart Type
Section 9 - Formatting and Types of Graphs
Scatter Plot Formatting In-Depth
Intelligent Line & Data Point Formatting
Section 10 - Borders and Formatting
Cell Sizing, Font, Layout, & Merging
Grouping, Borders, Styling, & Visual Separation
Freeze Panes & Sorting
Section 11 - Trendlines
What They Are & How They Work
Section 12 - Timesheet Example
Using Excel For Simple Bookkeeping
Section 13 - Formula Calculation
How to Calculate Formulas Easily in Excel
Section 14 - Matrix Math Operations
Matrix Math & Complex Calculations