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
$20
Take This Course
  • Lectures 13
  • Contents Video: 1.5 hours
    Other: 2 mins
  • 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 5/2015 English

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!

What are the requirements?

  • Find a relaxing, comfortable environment to learn.
  • Have Excel 2013 installed and download all the sample excel files for the course.

What am I going to get from this course?

  • Enter and format data tables
  • Do basic calculations
  • Summarise data
  • Create Pivot tables
  • Create beautiful, professional charts
  • Use charts in Microsoft Word and Powerpoint

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

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
intro
Preview
02:14
Section 2: Excel 2013 Interface
Excel 2013 Interface
Preview
06:24
Excel Interface
3 questions
Section 3: Create Your First Excel Table
Create Your First Table
Preview
08:29
Quiz for creating your first table
5 questions
Section 4: Format your first table
Formatting your first table
10:27
Format your first table
5 questions
Section 5: Get your file ready for printing
Get your Excel Table ready for printing
07:49
Get your table ready for printing
4 questions
Section 6: Analyse information in Excel 2013
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
Section 7: Present your results
Present your information using SmartArt, Shapes, Charts and Pivot Tables
07:27
Section 8: Practice and Resources
Sample dataset for practice
1 page
Useful shortcuts for Excel 2013
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Edward Chan, 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.


Ready to start learning?
Take This Course