Getting Started with Excel 2013
4.6 (953 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.
10,950 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Getting Started with Excel 2013 to your Wishlist.

Add to Wishlist

Getting Started with Excel 2013

Learn everything you need to know to get started with Excel 2013.
4.6 (953 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.
10,950 students enrolled
Created by Martyn Blythin
Last updated 8/2014
English
Price: Free
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 know to get started with Excel. This is more than a simple introduction - everything you need to know is demonstrated with an easy to understand step-by-step process.
View Curriculum
Requirements
  • Excel 2013
Description

Welcome to Getting Started with Excel 2013 - a free 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. But the best part is that all the accompanying workbooks are free!

So if you're looking how to get started with Excel quickly and easily, you're in the right place. Just because it's free doesn't mean that you get a cut-down down version of another course. Yes, we do have an advanced Excel course, but this Getting Started course teaches you all the essential Excel functionality so you can get your first spreadsheet built in record time.

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
Expand All 15 Lectures Collapse All 15 Lectures 01:11:49
+
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
Introduction
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.

A short background of Excel
01:57
+
The Basics
6 Lectures 31:11

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

  • Cells
  • Rows
  • Columns
  • Sheets
  • Formulas
Basic terminology
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
Working with Cells
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
Working with Rows & Columns
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 riibbon
  • 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.6 Average rating
995 Reviews
11,540 Students
2 Courses
Excel Guru & Data Analytics Specialist

I'm an Excel developer and trainer with over 10 years using Excel for data analytics and business process improvement in the UK. I also run a consultancy business specialising in custom Excel apps and data analytics. Over the years, I've been asked to run so many training sessions on Excel that I finally decided to put my content online. My focus is on helping people get the most out of Excel with the minimum effort, pain, and the least boredom.

Let's face it, using Excel isn't always the highlight of everyone's day. For many it's a constant pain because they have to go to ask the office guru every time they need to do a VLookup, or a Pivot Table. Perhaps they don't even know what a Pivot Table is! My courses are all about helping you to get the most out of Excel, so that you can be faster and more effective with your spreadsheets, without boring you with technical manuals or long form lessons.

Having worked in a wide range of global financial institutions and consultancies during my career, I am constantly amazed at how much productivity large organisations miss out on by not having their staff fluent in Excel. There is so much opportunity to improve efficiency,automate tasks, get better data insights, reduce errors, and create happier staff, simply by improving the level of competence in Excel across organisations. I have seen countless Excel classes that focus just on what the various buttons in Excel do and how to use them. I never felt this was enough. Excel users need to know WHEN and WHY they should use these tools, not just HOW. There's also huge scope for to coach Excel users away from common pitfalls and bad practice. I created these courses to provide more comprehensive, 360° training for Excel users of all levels from beginners to seasoned experts.