Getting Started with Excel - The Basics
4.5 (1,084 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.
11,705 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Getting Started with Excel - The Basics to your Wishlist.

Add to Wishlist

Getting Started with Excel - The Basics

Learn to use Formulas, Charts, Filters, Shortcuts & More for Excel 2010, Excel 2013, Excel 2016
4.5 (1,084 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.
11,705 students enrolled
Created by Martyn Blythin
Last updated 7/2017
English
Current price: $10 Original price: $45 Discount: 78% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • This course was created with Excel 2013. However it will also work with Excel 2010, 2013 and 2016 for Windows
Description

Welcome to Getting Started with Excel 2013 - a  series of Excel video tutorials for beginners. If you're new to Excel, I recommend watching watching this course. If you have already used Excel but want a comprehensive knowledge of the basics, then you're in the right place.

This is based on the original getting started with Excel course that I have been teaching in person in the UK banking industry since 2007. Now fully updated for Excel 2013, this course has been used by students all around the globe. 

So if you're looking how to get started with Excel quickly and easily, you're in the right place.

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 is the target audience?
  • If you've never used Excel before or you want to get a comprehensive knowledge of the basics, this course is for you
Students Who Viewed This Course Also Viewed
Curriculum For This Course
15 Lectures
01:11:48
+
Introduction
2 Lectures 04:32

This lesson covers the course content and a little more information about the author.

The key topics covered in the course are:

  • A short background of Excel
  • Basic terminology
  • Working with cells, rows, columns and sheets
  • Navigating the menus in Excel 2013
  • An introduction to charts
  • An introduction to formulas
  • Saving your work
  • Printing & exporting
  • Basic best practice
  • Data entry
  • Sorting Data
  • Formatting cells
  • Keyboard shortcuts
Preview 02:35

This lesson covers the key differences between older versions of Excel and Excel 2013, what has changed and how it has evolved over time.

Preview 01:57
+
The Basics
6 Lectures 31:11

This lesson covers some key basic terminology that you must understand before progressing with the course. Definitions are included for:

  • Cells
  • Rows
  • Columns
  • Sheets
  • Formulas
Preview 02:35

This lesson covers how to use cells correctly. Topics include:

  • Selecting cells
  • How to correctly enter data into cells
  • Wrap text
  • Merge cells
  • Adding new lines within cells
  • Using quick formats to format the type of data you enter
Preview 07:42

This lesson covers how to use and edit rows and columns. Topics include:

  • Selecting rows & columns
  • Formatting rows & columns
  • Inserting rows & columns
  • Deleting rows & columns
  • Hiding & unhiding rows & columns
  • Moving rows & columns
Preview 04:40

This lesson covers how to use and edit sheets. Topics include:

  • Selecting sheets
  • Setting sheet colours
  • Inserting sheets
  • Deleting sheets
  • Hiding & unhiding sheets
  • Moving & copying sheets
Working with Sheets
03:45

This lesson covers how to sort and filter data. Topics include:

  • How to sort data
  • Sorting using multiple fields
  • Setting if your data has headers or not
  • Using auto filter
  • Filtering on numbers
  • Filtering to a top 10
  • Filtering on text
Sorting & Filtering Data
06:20

This lesson covers how to use and navigate the ribbon menus in Excel 2013. Topics include:

  • Home ribbon
  • Insert ribbon
  • Page layout ribbon
  • Formulas ribbon
  • Data ribbon
  • Review ribbon
  • View ribbon
  • Developer ribbon
  • File menu
Navigating the menus
06:09
+
Charts
1 Lecture 05:56

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

  • Selecting your data
  • Creating a bar (column) chart
  • Creating a pie (donut) chart
  • Formatting chart colours
  • Adding elements to charts
Creating basic bar & pie charts
05:56
+
Formulas
1 Lecture 09:07

This lesson covers how to use basic formulas. Topics include:

  • Basic math calculations
  • SUM formulas
  • AVERAGE formulas
  • COUNT formulas
SUM, AVERAGE & COUNT formulas
09:07
+
Printing, Saving & Exporting
2 Lectures 09:50

This lesson covers how to save your work in Excel. Topics include:

  • The file menu
  • Different types of Excel workbook
  • CSV and text files
Saving your work
03:05

This lesson covers how to print your work effectively in Excel. Topics include:

  • Setting print margins
  • How to make your work fit on the page
  • Saving as PDF
Printing your work
06:45
+
Best Practice & Shortcuts
2 Lectures 07:02

This lesson covers some basic best practice principles. Topics include:

  • Starting your data in A1
  • Adding dates correctly
  • Naming your sheets clearly
  • Using a glossary
  • Using columns instead of colours
Basic best practice
07:02

This is a fantastic resource you can use to speed up your use of excel. It is packed with all of the keyboard shortcuts you can use in Excel 2013.

Keyboard Shortcuts
4 pages
+
Course Conclusion
1 Lecture 00:11
Next Steps
00:11
About the Instructor
Martyn Blythin
4.5 Average rating
1,141 Reviews
12,372 Students
2 Courses
Your Excel Mentor - Over 12,000+ successful students

Hi, I'm Martyn. I created my courses to help you to get better at Excel and to get your next promotion, job or raise. My courses are a little different to most - you'll learn the most powerful functionality in Excel through in depth online courses, ongoing learning through case studies and exercises, as well as a fantastic online student community to share your experiences of breaking through the career ladder with better skills.

I am also the founder of Effective MI, a dashboard development & process improvement company. We help companies understand their business through data discovery, KPI development and powerful management reporting tools.

If you want to stop drifting and start learning Excel, you are in the right place. Welcome!