The Ultimate Microsoft Excel 2010 and 2013 Training Bundle
4.3 (67 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.
4,614 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Ultimate Microsoft Excel 2010 and 2013 Training Bundle to your Wishlist.

Add to Wishlist

The Ultimate Microsoft Excel 2010 and 2013 Training Bundle

Can You Use The Internet? If Yes, Then You Can Master Microsoft Excel 2010 and 2013 The Easy Way - On Your Schedule
4.3 (67 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.
4,614 students enrolled
Created by Simon Sez IT
Last updated 1/2017
English
Price: $200
30-Day Money-Back Guarantee
Includes:
  • 33.5 hours on-demand video
  • 6 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Essential training for Microsoft Excel 2010
Essential training for Microsoft Excel 2013
Advanced level training for Microsoft Excel 2010
Advanced level training for Microsoft Excel 2013
View Curriculum
Requirements
  • Microsoft Excel 2010
  • Microsoft Excel 2013
Description

Just about everyone will find themselves having to use Microsoft Excel at work at one point or another, and 2010 and 2013 are two of the most popular, and powerful, versions around. That means that everyone could benefit from devoting some time to mastering the program, as Excel mastery can not only have a huge impact on your own productivity, but can look hugely impressive to your boss.

With our Ultimate Microsoft Excel Training Bundle you’ll find basic and advanced courses for both Microsoft Excel 2010 and 2013 so that you’re ready to go, no matter what version of the software you’re faced with.

This bundle includes:

  • 33 hours of video tutorials
  • Over 200 individual video lectures
  • 4 quizzes with 165 test questions
  • Certificate of completion

Courses included with this bundle:

Microsoft Excel 2013 Beginners/Intermediate Training

During this 10-hour Online Excel 2013 Training, you’ll learn to create Excel spreadsheets with ease. Our expert instructor will show you Excel 2013 features to navigate you through the program. Starting with the basics, you’ll discover how to enter and format data in the quickest manner possible. Next you’ll be introduced to the power of Excel’s functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, your instructor will then walk you through how to create sophisticated charts and graphs, and publish them online. Finally, you’ll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise.

Learn Microsoft Excel 2013 - Advanced

Your expert instructor will kick the course off by leading you through graph and chart basics. Then, you’ll explore Excel’s array of detailed formatting tools and discover how to make these work for you when graphing and charting financial information. Next, you’ll explore the roles played by trends, relationships, and differences in charts, and how to work with sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts, and more.

Learn Microsoft Excel 2010

Our professional instructor will talk you through Excel 2010’s features, starting with the basics, from creating files to editing existing documents. Next you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then move onto sorting and filtering data, linking multiple files, and, finally, working with some more advanced formulas.

Learn Microsoft Excel 2010 - Advanced

Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. Excel’s tools are covered in depth which includes discussions on and are setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. You can move columns and rows to understand how the numbers relate more easily than ever before.

Where else can you find so many extra tools to help you gain advanced skills in Excel?

So start learning today.

What people are saying:

"I am now a business analyst and I attribute my promotion directly to your courses. I’m much more savvy and confident with Excel. Thanks Simon."

-Daniel Venti

"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."

- TopTenReviews.com

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

Who is the target audience?
  • Anyone new to Microsoft Excel and those upgrading from previous software versions.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 209 Lectures Collapse All 209 Lectures 33:32:50
+
Learn Microsoft Excel 2013 Beginner Course
56 Lectures 10:13:30

Essential Information for a Successful Training Experience
01:36

Excel 2013 Exercise Files
00:25


Using Touch
03:39

Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
11:20

Templates; Creating, Opening, and Saving a Workbook
10:54

Online, Offline, and Contextual Help
08:00

Excel Options
11:22



Mini Toolbar
02:58

Create Backup Option; Auto-Recover and Autosave
06:54

Entering Text and Numbers
15:15

Date Formats
15:57

Formatting Cells; Editing and Deleting Data
15:15



Themes and Cell Styles
14:01

Inserting, Deleting, Hiding and Adjusting Rows and Columns
13:28

Wrap Text and Alignment
15:02

Merging Cells; Applying Themes and Styles
11:36

Borders
09:25

Copy, Cut and Paste
17:06

Spell checking
11:57

Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
14:51

Inserting Comments
06:54

Workbook Views, Zoom and Freeze
11:18

Printing; Headers, Footers and Margins
12:57

Overview of Formulas and Functions
14:08

Cell References
14:50

Names
15:38

Finding Errors; New Excel Functions
14:13

Multiple Workbooks and Windows; Comparing Workbooks
10:39

Go to; Find and Replace Options
11:14

Applying, Clearing and Managing Rules
15:35


Basic Formatting
14:41

Selecting Data, Positioning and Printing Charts
15:47

Saving Workbooks; PDF and CSV Formats
11:21


Filtering
10:43

Tables
12:25

VLOOKUP
12:58

Text Function
05:17

Date and Time Functions
05:32

Logical Functions
18:31

Financial Analysis Case Study - Part 1
16:03

Financial Analysis Case Study - Part 2
09:23

Quick Analysis Tool
07:57

Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
14:27

Protecting Worksheets
07:42

Protecting Workbooks
10:02

Sharing and SkyDrive
14:25

Trust Center; Export; Inspect Workbook
05:33

Summary; More Help
01:49

Excel 2013 Quiz
45 questions
+
Learn Microsoft Excel 2013 Advanced Training Course
50 Lectures 09:08:24

Essential Information for a Successful Training Experience
01:36

Excel 2013 Advanced Exercise Files
00:26





Future Value
11:17

Principle Payment
12:02

Depreciations
13:25

How Dates and Times are Stored
11:57

Dates and Times Calculation
12:45

Exercise on Date and Time Functions; Date and Time Settings
07:25

Average
13:05

Percentile
10:21

Regression
14:02

LINEST Function
09:49

Example of Functions for Inferential Statistics
12:39


Text Function Case Study - 2
10:35

Lookup and Reference Functions
15:43

Logical Functions
16:00

Connecting to Other Workbooks
16:04

Connecting to Access Data
14:11

Connecting to Web Data
10:18

Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
13:49

Inserting Columns and Rows; Resizing Tables
15:03

Table Reference
09:18

Table Styles
07:07

Table Selection
04:08

Basic Principles of Pivot Tables
14:58

Presentational Side of Pivot Tables
15:40

Filtering in Pivot Tables; Slices
14:06

What if
15:32

Scenario Manager
14:07

Goal Seeker
07:51

Solver
14:38


Surface Charts
07:40

Stock Charts - Part 1
12:27

Stock Charts - Part 2
12:48

Radar Charts
05:08

Bubble Charts
10:21

Regression and Scatter Chart
07:00

Creating Pivot Charts
12:32

Using Sparklines
15:30

Creating Workbooks using a Web App
15:15

Sharing your Workbook
10:00

Closing
00:19

Excel 2013 Advanced Quiz
45 questions

+
Learn Microsoft Excel 2010 Beginner Course
72 Lectures 07:08:28

Essential Information for a Successful Training Experience
01:17



Excel Options
02:44

Entering Text and Numbers
05:39

Creating Basic Formulas
06:55

Relative References
01:54

Order of Operations
04:33

Working with Ranges
05:03

Working with Save and Save As Commands
05:22

File Extensions
03:48

Opening a File
04:37

Working with Larger Files
06:27


Split Screen Option
03:43

Page Setup Options
05:11

Headers and Footers
07:37

Print Titles
02:29

Comments
04:22

Fit to Print on One Page
05:11

Printing Workbooks
02:21

Adding and Deleting Rows, Columns, and Cells
05:41

Changing Column and Row Widths
04:40

Cut, Copy and Paste
06:22


Overview of Formulas
03:01

Create Formulas using Functions - Part 1
10:21

Create Formulas using Functions - Part 2
06:55

Absolute Values
05:44

Adding, Deleting and Renaming Sheets
06:25

Additional Sheet Tab Options
05:09

3-D Formulas
07:13

Cell Formatting
12:17

Number Formatting
10:00

Borders and Shading
09:32

Format as Table
06:56

Using Styles
09:14

Using Format Painter
04:40

Protecting Worksheets
11:27

Fill Handle and Custom Lists
07:11

Creating Charts
11:12


Editing Charts
10:20

Using Graphics to Enhance Charts
05:41

Managing Names
02:36

Creating Range Names
10:21

Using Names in Formulas
05:29

Removing Duplicates
08:56

Sort Data
11:11

Filter Data
11:31

Advanced Filters
04:00

Creating an Outline - Part 1
08:11

Creating an Outline - Part 2
05:09

Subtotals
09:41

New Window Option
03:08

Arrange File Options
02:40

Creating a Workspace
04:16

Custom Views
06:10

Scenarios
06:32

Creating Formulas Between Files
07:59

Working with Links
04:36

IF Statement
09:23

VLookups
07:05

Consolidating Data
04:39

Data Validation
09:39

Formula Auditing
04:01

Comments
06:08

Goal Seeker
02:05

Text to Columns Option
02:28

Watch Window
02:58

Closing Video
00:28

Excel 2010 Quiz
37 questions
+
Learn Microsoft Excel 2010 Advanced
31 Lectures 07:02:48

Essential Information for a Successful Training Experience
01:17



Additional Features to Help Create Charts/Graphs Part 2
14:28

Detailed Formatting for Charts/Graphs
13:03

Formatting Legends within Charts/Graphs
14:48

Formatting Axes and Gridlines within Charts/Graphs
15:47


Complex Trends within Charts and Graphs
14:41

Trends over Time within Charts and Graphs
15:28

Showing Differences Using Bar Charts
15:11

Showing Differences Using Pie Charts
15:30

Limitations with Pie Charts & How to Correct
16:20

Alternative Ways to Show Differences
13:28

Using Charts & Graphs to Show Relationships
15:23

Using Charts & Graphs to Show Relationships Part 2
15:34

Charting & Graphing Financial Information
15:15

Charting & Graphing Financial Information Part 2
11:06

Specific Charts for Finance Information
14:36

Setting Up Live Charts
14:38

Using Sparklines for Data Visualization
14:26

Using and Formatting Data Bars, Color Scales & Icon Sets
17:08

Setting Up Pivot Tables/Charts
14:32

Setting Up Pivot Tables/Charts Part 2
14:30

Filtering Pivot Tables/Charts
13:04

New Features for Pivot Tables/Charts
13:20

Graphics Tools
15:07

Graphics Tools Part 2
13:32

Exporting Charts and Graphs
15:09

Exporting Charts and Graphs Part 2
14:59

Excel 2010 Advanced Quiz
35 questions
About the Instructor
Simon Sez IT
4.4 Average rating
8,794 Reviews
281,286 Students
109 Courses
280,000+ Students | Wordwide Use 180 Countries |115 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 280,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.