Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel for Beginners - Navigation - Pivot Tables- and VLookup
Rating: 4.4 out of 5(267 ratings)
5,485 students

Excel for Beginners - Navigation - Pivot Tables- and VLookup

Learn the Basics of Excel from Someone that uses Excel on a Daily Basis for Work
Created byDavid Mills
Last updated 3/2020
English
English [Auto],

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

Course content

2 sections • 10 lectures • 1h 26m total length

  • Navigate Toolbar and Menu Bar9:09

    Download the Excel for Beginners Practice Data in resources section

  • How to Navigate Rows - Columns and Cells8:08

    Navigate rows, columns, and cells; insert columns or rows; and distinguish workbooks from worksheets. Learn moving data between sheets and auto-fit column width.

  • Build a Basic Spreadsheet6:40

    Learn to build a basic spreadsheet, clean up cluttered data, and improve readability by formatting headers, auto-fitting columns, wrapping text, and adding borders.

  • Shortcut Keys5:51

    Learn essential Excel shortcut keys, including shift+down to highlight data and ctrl+shift+l to toggle header filters, then copy, paste, and move data across workbooks.

  • Sorting and Filtering9:36

    Learn to sort and filter in Excel using filters, multi-level sorting, and practical examples with product and date to produce clean, ready-to-share data.

  • Sum - Autosum - Multiply - Average8:32

    Learn to use basic Excel formulas such as sum, auto sum, multiply, and average, including converting data to numbers and applying the fill handle for quick column calculations.

  • Pivot Tables13:10

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

  • Vlookup Formula9:46

    Master the vlookup formula to pull and match data from another sheet into your current workbook, using the wizard for quick setup and ensuring general formatting for reliable results.

  • Build Reports Fast - Putting it all Together12:46

    Learn to build fast, data-rich reports in Excel by creating pivot tables to analyze occupation salaries, years of experience, education status, and salary ranges, with clear formatting.

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

Report abuse