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.
6 reviews
TAUGHT BY
  • 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.

WHAT'S INSIDE
  • Lifetime access to 159 lectures
  • 2+ hours of high quality content
  • A community of 300+ students learning together!
SHARE

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.
6 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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.

    • Windows 7 or Windows 8, Excel 2013 or Office 365
    • 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
    • New Excel 2013 Users or Beginner to Intermediate Level Excel Users

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

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

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students

RATING

  • 4
  • 1
  • 0
  • 1
  • 0
AVERAGE RATING
NUMBER OF RATINGS
6

REVIEWS

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

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED: