Udemy

Excel for Beginners - Navigation - Pivot Tables- and VLookup

Enroll Now
  • 5,381 Students
  • Updated 3/2020
4.6
(248 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 26 Minute(s)
Language
English
Taught by
David Mills
Rating
4.6
(248 Ratings)

Course Overview

Excel for Beginners - Navigation - Pivot Tables- and VLookup

Learn the Basics of Excel from Someone that uses Excel on a Daily Basis for Work

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!

Course Content

  • 2 section(s)
  • 10 lecture(s)
  • Section 1 Main Section
  • Section 2 Conclusion

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

Skills covered in this course


Reviews

  • A
    Alicia S Harris
    5.0

    Excellent teaching

  • J
    Jeanice Muller Nelson
    5.0

    Great course. Learned a lot! Thank you :)

  • M
    Micki Tapper
    5.0

    I had a very minimal understanding of Excel. This course was great to learn and better understand the basic along with learning how to build Pivot tables

  • D
    Donna Goss
    5.0

    Explains things really well.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed