Microsoft Excel 2013 Intro and Intermediate Training

This course provides essential knowledge for new or inexperienced Microsoft Excel 2013 users, or aspiring "Excel Stars".
4.3 (16 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.
2,119 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 33
  • Length 4 hours
  • Skill Level Intermediate 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 6/2014 English

Course Description

UPDATE: For those who missed the opportunity to sign up during the introductory offer period, effective 3:00PST June 10th, 2014, the first 500 students that sign up before June 30th will get the course at 90% off! That's just $5! Use the offer code ONLYFIVEBUCKS

Instructor Mike Smith, a Canadian telecommunications project manager with over 10 years experience using, teaching and consulting for using Microsoft Excel, teaches users the basic and intermediate level functions of Microsoft Excel.

The lectures at the time of publishing number 33, and more are expected as demand dictates. All lectures are video based, and an Excel file for working along with the videos is included with the first lecture.

Students can expect to complete the course in about 8 hours, with allowance for practicing weaker areas of knowledge.

This course is for anyone looking to make their life simpler through tracking critical data, or to gain an advantage in the workplace through applicable knowledge of an industry standard software.

What are the requirements?

  • Microsoft Excel 2013 (PC or Mac)

What am I going to get from this course?

  • Create spreadsheets
  • Write formulas
  • Format spreadsheets for presentations
  • Simplify and sort data

What is the target audience?

  • Office workers
  • Small business owners
  • Planners

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 to This Course and Microsoft Excel 2013
Course Introduction
Preview
04:57
What is Excel / Introduction to Basic Formulas
Preview
16:47
The Microsoft Excel 2013 Certification Exam (77-420)
03:37
Creating an Excel Workbook
05:24
Excel WorkSheets
07:05
Navigating Excel 2013
08:56
Section 2: Inputting Data and Cell Formatting
Formatting a Cell (Ctrl+1)
12:23
Fill and Drag
07:32
Creating and Using Tables
09:48
Freeze Panes and Views
10:57
Section 3: Formulas (Part 1)
MAX, MIN, SUM and AVERAGE Formulas
13:05
ROUND Formulas
09:15
LEFT, RIGHT and MID Formulas
06:39
COUNT Formulas
06:23
CONCATENATE Formulas
08:17
Absolute References
11:18
WEEKDAY, WORKDAY and NETWORKDAY Formulas
09:50
Section 4: Formulas (Part 2)
IF Formulas
08:52
VLOOKUP and HLOOKUP Formulas
09:45
MATCH Formulas
04:28
INDEX Formulas
09:19
IFERROR Formulas
04:44
Section 5: Inputting Data and Cell Formatting (Part 2)
NameBox
04:14
Inserting and Formatting Pictures
04:27
COPY and PASTE Types
04:35
Data Validation
07:52
Grouping Rows and Columns
02:16
Locking or Hiding Cell Contents
05:16
Charts
04:36
Sort and Filter
03:54
Conditional Formatting
07:19
Section 6: Bonus Lectures
Developer Tab
02:30
~ (Show Cell Contents)
02:10

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mike Smith, Excel Consultant

My name is Mike Smith, and I am a Microsoft certified Excel user, currently working as a Project Manager for a Vancouver based telecommunications firm.

My education is from the University of British Columbia, where I received a Certificate of Project Management in March of 2014. In 2013, I successfully wrote my Microsoft 77-420 exam, certifying me as a Microsoft Excel 2013 Specialist.

In 2012, I started an independent website, consulting as a Microsoft Excel expert for small businesses across North America, and helping them utilize Microsoft Excel for their small business needs.

I am now turning my Excel and Project Management experience and education toward helping others either stand out in their current employment positions, gain new and exciting employment opportunities, or grow their small businesses.

Ready to start learning?
Take This Course