Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to This Course and Microsoft Excel 2013|
What is Excel / Introduction to Basic FormulasPreview
The Microsoft Excel 2013 Certification Exam (77-420)
Creating an Excel Workbook
Navigating Excel 2013
|Section 2: Inputting Data and Cell Formatting|
Formatting a Cell (Ctrl+1)
Fill and Drag
Creating and Using Tables
Freeze Panes and Views
|Section 3: Formulas (Part 1)|
MAX, MIN, SUM and AVERAGE Formulas
LEFT, RIGHT and MID Formulas
WEEKDAY, WORKDAY and NETWORKDAY Formulas
|Section 4: Formulas (Part 2)|
VLOOKUP and HLOOKUP Formulas
|Section 5: Inputting Data and Cell Formatting (Part 2)|
Inserting and Formatting Pictures
COPY and PASTE Types
Grouping Rows and Columns
Locking or Hiding Cell Contents
Sort and Filter
|Section 6: Bonus Lectures|
~ (Show Cell Contents)
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.