Excel 2013

Online Excel training is designed to create a strong foundation for using the world's most popular business software.
4.6 (8 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.
132 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 101
  • Length 12.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

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.

About This Course

Published 6/2013 English Closed captions available

Course Description

Online Excel training is designed to create a strong foundation for using the world's most popular business software as a place to organize and analyze information. Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of advanced formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet. This  12 hour online Excel course is designed for individuals, Career Changers, and skill enhancement.

What are the requirements?

  • None

What am I going to get from this course?

  • Become a Master in the Work Place using Excel 2013

What is the target audience?

  • Everyone

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Essentials and Intro to Formulas and Functions
Introduction and the Ribbon
Preview
07:37
Interactive Guides
Preview
05:58
Navigating
07:58
QA Toolbar
04:48
More QA Toolbar Part
09:28
Formulas
14:07
Saving Files
03:01
Functions
17:27
Continued Formuli
10:55
Troubleshooting Issues
27:48
Compatibility Issues
09:44
Course Check List
01:01
Section 2: Formatting, Spreadsheet Design, Page Setup and Printing
Fill Handle
21:12
Copying and Pasting
18:57
Auto-fill Series Formatting and Styles
16:52
Styles and Themes
10:05
Templates
13:12
Working with Worksheets
11:28
Copying Entire Worksheets
03:44
Custom View
09:28
Spell Check in Excel
06:55
Working with Large Worksheets
08:17
Split Screen
03:53
Printing
16:14
Page Layout View
05:36
Course Check List
01:01
Section 3: List/Table Essentials and Charting
Flash Fill
08:03
Well Defined List
07:14
Sorting
07:42
Sort by Then
06:22
Formatting
05:03
Format as Table
04:21
Filtering
04:30
Multi-Field Filtering
07:48
Remove Duplicates
07:53
Inserting Automatic Subtotals
15:43
Column Line Charts
26:44
Pie Chart
07:15
Formatting Charts
01:12
Chart Templates
04:18
Recommended Charts and Quick Analysis Tools
06:16
Printing Charts
04:23
Sparklines
08:22
Review
02:45
Course Check List
01:01
Section 4: Importing Data, Pivot Tables, Protecting and Linking Data
Importing Data from Sources
20:36
Importing Database File
13:23
Pivot Tables
11:22
Custom Pivot Tables
05:31
Advanced Pivot Tables
02:52
Pivot Table Exercise
06:12
Formatting Pivot Tables
01:28
Slicer Tool
04:06
Pivot Charts
06:43
Filtering Charts
01:58
Data Validation
12:11
Rules
03:06
Conditional Formatting
07:34
Advanced Conditional Formatting
05:55
Manage Rules of Conditional Formatting
04:57
Conditional Formatting Data Validation
04:21
Protecting Worksheets
12:12
Comments
02:46
Printing Comments
04:31
Linking Data Between Worksheets
12:16
Course Check List
01:01
Section 5: Creating Functions
Named Ranges
14:24
Logical Functions
02:42
If Functions
10:56
Nested Functions
11:48
Lookup Functions
08:02
V Lookup
05:18
Database Function Sumif
06:40
Database Function Averageif
02:55
Database Function Sumifs
04:08
If Error Functions
03:45
V Lookup Range
05:05
Date Functions
12:03
Course Check List
01:01
Section 6: Advanced Tools
Consolidate Data
07:06
Consolidate with Different Layouts
07:27
Intro to Goal Seek Tool
02:34
Goal Seek Tool
06:52
Installing Solver Tool Add-In
01:52
Solver Basic Sheet
00:24
The Solver Tool
11:03
PMT Data Table Worksheet
02:36
Data Table Command
03:41
Two Variable Data Table
02:51
Scenario Manager
13:40
Adding Developers Tab
01:41
Recording a Macro
13:31
Running Your Macro
02:43
Recording Macros with Relative References
04:38

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Learn iT! Anytime, Self-Paced Online Training Videos

Learn iT! Anytime is an online training provider with over 20 years of experience teaching to more than 450,000 students, including industry leaders. Our self-paced e-Learning helps you gain new skills, quickly and convieniently. If you're serious about learning, we're serious about providing you with the best content for your learning needs.

Ready to start learning?
Take This Course