Microsoft Excel - Getting Started With The Basics
4.4 (1,428 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
17,381 students enrolled

Microsoft Excel - Getting Started With The Basics

Learn to use Functions & Formulas, Charts, Filters, Keyboard Shortcuts & More for Excel 2010, Excel 2013, Excel 2016
4.4 (1,429 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
17,381 students enrolled
Created by Martyn Blythin
Last updated 9/2019
English
English [Auto-generated]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 24 articles
  • 37 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn everything you need to get Excel onto your resume or CV
  • Learn basic formulas such as SUM & AVERAGE
  • Learn basic charts to present your work
  • Learn how to prepare your work for printing
  • Learn some simple best practice principles to get the most out of Excel
Requirements
  • This course was created with Excel 2013. However it will also work with Excel 2010, 2013 and 2016 for Windows
Description

Updated and Expanded February 2019!


Microsoft Excel - Getting Started With The Basics, where you can learn how to get the most out of Excel, even if you are a complete beginner!

You will learn all about Excel cells, Excel rows & columns, how to speed up your work with Excel sheets and easiest ways of sorting & filtering data in Excel. We will explore some of the most popular Excel charts and Excel functions and from there we will dive into best practices to make sure you know how to effectively use Microsoft Excel.


"Useful and easy to follow. Great teacher. I'm self-taught on excel and have used for 17 years.... learning so much from this course that is already speeding up my work!"
-  G Wilkinson

"This course is exactly as described: a beginner's tutorial on the most basic and fundamental aspects of Excel. I haven't used Excel in almost a decade and needed a refresher to see if I still remembered the most important aspects, and while I definitely do, I also learned a lot of new and interesting tips and techniques (like different ways to force a worksheet to print on a single page). The instructor was articulate, friendly, and concise. This was a perfect "Basics" course!"
-  Vivian P.

"The pace of tutoring and interactivity made the information easy to understand."
- G Parker

As your instructor, I will use my experience of Excel training in some of the biggest UK companies to guide you step by step on your way of mastering the basics of Microsoft Excel.  Whether you're looking to do your job faster, wow your boss, step up your data analysis game using Microsoft Excel or to improve your resume, you are in the right place.


Course access includes comprehensive workbook with examples, 1-on-1 tutor support, lifetime access and a 100% money-back guarantee!


"The pace of tutoring and interactivity made the information easy to understand."
- Garith Parker

  "Useful and easy to follow. Great teacher. Im self taught on excel and have used for 17 years.... learning so much from this course that is already speeding up my work!"
-  Graham Wilkinson

 Learning Excel is a bit like building a brick wall. Many beginners have a basic foundation - they understand the essentials of spreadsheets. Then they start piling on a few bricks here and there. But as their wall of knowledge is constructed, it's full of holes. Eventually they hit a point where their wall can't sustain any more weight and it collapses. What a waste of time! 

 This course takes a step-by-step approach to working with Excel. Each lesson builds upon the previous one, so your wall is solid. So whether you're looking to do your job better, or if you're looking to improve your resume, you are in the right place. 

 A comprehensive workbook with examples is included to save you time. You can also ask me any questions via the course discussion board. 

Who this course is for:
  • If you've never used Excel before or you want to get a comprehensive knowledge of the basics, this course is for you
Course content
Expand all 49 lectures 02:14:18
+ Introduction
3 lectures 02:45
Course Roadmap
01:42
One rule - Keep it simple
00:54

This is an amazing resource you can use to speed up your work and maximize the use of Microsoft Excel. It is packed with all of the keyboard shortcuts you can use in Excel 2013.

Cheat sheet Excel Shortcuts
00:08
+ Master The Basics
12 lectures 26:29
Module Overview
00:29
Some Quick Definitions
01:11

Difficulty: Easy

Overview: There are a multitude of ways to format data in Excel, including fonts, colours, borders, number formatting (date, currency, numerical, text etc). In this lesson you'll learn:

  1. How to use font formatting

  2. How to use cell alignment tools including merge & wrap text

  3. How to add multiple rows of text within a cell

  4. Data formats (date, currency, numerical, text etc)

  5. Setting cell and table borders

Preview 09:03

Difficulty: Easy

Overview: Text styles are a useful way to apply consistent formatting to different elements of your work. Similar to header styles in word, they can be used to create great looking and well organised spreadsheets with less effort. You can also create your own custom styles.

In this lesson you'll learn:

  1. How to use default text styles

  2. How to create your own text styles

How to Use & Customise Text Styles
02:25

Difficulty: Easy

Challenge: Open the attached file, and create a custom text style. Call it 'my custom style', and make the font Tahoma size 20, in bright red colour with a black background. Try using your new text style. Check your work against the text style titled 'Solution'.

Challenge: Create a custom text style
00:11

Difficulty: Easy

Overview: It can often be tricky to get your Excel files to print just how you like. In this lesson you'll learn:

  1. How to use Page Area and fixed widths and heights to make your work fit on the page

  2. How to repeat a row at the top of each page

  3. Setting margins

  4. Setting headers and footers

  5. Setting the page size

  6. Print preview

Preparing Your Work for Printing
04:39
Challenge - Prepare a file for printing
00:12
Bonus: How to print labels from Excel
00:08
Saving Your Work Correctly
00:50

Difficulty: Easy

Overview: When copying and pasting in Excel, you can choose if to paste all or just some elements of the cell. In this lesson you'll learn:

  1. Regular copy and paste

  2. Paste special as values and as formulas

  3. Paste special column widths

  4. Paste special transpose

  5. Paste special formats

Paste & Paste Special
03:16
Challenge: Using paste special
00:09

Difficulty: Easy

Overview: In this lesson you'll learn how to insert shapes, lines, text boxes and smart art.

Inserting shapes, text boxes and smart art
03:53
Quiz: Have you mastered the basics?
6 questions
+ Managing Data
15 lectures 48:22
Module Overview
00:48
The 10 immutable laws of structuring data
04:44

Difficulty: Easy

Overview: In this lesson you'll learn how to sort data correctly in Excel, and how to sort by multiple criteria at once.

How to Sort Your Data Correctly
02:46

Difficulty: Easy

Overview: Autofilter is a powerful tool that allows you to slice and dice your data using criteria. In this lesson you'll learn how to use it, and how to harness its more advanced functionality, such as filtering for 'This Month', and searches using wildcard characters.

Using Autofilter to Effectively Search & Filter Your Data
05:45

Difficulty: Easy

Overview: There are 3 ways you can structure your data tables - as a range, as a formatted table or as a named range. In this lesson you'll learn the differences between these and when to use each.

Tables & Named Ranges
06:21
Challenge: Convert a range to a table
00:06

Difficulty: Intermediate

Overview: Data Validation allows you to add restrictions on what can be entered into cells. This can be particularly useful when creating data entry spreadsheets for others to use. In this lesson you'll learn:

  1. How to create a drop down list within a cell.

  2. How to restrict the type of data that can be entered into a cell (date, time, numbers, text etc) and use restrict the range of data that can be entered.

  3. How to create a dynamic drop down list that expands or contracts depending on what is entered in a list.

Creating Drop Down Selections & Restricting Data Entry Using Data Validation
05:14
Challenge - Create a drop down selection for data entry
00:10

Difficulty: Intermediate

Overview: Conditional Formatting allows cells to be automatically coloured depending on the value entered into them. It has a wide range of uses, including creating a red-amber-green status for reports and dashboards. It can be also be used to create mini bar charts and icons that respond to the value in cell. In this lesson you'll learn:

  1. How to highlight top/bottom values in a range

  2. How to create a temperature style colouring for your data

  3. How to create a red-amber-green status for a report metric

How To Colour Cells Depending on Their Contents Using Conditional Formatting
06:55
Challenge - Add conditional formatting for project list
00:07

Difficulty: Advanced

Overview: Excel is often used to analyse data from other sources, such as databases or raw data files. If you are using the same data source over and over again, it can often be linked in Excel, allowing the latest data to be refreshed at the click of a button. In this lesson you'll learn:

  1. How to link Excel to a static data file

  2. How to link Excel to an Access database

How to Import External Data From Databases
03:24

Difficulty: Intermediate

Overview: Excel can be used to 'scrape' web data, with mixed success. If you regularly copy and paste data from a website, for example stock prices or currency rates, it can sometimes be automated by linking the page in Excel. In this lesson you'll learn how to give this a try. Note that it cannot be used to log you in to a website, or to get data from anything other than basic web pages. Some sites block this functionality.

How to Download Data Tables From Websites
02:56
Challenge - Download the latest stock prices
00:06

Difficulty Level: Advanced

Overview: Sometimes importing data into Excel can be troublesome. In this lesson we'll look at how to import a text file that Excel does not recognise using 'Text to Columns'.

What to do When Excel Can't Read Your Data - Text To Columns
03:03
Quiz: Can you work with data in Excel
6 questions

This lesson covers how to create basic good looking charts. These topics include:

  • Selecting your data

  • Creating a bar (column) chart

  • Creating a pie (donut) chart

  • Formatting chart colours

  • Adding elements to charts

Creating Excel Charts - Pie & Bar/Column
05:56
+ Enriching Data With Functions
9 lectures 30:48
Module Overview
00:39

Difficulty: Easy

Overview: SUM, AVERAGE, MIN and MAX are the easiest to use functions in Excel. In this lesson you'll learn how to use them, and familiarise yourself with how functions work.

SUM, AVERAGE, MIN and MAX
02:36
Challenge: Find COUNT, SUM and AVERAGE Sales Value
00:09

Difficulty: Easy

Overview: When writing functions, cell references can be written in two different ways; relative or absolute. In this lesson you'll learn the differences between the two and when to use them.

Absolute vs Relative cell references
05:21

Difficulty: Intermediate

Overview: In addition to the basic SUM, COUNT and AVERAGE functions, there are conditional versions of each. These allow you to sum, count or average items in a range which meet a certain criteria which can be set as numerical or text. In this lesson you'll learn:

  1. COUNTIF & COUNTIFS

  2. SUMIF & SUMIFS

  3. AVERAGEIF & AVERAGEIFS

SUMIF, COUNTIF, AVERAGEIF
07:17
Challenge: Finding duplicate rows using COUNTIF
00:12

Difficulty: Intermediate

Overview: The way in which functions are written differs depending on if they reference a range, a named range or a formatted table. In this lesson we look at the different ways to reference these tables correctly.

Referencing Tables & Named Ranges Correctly
03:35

Difficulty: Intermediate

Overview: Any element of a function can be replaced with another function, this is known as nesting functions. In this lesson you'll learn how to correctly create and edit nested functions.

Nesting Functions
03:11

Difficulty: Intermediate

Overview: VLOOKUP is one of the most useful functions in Excel. It allows you to cross reference one table to another, where the tables have a field in common. In this lesson you'll learn:

  1. How to create a VLOOKUP

  2. The difference between exact and approximate match

  3. How to create an HLOOKUP for a horizontal table lookup

Preview 07:48
+ Analysing Data with Charts
9 lectures 25:33
Module Overview
00:33

Difficulty: Easy

Overview: Before you get started learning how to create charts and graphs, you must ensure that your data is ready and in the right format. In this lesson we'll look at creating manual summary tables with functions like SUMIF, COUNTIF, and AVERAGEIF.

Preparing your data for charts
02:22

Difficulty: Easy

Challenge: Download the attached challenge file. Create a summary table for average salary by department. Check your work on the solution tab.

Challenge: Prepare Data for a Chart
00:05

Diffculty: Easy

Overview: In this lesson you'll learn how to create a basic pie or donut chart.

Pie & Donut Charts
05:43

Difficulty: Easy

Overview: In this lesson you'll learn how to create a basic line chart for a time series data set.

Line Charts
04:33
Challenge - Create a pie chart
00:04

Difficulty: Intermediate

Overview: In this lesson you'll learn how to create basic column and bar charts, as well as using stacked bar charts.

Bar & Column Charts
06:48
Challenge: Create a Bar Chart
00:08
Chart & Axis Formatting
05:16
+ Wrapping up
1 lecture 00:19
Bonus Lecture: More from Martyn Blythin & DataMinded Training
00:19