MS Excel 2013 Basic-Intermediate Certified Training
4.3 (9 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.
331 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MS Excel 2013 Basic-Intermediate Certified Training to your Wishlist.

Add to Wishlist

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.
4.3 (9 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.
331 students enrolled
Created by Mike Lange
Last updated 5/2013
English
Price: $25
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
By the end of the course, you will be proficient in Excel 2013 at Intermediate Level
View Curriculum
Requirements
  • Windows 7 or Windows 8, Excel 2013 or Office 365
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.

Who is the target audience?
  • New Excel 2013 Users or Beginner to Intermediate Level Excel Users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 159 Lectures Collapse All 159 Lectures 02:44:16
+
How To Use The Excel 2013 Ribbons
8 Lectures 05:32
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
+
How To Use Workbooks & Worksheets In Excel 2013
16 Lectures 15:06





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
+
How To Enter & Select Data
21 Lectures 23:28
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
+
How To Print With Excel 2013
10 Lectures 10:34
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
+
How To Format Your Workbooks & Worksheets
21 Lectures 20:53
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


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
+
How To Calculate With Excel 2013
20 Lectures 21:05
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

How To Use Averaging Functions
00:51

How To Use Highest & Lowest Functions
00:47

How To Use Absolute Referencing Requirements
00:56

How To Use Formulas Across Worksheets
00:59

How To Use Functions Across Worksheets
00:41

How To Use the SUMIF Function
01:23

How To Use Named Cells & Ranges
01:36

How To Use Pivot Tables
01:50

How To Calculate Depreciation
00:53
+
Making Your Workbooks/Worksheets Secure
6 Lectures 05:57
Why Data Security Matters
00:48

How To Protect A Worksheet
01:00

How To Protect Part Of A Worksheet
00:42

How To Control Access To Cell Ranges
01:00

How To Add Password Protection To A Workbook
01:35

Securing Your Data With Cloud Backups
00:52
+
How & Why To Use Excel Templates
4 Lectures 03:12
What Are Excel Templates & Why Use Them
00:41

How To Use A Template To Create A Workbook
00:37

How To Create A Custom Template
01:15

Where To Find More Excel Templates
00:39
+
How & Why To Use Graphics Objects
11 Lectures 09:03
What Are Graphics Objects
00:33

How To Use Clipart
01:03

How To Use Smart Art Graphics
00:47

How To Insert Drawing Shapes
00:43

How To Insert A Picture
00:43

How To Use Background Images
00:47

How To Format Graphic Objects
01:00

How To Change Stacking Orders & Graphic Objects
01:12

How To Group Graphic Objects
00:34

How To Use Formula Results In A Callout
00:55

How To Insert A Screenshot
00:46
4 More Sections
About the Instructor
Mike Lange
4.3 Average rating
9 Reviews
331 Students
1 Course
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.