This course is designed for professionals who want to learn the ins and outs of Excel to help boost their office productivity and skills for work by understanding the most important functionalities of Excel.Read more.
My name is Andy Norris and I've been an engineer for 5 years. I graduated from SDSU with a bachelor's degree in mechanical engineering, and I am EIT certified in California. I currently work as a salary design engineer for a multinational diversified engineering and manufacturing corporation. I have a passion for teaching and I hope my courses help you succeed in your professional life, as well as your personal life.
Only want this course? Buy this course for
$199 $29 and keep lifetime access.
About This Course
The Microsoft Excel Online Masterclass course is designed for professionals who want to learn the ins and outs of Excel to help boost their 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!
10 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!
|Section 1 - Introduction|
|What Excel Looks Like||00:00:00|
|Section 2 - Ribbon And Features|
|Insert, Graphing, Page Layout, And Formulas||00:00:00|
|More Formulas, Data, Review, And Layout||00:00:00|
|Section 3 - Saving And Printing|
|How to Save And Print||00:00:00|
|Section 4 - Simple Math Operations|
|Entering And Calculating Simple Math||00:00:00|
|Section 5 - Common Math Functions|
|Sum And Average||00:00:00|
|Minimum, Trigonometry, Degrees, And Exponentials||00:00:00|
|Logarithms, Radians, Square Roots||00:00:00|
|Section 6 - Large Data Functions|
|Correlate, Count, GCD||00:00:00|
|If, Info, LCM, Median||00:00:00|
|Mode, Slope, Standard Deviation||00:00:00|
|Random Numbers, Rounding Up And Down||00:00:00|
|Section 7 - Graphing And Data|
|Formatting Data For Graphing||00:00:00|
|Scatter Plots, Editing A Data Series||00:00:00|
|Editing A Scatter Plot Chart, Isolating Plots||00:00:00|
|Section 8 - Graphing Math Functions|
|Equation Based Graphing And Chart Settings||00:00:00|
|More Chart Settings And Stylistics Intro||00:00:00|
|How To Change Chart Type||00:00:00|
|Section 9 - Formatting And Types Of Graphs|
|Scatter Plot Formatting In-Depth||00:00:00|
|Intelligent Line And Data Point Formatting||00:00:00|
|Section 10 - Borders And Formatting|
|Cell Sizing, Font, Layout, And Merging||00:00:00|
|Grouping, Borders, Styling, And Visual Separation||00:00:00|
|Freeze Panes And Sorting||00:00:00|
|Section 11 - Trendlines|
|What They Are And How They Work||00:00:00|
|Section 12 - Timesheet Example|
|Using Excel For Simple Bookkeeping||00:00:00|
|Section 13 - Formula Calculation|
|How To Calculate Formulas Easily In Excel||00:00:00|
|Section 14 - Matrix Math Operations|
|Matrix Math And Complex Calculations||00:00:00|