Getting Started with Excel 2013

Learn everything you need to know to get started with Excel 2013.
4.3 (400 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.
8,522 students enrolled
Free
Start Learning Now
  • Lectures 15
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2014 English

Course 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.

What are the requirements?

  • Excel 2013

What am I going to get from this course?

  • 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.

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:35

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
01:57

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

Section 2: The Basics
02:35

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
07:42

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
04:40

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
03:45

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
06:20

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
06:09

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
Section 3: Charts
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
Section 4: Formulas
09:07

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

  • Basic math calculations
  • SUM formulas
  • AVERAGE formulas
  • COUNT formulas
Section 5: Printing, Saving & Exporting
03:05

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

  • The file menu
  • Different types of Excel workbook
  • CSV and text files
06:45

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
Section 6: Best Practice & Shortcuts
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
4 pages

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.

Section 7: Course Conclusion
Next Steps
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Martyn Blythin, 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.

Ready to start learning?
Start Learning Now