Excel for Beginners - Navigation - Pivot Tables- and VLookup
4.3 (112 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,048 students enrolled

Excel for Beginners - Navigation - Pivot Tables- and VLookup

Learn the Basics of Excel from Someone that uses Excel on a Daily Basis for Work
4.3 (112 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,048 students enrolled
Created by David Mills
Last updated 3/2020
English
English [Auto]
Current price: $118.99 Original price: $169.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will feel comfortable using Microsoft Excel
  • Navigating spreadsheets
  • Adding Filters
  • How to sort data
  • Shortcut Keys
  • How to build pivot tables quickly
  • How to use the Vlookup formula
Requirements
  • Student needs to have access to Microsoft Excel 2010 or higher
Description

Are you new to Microsoft Excel?

This course is designed to take the complete Excel beginner, literally someone that has never logged into Excel before, and show them how to navigate around the software, how to become comfortable with the software and finally, how to become a reporting pro!

What you will learn in this Excel for Beginners course:

  • navigate toolbar and menu bar

  • How to Save as Workbook Not as CSV File

  • Navigate Rows Columns Cells

  • Insert Column Insert Row Sheets Explained

  • Build a Basic Spreadsheet

  • header menu - make it easy to look at

  • add outline box to all cells

  • Shortcut Keys

  • shift end down and others - half triangle highlight entire sheet fast

  • sorting and filtering

  • sum, autosum, multiply-average

  • pivot tables

  • vlookup formula

  • build report fast - put it all together

As someone that professionally uses Microsoft Excel in 50% of my job for the last 10 years, I am qualified to teach you how to use Excel. I understand what it is like to open Excel up and not really know what to do with the data. Let me show you how to get around Excel and learn at your own pace.

I look forward to seeing you in the course!

Who this course is for:
  • Beginner Microsoft Excel users or users that use Excel but would like to take their skills to the next level
Course content
Expand all 10 lectures 01:26:27
+ Main Section
9 lectures 01:23:38

Download the Excel for Beginners Practice Data in resources section

Preview 09:09
Build a Basic Spreadsheet
06:40
Shortcut Keys
05:51
Sorting and Filtering
09:36
Sum - Autosum - Multiply - Average
08:32

Download the Excel for Beginners practice data 2 file and go along with the lesson and practice creating pivot tables!

Pivot Tables
13:10
Vlookup Formula
09:46
Build Reports Fast - Putting it all Together
12:46
+ Conclusion
1 lecture 02:49
Conclusion and Thank You
02:49