Microsoft Excel Master Class

4.7 (126 ratings)
 · 7,196 students enrolled

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
  • Trendlines
  • 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!

Course Curriculum

Course Sections

What Excel Looks Like

Insert, Graphing, Page Layout, & Formulas

More Formulas, Data, Review, & Layout

How to Save & Print

Entering & Calculating Simple Math

Sum & Average

Minimum, Trigonometry, Degrees, & Exponentials

Future Value

Logarithms, Radians, Square Roots

Correlate, Count, GCD

If, Info, LCM, Median

Mode, Slope, Standard Deviation

Random Numbers, Rounding Up & Down

Formatting Data for Graphing

Scatter Plots, Editing a Data Series

Editing a Scatter Plot Chart, Isolating Plots

Equation Based Graphing & Chart Settings

More Chart Settings & Stylistics Intro

How to Change Chart Type

Scatter Plot Formatting In-Depth

Intelligent Line & Data Point Formatting

Cell Sizing, Font, Layout, & Merging

Grouping, Borders, Styling, & Visual Separation

Freeze Panes & Sorting

What They Are & How They Work

Using Excel For Simple Bookkeeping

How to Calculate Formulas Easily in Excel

Matrix Math & Complex Calculations

About The Instructor

Andrew Norris

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.

Reviews

Average Rating by 126 students
4.7
  1. Profile photo of Nichole Nichole Johnson says:

    Great course
    This is a great course for those who know the basic functions of Excel and what to know some advance features.

1 3
  • $199.00 USD
  • UNLIMITED ACCESS
  • Course Certificate
  • 24/7 Support