Excel 2013 Essentials for Beginners
5.0 (1 rating)
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.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013 Essentials for Beginners to your Wishlist.

Add to Wishlist

Excel 2013 Essentials for Beginners

All the Excel 2013 essentials in 60 minutes to create, analyse and present data. Suitable for Excel Beginners
5.0 (1 rating)
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.
1 student enrolled
Created by Edward Chan
Last updated 5/2015
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Enter and format data tables
Do basic calculations
Summarise data
Create Pivot tables
Create beautiful, professional charts
Use charts in Microsoft Word and Powerpoint
View Curriculum
  • Find a relaxing, comfortable environment to learn.
  • Have Excel 2013 installed and download all the sample excel files for the course.

Don't have time to learn Excel? Sick of going to these day courses on Excel and can't apply what you learnt at your workplace?

This course is for you.

Basic Excel 2013 in 60 Minutes is a crush course on Excel for you to use Excel for work, study or your daily life. This course is broken down into 3 basic elements of why we use Excel:

  1. Enter and store information and data
  2. Analyses and calculate
  3. Present your findings in graphics, infographics or as part of a report

From the most basic functions of Excel 2013, I am going to explain how we can use Excel and give you all the tricks you require to start using Excel.

This course is about learning by doing - you will be able to follow what I do in the videos. There will also be sample datasets and exercises for you to complete.

As the course title suggests, the video components of this course is condensed to about 60 minutes to give you all the basic knowledge of Excel. The course is jammed packed with information though. We will go through materials such as:

  • The Excel interface
  • How to quickly enter information and move information around
  • Format your tables to look professional
  • Get your spreadsheet ready for printing
  • Calculate using basic formulas
  • Use Pivot tables for analysis
  • Create professional graphs and infographics
So.. without further delay, let's get started!

Who is the target audience?
  • This course is meant for newbies who wants to learn all the key features of Excel 2013 quickly.
  • No prior knowledge of Excel is required.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 13 Lectures Collapse All 13 Lectures 01:16:52
1 Lecture 02:14
Excel 2013 Interface
1 Lecture 06:24

Excel Interface
3 questions
Create Your First Excel Table
1 Lecture 08:29

Quiz for creating your first table
5 questions
Format your first table
1 Lecture 10:27
Formatting your first table

Format your first table
5 questions
Get your file ready for printing
1 Lecture 07:49
Get your Excel Table ready for printing

Get your table ready for printing
4 questions
Analyse information in Excel 2013
5 Lectures 32:02
Simple calculations explained

Maximum, Minimum, Average and Count functions

Cell Referencing. Fixing a cell position in a formula.

If, then, else function

Create and use Pivot Tables to analyse information

Data analysis
8 questions
Present your results
1 Lecture 07:27
Present your information using SmartArt, Shapes, Charts and Pivot Tables
Practice and Resources
2 Lectures 00:00
Sample dataset for practice
1 page

Useful shortcuts for Excel 2013
1 page
About the Instructor
Edward Chan
5.0 Average rating
1 Review
1 Student
1 Course
Data Analyst and Visualist, Accountant, and a self-confessed data nerd

Hi, I am Ed from Sydney, Australia.

Since I was a kid, I have always been interested in numbers and how numbers can help making decisions. This love of data drives me to get my Degree in Economics and a Master Degree in Finance and Accounting.

Since then, I have been advising private and public organisations on data analytics, data visualisation, strategies, and finance. I am also a keen investor.

About an year ago, I discovered Udemy. I am a firm believer in life-time learning, and I am so excited to see the numerous learning opportunities Udemy offers to people from all over the world.

I have been a student on Udemy and has been learning from many instructors. Then I thought, maybe I can also contribute to the Udemy platform and share my experience and knowledge with others here. Now I am producing a number of courses here on topics that I love - courses relating to data analysis, data visualisation, and investing.

Feel free to drop me a line or post on the discussion board if you have any questions! I will try to answer them as quickly (and as much) as possible.