Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Essential Skills: Excel proficiency in 45 minutes
Rating: 4.6 out of 5(142 ratings)
822 students

Excel Essential Skills: Excel proficiency in 45 minutes

VLOOKUP, Pivot Tables, Charts, IF, Autofill, Conditional formating and much more with real-life examples.
Created byViliam Gregus
Last updated 12/2020
English

What you'll learn

  • Basic, most-commonly used Excel skills: VLOOKUP, Pivot Tables, Charts, IF function, Conditional formatting, Autofill, Sorting, Filtering, Table Trnsformation etc.

Course content

1 section • 10 lectures • 45m total length

  • Autofill2:38
  • Sorting & Filtering4:40

    Master how to freeze table headers, sort data by buyer surnames from A to Z, apply and clear filters, and adjust column widths to view all content in Excel.

  • VLOOKUP5:01
  • Essential Formulas4:36

    Learn excel formulas: create an amount paid column by multiplying amount and price in orders sheet, add a full name column from given name and surname, and use MONTH function.

  • Statistical Functions5:40
  • IF5:17
  • Pivot Tables4:51
  • Charts4:30

    Create bar chart in Excel with products on the x axis and amount paid on the y axis from a pivot table, add axis titles, and use clustered column chart.

  • Conditional Formatting3:23
  • Table Transformation4:41

    Learn Excel table transformation: copy as values, transpose to switch rows and columns, apply alternating row colors with format painter, and split comma-delimited data with text to columns.

Requirements

  • The only requirement is to have Microsoft Excel 2010 or newer installed.

Description

In this course you will learn the most-used Excel skills which are most commonly required from top companies:

- VLOOKUP

- Pivot Tables

- IF function

- Charts

- Autofill

- SUM,MIN,MAX,AVERAGE and other basic formulas

- Sorting and filtering

- Conditional formatting and more.

Everything is presented on real-life examples and in a timely manner. All videos are 5 minutes or shorter, ensuring you wont loose focus and stay motivated during the course. You will get a file with 25 tasks where you can exercise your newly aquired knowledge, all tasks are solved in the videos by the Lector.

This course is for:

- Excel beginners and intermediate users with elementary knowledge of Excel (knowing how to input data, copy cell etc.)

Who this course is for:

  • Daily users of excel: Accountants, Data analysts, Controllers, Managers etc.

Report abuse