MS Excel 2013 Basic-Intermediate Certified Training

3 Hour+ No Fluff Crash Course. 250+ Happy Udemy Students Already. Watch Only The Function Lessons You Need.
  • Lectures 159
  • Video 3 Hours
  • Skill level all level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

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.

Course Description

158 HD Excel 2013 Lessons

OneHourExcel’s new HD Excel 2013 video training course will have you up and running with Microsoft’s latest version of Excel in no time.

Choose exactly which functions and features you need to learn about and get help from our certified Excel expert Mike Lange within the course.

Watch over-the-shoulder of Mike as he simply explains and demonstrates each important function, feature and shortcut with this new Excel.

You do NOT need to have any previous experience with Excel as Mike will take you through from Beginner or Basic through to Intermediate levels of Excel 2013 proficiency.

Your super-friendly Excel 2013 instructor Mike takes you through all 13 Sections of the course with 158 HD Videos:

  • Excel 2013 Introduction & Basics
  • How To Use The Excel 2013 Ribbons
  • How To Use Workbooks & Worksheets In Excel 2013
  • How To Enter & Select Data
  • How To Print With Excel 2013
  • How To Format Your Workbooks & Worksheets
  • How To Calculate With Excel 2013
  • Making Your Workbooks/Worksheets Secure
  • How & Why To Use Excel Templates
  • How & Why To Use Graphics Objects
  • How & Why To Use Excel 2013 As A Database
  • How & Why To Create Charts In Excel 2013
  • How & Why To Use Skydrive Cloud Service

At the end of the course, you will receive your Certificate of Completion and can ask Mike any follow up questions if you get stuck with Excel 2013.

What are the requirements?

  • Windows 7 or Windows 8, Excel 2013 or Office 365

What am I going to get from this course?

  • Over 159 lectures and 2.5 hours of content!
  • By the end of the course, you will be proficient in Excel 2013 at Intermediate Level

What is the target audience?

  • New Excel 2013 Users or Beginner to Intermediate Level Excel Users

Curriculum

Section 1: Excel 2013 Introduction & Basics
Excel 2013 Overview
Preview
03:38
Workfiles Download
00:53
What Are The Main Differences Between Excel 2010 And Excel 2013?
Preview
02:44
How Does Windows 8 Change Excel 2013
Preview
01:02
How Does The Course Certification Work
Preview
01:07
What You Need To Know About Excel 2013 File Formats
Preview
00:49
What Is A Worksheet
Preview
01:00
What Is A Workbook
Preview
00:33
How To Use The File Menu in Excel 2013
Preview
01:29
Introduction To How To Use Ribbons in Excel 2013
Preview
00:40
How To Use The Quick Access Toolbar in Excel 2013
Preview
00:30
How To Find Help Inside Excel 2013
Preview
00:52
How To Speed Up Excel 2013 Performance
Preview
02:03
Section 2: How To Use The Excel 2013 Ribbons
How To Use The Home Ribbon
00:43
How To Use The Insert Ribbon
00:57
How To Use The Page Layout Ribbon
00:28
How To Use The Formulas Ribbon
00:32
How To Use The Data Ribbon
00:31
How To Use The Review Ribbon
00:27
How To Use The View Ribbon
00:55
How To Move/Customize The Quick Access Toolbar
00:59
Section 3: How To Use Workbooks & Worksheets In Excel 2013
How To Use Workbooks & Worksheets
Preview
00:58
How To Create A New Workbook
Preview
01:03
How & Why To Save As
Preview
01:23
How & Why To Save A Workbook In Different File Formats
Preview
01:22
How To Find Your Way Around A Workbook
Preview
00:51
How To View Recent Workbooks
00:23
How To Work With Columns & Rows
00:37
How To Change Cell Properties Of An Entire Worksheet
01:03
How To Format A Worksheet
00:56
How To Name & Rename Worksheet Tabs
00:41
How To Move Worksheets Within A Workbook
00:43
How To Move Worksheets Between Workbooks
01:00
How To Insert (Add) Worksheets
01:18
How To Delete Worksheets
00:47
How To View Multiple Workbooks
01:09
How & Why To Hide/Unhide Worksheets
00:52
Section 4: How To Enter & Select Data
How To Enter Text In A Workbook Cell
01:56
How To Enter Numbers In A Workbook Cell
00:45
How To Enter Dates & Times In A Workbook Cell
01:24
How To Edit A Cell In A Workbook
00:58
How To Cut, Copy & Paste In A Workbook
01:53
How To Use The Fill Handle
01:12
How & Why To Use Undo & Redo
01:24
How To Use Zoom
00:39
How To Insert & Delete Columns
00:49
How To Insert & Delete Rows
00:52
How To Insert & Delete Cells
01:09
How To Wrap Text In Cells
00:51
How & Why To Change Column Widths
01:04
How & Why To Change Row Heights
00:52
How & Why To Hide/Unhide A Column
01:23
How & Why To Hide/Unhide A Row
01:05
How To Use The Go To Commands
01:32
How To Use Spellcheck
00:58
How To Use The Replace Command
00:56
How To Use The Find Command
00:54
How & Why To Use The Format Painter
00:52
Section 5: How To Print With Excel 2013
How To Preview Printing
01:18
How To Choose The Correct Printer
01:00
How To Print
01:16
How & Why To Adjust Your Page Margins
01:19
How & Why To Change Your Page Orientation
00:49
How To Add Headers & Footers
01:25
How To Use The Page Break View
01:16
How To Use Print Titles For Large Worksheets
00:52
How To Print With Gridlines
00:24
How To Use The New Page Layout View
00:55
Section 6: How To Format Your Workbooks & Worksheets
How To Edit More Than One Worksheet At A Time
01:42
How To Merge Cells
00:48
How To Change Fonts, Font Sizes, Font Colors, Bold, Italics & Underlining
02:03
How To Apply Different Number Formats
00:59
How To Align Aligning Cell Contents
00:33
How To Change The Direction Of Text In A Cell
00:46
How To Add Borders To Cells/Cell Ranges
01:03
How To Apply A Date Format To A Cell/Cell Ranges
00:50
How To Clear Cell Contents
00:28
How & Why To Use Themes In Your Worksheets
00:49
How To Use The Comments Function
01:04
How To Create An Auto Fill List
01:30
How To Turn Data Into A Table
01:02
How To Get Data From A Website
Preview
01:14
What Is Conditional Formatting
00:44
How To Change/Delete Conditional Formatting Rules
00:56
How To Highlight Duplicate Values With Conditional Formatting
00:39
How To Identify The Top Or Bottom Percentage Of Ranges
01:14
How To Use Data Bars
00:53
How To Use Colour Scales
00:42
How To Apply An Icon Set
00:54
Section 7: How To Calculate With Excel 2013
Why Use Excel Calculations
01:14
How To Use Basic Math Formula Addition
00:56
How To Use Basic Math Formula Subtraction
00:30
How To Use Basic Math Formula Multiplication
00:30
How To Use Basic Math Formula Division
00:34
How To Use Basic Math Formula Exponent
00:43
How To Use Operations with BODMAS
01:22
How To Use Excel Formulas SUM
01:14
How To Copy Formulas & Functions
01:32
How To Display Formulae
00:52
How To Use Counting Functions
01:42

Instructor Biography

Mike Lange , OneHourExcel.com

Mike Lange, a MS Excel-certified Australian IT trainer, has extensive experience in Information Technology in South Australian education. He currently also holds Level IV Certification in Information Technology and has worked for many years in Network Management, Access Database Design and Distance Education in South Australia as both a consulting private contractor and on-site staff IT manager. Mike is also ranked in the top 5% of all Excel experts on Elance and his time is currently split between teaching Excel and enjoying the fine wines of South Australia.

Reviews

Average Rating
4.3
Details
  1. 5 Stars
    4
  2. 4 Stars
    1
  3. 3 Stars
    0
  4. 2 Stars
    1
  5. 1 Stars
    0
    • Long Huynh

    Helpful

    For a beginner's review, it was great, and everything was explained well enough to begin an understanding of excel usage.

    • Steven Morris

    great course

    Can't wait for the advanced course

    • Jake Levine

    very informative

    Straight forward and easy to follow. A test at the end would have been nice though.

    • Georgi Petrov

    Quick and straight to the point. Definitely recommended.

    I do have some basic experience with previous versions of Excel and I bought this course because I need to implement more complex tasks with it in my new job and because I am totally confused with the new interface of Excel. The course saved me a lot of time trying to find where did Microsoft put the old feature in the new interface and how to perform some rarely used functions. Already saved me (5 minutes before I had to send those analysis something didn't work because Microsoft moved it to a completely different place) Definitely recommended. Time and trouble saver.

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

0

Hours of video content

21,000,000

Course enrollment

6,200,000

Students

Ready to start learning?
Preview this course