Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -

via Skillshare

Overview

Welcome to my BIGGEST, most complete, Microsoft Excel course ever!

Excel is one of the most important skills in today's job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.

If you need to know Excel, you're in the right place. 

This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros.

My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve.

This course was created using Excel 2016, but it is good for versions 2013 and 2010 as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn't cover Mac-specific keyboard shortcuts and interface.

We'll start at the very beginning, with opening and saving a worksheet in Excel. 

I'll show you what all the tools do and walk you through each Excel skill that you need to know.

I'll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I'll teach you amazing keyboard shortcuts to make your work faster and more productive. You'll learn how to record macros so you can do a whole series of actions with the just click of a button.

We'll keep going until you're a pro at Excel. When you finish this course, you'll know more than most people who use Excel at their job every day.

Here's some of what you'll learn.

  • Creating spreadsheets in Excel
  • Saving your work where you can find it
  • Working with multiple workbooks in Excel
  • Formatting and printing
  • Importing data from CSV files, Access and the web
  • Creating and using formulas and functions like: Vlookup, Index/Match, If statements and dozens of others
  • Creating charts including: Bar charts, Line charts, Column charts, Pie charts and more
  • Creating tables
  • Sorting and filtering your data
  • Creating pivot tables
  • Creating pivot charts from your pivot tables
  • Fun New features for Excel 2016
  • Keyboard shortcuts to make your work go faster
  • How to record basic macros to automate repetitive tasks
  • A whole lot more

The course comes with a certificate of completion, a full 30-day money back guarantee, and I'm always available to answer questions or share additional resources if you get stuck.

Thanks for checking out my Biggest Excel Course to date. 

I'll see you in there!

Syllabus

  • Excel 2016 Introduction - What You'll Learn
  • How to Get the Most Out of This Course
  • Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
  • Using Excel Templates to Save Time and Effort
  • Saving Your Document Where You Can Find It
  • Entering Data and Navigating Cells
  • Creating Simple Formulas to Do Powerful Calculations
  • Working with Workbooks and Worksheets
  • Introduction - Creating and Formatting Your Heading
  • Formatting Subheadings and Columns and Alphabetizings Lists
  • Entering and Formatting Numbers
  • Create Formulas to Calculate Total Costs
  • Final Formatting Grids and Spacing
  • Intro to Formulas and Functions
  • What is a Formula
  • What is a Function
  • The Anatomy of a Formula
  • Quickly Select Cells to Use in Your Formula
  • Absolute vs. Relative Cell References
  • AVERAGE and AVERAGEA
  • COUNT COUNTA and COUNTBLANK
  • IF Function
  • SUMIF and SUMIFS Functions
  • COUNIF and COUNTIFS Functions
  • VLOOKUP Function
  • LEFT RIGHT MID Functions
  • Concatenate
  • LEN
  • FIND and SEARCH
  • MIN and MAX
  • AND and OR
  • ROUND
  • Conditional Formatting
  • Intro to Charts and Graphs
  • Formatting Charts
  • Create a Bar Chart
  • Create a Pie Chart
  • Create a Line Chart
  • Introduction to Pivot Tables - Preparing Your Data
  • How to Create a Pivot Table
  • Put Your Pivot Table to Work
  • Pivot Charts
  • What's New for 2016
  • 6 New Chart Types for 2016
  • "Tell Me What You Want To Do" - The New Help Feature
  • 1-Click Forecasting
  • 3D Maps
  • Saving as CSV, Text and PDF
  • Backing Up Your Excel Files
  • Using the AutoRecover Feature
  • Import from Web, Copy/Paste, and Cleaning Up Data
  • Import from CSV file and Excel Workbook
  • Importing Data from Access Database
  • Printing Your Excel Document
  • Excel Keyboard Shortcuts
  • ALT Key Shortcuts
  • TEXT
  • REPT - Repeat
  • UPPER, LOWER, and PROPER
  • TRIM - Remove Extra Spaces
  • Combining LEFT, MID, FIND and TRIM
  • HYPERLINK - Create a Table of Contents for Your Worksheets
  • RAND and RANDBETWEEN - Random Numbers
  • ROUND
  • INT - Integer
  • MOD - Remainder
  • DATE and DATEVALUE
  • TIME
  • TODAY and NOW
  • YEAR, MONTH, DAY, HOUR, MINUTE and SECOND
  • WEEKDAY and WEEKNUM
  • IFERROR
  • LARGE and SMALL
  • INDEX and MATCH
  • Nested INDEX, MATCH, IF and IFERROR
  • Nested IF, AND and OR Functions
  • Record Your First Macro
  • Saving Your Macro and Security
  • Use a Macro to Create a Kitchen Remodel Costs Template
  • How to Use Relative Cell References
  • An Easy Cell-Formatting Macro
  • Find and Delete Empty Cells from Located Outside Your Data
  • Flash Fill and Auto Fill for Fast Data Entry
  • Freezing the Top Row of Your Spreadsheet
  • Hide and Unhide Rows, Columns and Entire Sheets
  • Insert Multiple Rows and Columns Easily
  • Mail Merge with Microsoft Excel and Word
  • Paste Special
  • Sort and Filter
  • Quick Calculatilons with the Status Bar
  • Intro to the Complete Walk-Through of Excel Tools and Ribbons
  • File Menu - The Complete Walk-Through
  • Home Tab (part 1) - The Complete Walk-Through
  • Home Tab (part 2) - The Complete Walk-Through
  • Insert Tab (part 1) - The Complete Walk-Through
  • Insert Tab (part 2) - The Complete Walk-Through
  • Insert Tab (part 3) - The Complete Walk-Through
  • Page Layout Tab (part 1) - The Complete Walk-Through
  • Page Layout Tab (part 2) - The Complete Walk-Through
  • Formulas Tab (part 1) - The Complete Walk-Through
  • Formulas Tab (part 2) - The Complete Walk-Through
  • Data Tab (part 1) - The Complete Walk-Through
  • Data Tab (part 2) - The Complete Walk-Through
  • View Tab (part 1) - The Complete Walk-Through
  • View Tab (part 2) - The Complete Walk-Through
  • Developer Tab (part 1) - The Complete Walk-Through
  • Developer Tab (part 2) - The Complete Walk-Through
  • Conclusion

Taught by

Steve McDonald

Reviews

Start your review of Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.