Microsoft Excel - Improve your skills quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more - in just a couple of hours
Rating: 4.4 out of 5 (3,338 ratings)
38,330 students
Microsoft Excel - Improve your skills quickly
Rating: 4.4 out of 5 (3,338 ratings)
38,330 students
Create Tables, PivotTables, PivotCharts and Sparklines
Add Conditional Formatting, Filters - and even use a bit of Visual Basic for Applications
Use SUM, SUMIF, VLOOKUP, OFFSET and INDIRECT functions
Find out what you need to know about Excel to continue your learning.

Requirements

  • Before beginning, you will need to know how to use a Windows computer, including a mouse.
  • It would be good if you have used Microsoft Excel before, but this is not essential.
  • You should have MS Excel (or Office) 2007, 2010, 2013, 2016 or 365 installed on your computer.
Description

Welcome to this course about Microsoft Excel.

A lot of people use some of the features in Excel and just muddle through - not many use all of the functions.

In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.

  • Learn more about formatting, filters and conditional formatting.
  • Create tables, PivotTables, Chart, PivotCharts and Sparklines.
  • Find out how powerful Visual Basic for Applications (VBA) is.
  • And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT - translated into 15 different languages.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features - and you'll find out how much more you can learn.

Who this course is for:
  • This course is for you if you want to develop your Microsoft Excel skills in just a couple of hours.
  • This course will use the latest version of Excel, but is ideal for you if you use any modern version - Excel 2007, 2010, 2013, 2016 or 365.
  • This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.
  • This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.
Course content
4 sections • 21 lectures • 1h 36m total length
  • Introduction
    02:02
  • Welcome to Udemy
    00:35
  • Introduction to Udemy
    02:00
  • Formatting
    06:30
  • Filters
    05:47
  • Conditional Formatting
    05:19
  • Tables
    07:07
  • PivotTables
    08:56
  • Graphs and PivotCharts
    07:51
  • Sparklines
    04:24
  • Visual Basic for Applications (VBA)
    06:53
  • Practice Activity Number 1
    00:28
  • SUM, AVERAGE, COUNT
    06:56
  • SUMIF, AVERAGEIF, COUNTIF
    06:50
  • VLOOKUP
    05:01
  • OFFSET
    03:35
  • INDIRECT
    05:05
  • Practice Activity Number 2
    00:25
  • What more should I know about Excel?
    03:13
  • Bonus - How to learn more about Excel
    05:53
  • Thank you for taking this course
    01:18

Instructor
Best Selling Instructor - over 200,000 students so far
Phillip Burton
  • 4.5 Instructor Rating
  • 30,297 Reviews
  • 231,372 Students
  • 39 Courses

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.