Microsoft Excel 2013 Intro and Intermediate Training
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,129 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 Intro and Intermediate Training to your Wishlist.

Add to Wishlist

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,129 students enrolled
Created by Mike Smith
Last updated 6/2014
English
Current price: $10 Original price: $50 Discount: 80% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create spreadsheets
  • Write formulas
  • Format spreadsheets for presentations
  • Simplify and sort data
View Curriculum
Requirements
  • Microsoft Excel 2013 (PC or Mac)
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.

Who is the target audience?
  • Office workers
  • Small business owners
  • Planners
Students Who Viewed This Course Also Viewed
Curriculum For This Course
33 Lectures
03:58:30
+
Introduction to This Course and Microsoft Excel 2013
6 Lectures 46:46


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
+
Inputting Data and Cell Formatting
4 Lectures 40:40
Formatting a Cell (Ctrl+1)
12:23

Fill and Drag
07:32

Creating and Using Tables
09:48

Freeze Panes and Views
10:57
+
Formulas (Part 1)
7 Lectures 01:04:47
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
+
Formulas (Part 2)
5 Lectures 37:08
IF Formulas
08:52

VLOOKUP and HLOOKUP Formulas
09:45

MATCH Formulas
04:28

INDEX Formulas
09:19

IFERROR Formulas
04:44
+
Inputting Data and Cell Formatting (Part 2)
9 Lectures 44:29
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
+
Bonus Lectures
2 Lectures 04:40
Developer Tab
02:30

~ (Show Cell Contents)
02:10
About the Instructor
Mike Smith
4.3 Average rating
16 Reviews
2,129 Students
1 Course
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.