Excel 2013
4.7 (14 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.
148 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013 to your Wishlist.

Add to Wishlist

Excel 2013

Online Excel training is designed to create a strong foundation for using the world's most popular business software.
4.7 (14 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.
148 students enrolled
Created by Learn iT! Anytime
Last updated 6/2013
English
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 12.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Become a Master in the Work Place using Excel 2013
View Curriculum
Requirements
  • None
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.

Who is the target audience?
  • Everyone
Students Who Viewed This Course Also Viewed
Curriculum For This Course
101 Lectures
12:27:09
+
Essentials and Intro to Formulas and Functions
12 Lectures 01:59:52


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
+
Formatting, Spreadsheet Design, Page Setup and Printing
14 Lectures 02:26:54
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
+
List/Table Essentials and Charting
19 Lectures 02:16:55
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
+
Importing Data, Pivot Tables, Protecting and Linking Data
21 Lectures 02:25:01
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
+
Creating Functions
13 Lectures 01:28:47
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
+
Advanced Tools
22 Lectures 01:49:40
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

Record a Formatting Macro
04:45

Better Formatting Macro
03:50

Add Form Buttons
04:17

QA Macro Buttons
03:38

Introduction to Skydrive
01:02

Skydrive
08:28

Course Check List
01:01
About the Instructor
Learn iT! Anytime
4.4 Average rating
526 Reviews
4,856 Students
21 Courses
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.