Buying for a Team? Gift This Course
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
English
$10 $20 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Find a relaxing, comfortable environment to learn.
  • Have Excel 2013 installed and download all the sample excel files for the course.
Description

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
+
Introduction
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
10:27

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

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

Maximum, Minimum, Average and Count functions
06:06

Cell Referencing. Fixing a cell position in a formula.
07:34

If, then, else function
04:53

Create and use Pivot Tables to analyse information
07:41

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

Useful shortcuts for Excel 2013
1 page
About the Instructor
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.


Report Abuse