Microsoft Excel - Improve your skills quickly
4.3 (257 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6,859 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Improve your skills quickly to your Wishlist.

Add to Wishlist

Microsoft Excel - Improve your skills quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more - in just a couple of hours
4.3 (257 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6,859 students enrolled
Created by Phillip Burton
Last updated 5/2017
English
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 2 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
01:33:33
+
Introduction
1 Lecture 02:02

Hello - welcome to the course.

Introduction
02:02
+
Improve your Skills
9 Lectures 53:15

Formatting turns a badly presented spreadsheet into a good one. Let's see some tips.

Formatting
06:30

Sometimes you don't want to see all of the data. Let's focus on particular rows using a filter.

Filters
05:47

Wouldn't it be nice if the computer could automatically highlight cells according to specific criteria. Well, it can! Let's find out about Conditional Formatting.

Conditional Formatting
05:19

Tables can enable the computer to add a few bells and whistles to your data - no effort. Let's find out what tables are and how you can use them.

Tables
07:07

PivotTables sound horrific, but are an easy way to summarise data. Let's see how easy they are to create.

PivotTables
08:56

If a picture tells a thousand words, how many does a good graph use? And how can you combine that with PivotTables to summarise the data. Let's find out about Charts and PivotCharts.

Graphs and PivotCharts
07:51

Sometimes a big chart is too much. Let's see how sparklines are like small charts.

Sparklines
04:24

Let's take a plunge into the wild side, and see what automation can do for your spreadsheet.

Visual Basic for Applications (VBA)
06:53

Let's see if you can remember the last few videos.

Practice Activity Number 1
00:28
+
Improve your Functions
6 Lectures 27:52

Let's start our look at functions with some of the summarising functions.

SUM, AVERAGE, COUNT
06:56

But what if you don't want to add up all of the data. Let's add some criteria.

SUMIF, AVERAGEIF, COUNTIF
06:50

What if you want to lookup data in one column based on another column - and how is VLOOKUP different to SUMIF? Let's find out.

VLOOKUP
05:01

Arrrr - we be on a treasure hunt, we be. Start at this cell, go down 2 and across 3. OFFSET marks the spot, arrr.

OFFSET
03:35

An companion to OFFSET, INDIRECT is another way to indirectly refer to cells, using strings.

INDIRECT
05:05

Let's see if you can use these functions. Good luck!

Practice Activity Number 2
00:25
+
Conclusion
3 Lectures 10:24

What much should you know about Excel? Let's find out from Microsoft.

What more should I know about Excel?
03:13

I'm hoping this course has been useful to you. But how can you continue learning about Excel? Here's some suggestions.

Additionally, you can add anything you want into spreadsheets - but what if that is not what you want. Maybe you only want someone to enter dates into a cell. Let's find out about data validation, and how you can add messages, to be displayed whenever you click into a particular cell.

Bonus - How to learn more about Excel
05:53

I hope you enjoyed the course. Goodbye for now.

Thank you for taking this course
01:18
About the Instructor
Phillip Burton
4.4 Average rating
3,285 Reviews
46,023 Students
25 Courses
Best Selling Instructor - over 45,000 students so far

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 me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.

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.