The Ultimate Microsoft Excel 2013 Training Bundle - 19 Hours

The Drop-Dead Simple Method to Mastering Microsoft Excel 2013, Without Books, in Less Time Than You Thought
4.5 (56 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,283 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 105
  • Length 19.5 hours
  • Skill Level All Levels
  • Languages English
  • 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 11/2013 English

Course Description

Microsoft Excel is, by a long way, the most widely-used spreadsheet software out there, and the 2013 edition is the most powerful and versatile version yet. Packed with new features and design changes, Microsoft Excel 2013 has plenty to offer for any company.

Whether you're new to Excel, or just looking to update your knowledge to the latest version, you'll find that the Ultimate Microsoft Excel 2013 Training Bundle will help you put together stunning and impressive spreadsheets with ease, helping you to stand out in the workplace and impress your boss.

This bundle includes:

  1. 19.5 hours of video tutorials
  2. Over 100 individual video lectures
  3. 2 quizzes with 90 test questions
  4. 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.

Turn your long lists of numbers into slick, engaging visuals that bring data to life. Whether you need to create budgets, financial projections, invoices, calendars, schedules, or lists, our elaborate Excel 2013 Tutorial will give you the skills you need to stand out at work.

Learn Microsoft Excel 2013 – Advanced

Colorful charts, sleek graphs, and cutting-edge databases that offer insight into financial information are a breeze when you learn the secrets of creating sophisticated spreadsheets in our Learn Excel 2013 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class.

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.

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

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."- Top Ten Reviews

"Generally I wouldn't find this type of course all that interesting. However, I have found in my current job search that it is a necessary part of my tech skill set in which to become proficient. So, I'm very appreciative that courses like this are offered, and taught by an extremely knowledgeable instructor, who explains lessons clearly and offers opportunities to practice the theme which he has just gone over. He was thorough, and not in the least bit condescending, which I can't say for instructors I have had in the past. So, thank you."- Mary Price

"This is a fantastic intro to the advanced operations in Excel 2013."- Terril Wright

"This is the one....Simon Sez IT has always been my favorite. Excellent contribution by the author. The lectures are informative and engaging. Style of teaching is enterprising."- Jay Dhruv

"The best beginners course out there. Very easy to follow, throughout and detailed explanation to each function and step shown in the process. Ideal learning curve for the total Excel newbie like me."- Daniel Salwerowicz

"Excellent course. I have some experience with Excel but this course really helped me know the functions available in it and how to use them. The instructor explains the subject very patiently and clearly so the student can follow along and master the details. Production quality was good."- Vikram Hegde

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

What are the requirements?

  • Microsoft Excel 2013

What am I going to get from this course?

  • Practice with included exercise files.
  • Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • Tips for mouse and touch screen users.
  • Graphs and charts using templates or custom designs.
  • SkyDrive and other tools for sharing work.
  • Pivot tables and slicing.
  • Working with flash fill.
  • Working with dates and times.
  • Averages, percentiles, and LINEST functions.
  • Calculating depreciation.
  • Inserting and formatting tables.
  • Sparklines and data bars.
  • Pivot charts.

What is the target audience?

  • Anyone new to Microsoft Excel or upgrading from a previous version.

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: Excel 2013 Beginners: Introduction
Introduction to Excel 2013
Preview
09:12
IMPORTANT - Read this to ensure the best video quality!
Article
Excel 2013 Exercise Files
Article
What's New
Preview
07:31
Section 2: Excel 2013 Beginners: Using Touch
Overview of Principles
03:39
Section 3: Excel 2013 Beginners: Getting Started
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
11:20
Templates; Creating, Opening, and Saving a Workbook
10:54
Section 4: Excel 2013 Beginners: Help
Online, Offline, and Contextual Help
08:00
Section 5: Excel 2013 Beginners: Settings and Preferences
Excel Options
Preview
11:22
Section 6: Excel 2013 Beginners: The Ribbon and Toolbars
Ribbon Interface
Preview
15:00
Quick Access Toolbar
08:03
Mini Toolbar
02:58
Section 7: Excel 2013 Beginners: Backup and Recovery
Create Backup Option; Auto-Recover and Autosave
06:54
Section 8: Excel 2013 Beginners: Enterting and Deleting Data
Entering and Deleting Data
Preview
15:15
Date Formats
15:57
Formatting Cells; Editing and Deleting Data
15:15
Fill
12:51
Flash Fill
Preview
05:08
Section 9: Excel 2013 Beginners: Formatting a Worksheet
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
Section 10: Excel 2013 Beginners: Copy, Paste and Paste Special
Copy, Cut and Paste
17:06
Section 11: Excel 2013 Beginners: Proofing
Spell checking
11:57
Section 12: Excel 2013 Beginners: Managing Worksheets
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
14:51
Section 13: Excel 2013 Beginners: Comments
Inserting Comments
06:54
Section 14: Excel 2013 Beginners: Viewing and Printing
Workbook Views, Zoom and Freeze
11:18
Printing; Headers, Footers and Margins
12:57
Section 15: Excel 2013 Beginners: Formulas and Functions
Overview of Formulas and Functions
Preview
14:08
Cell References
14:50
Names
15:38
Finding Errors; New Excel Functions
14:13
Section 16: Excel 2013 Beginners: Working with Workbooks
Multiple Workbooks and Windows; Comparing Workbooks
10:39
Section 17: Excel 2013 Beginners: Find and Replace
Go to; Find and Replace Options
11:14
Section 18: Excel 2013 Beginners: Conditional Formatting
Applying, Clearing and Managing Rules
15:35
Section 19: Excel 2013 Beginners: Graphing and Charting
Chart Types; Chart Recommendation
Preview
13:35
Basic Formatting
14:41
Selecting Data, Positioning and Printing Charts
15:47
Section 20: Excel 2013 Beginners: File Types
Saving Workbooks; PDF and CSV Formats
11:21
Section 21: Excel 2013 Beginners: Managing Data
Sorting
09:06
Filtering
10:43
Tables
12:25
Section 22: Excel 2013 Beginners: Functions Case Study
VLOOKUP
12:58
Text Function
05:17
Date and Time Functions
05:32
Logical Functions
18:31
Section 23: Excel 2013 Beginners: Analyzing Data
Financial Analysis Case Study - Part 1
Preview
16:03
Financial Analysis Case Study - Part 2
09:23
Quick Analysis Tool
07:57
Section 24: Excel 2013 Beginners: Shapes and Pictures
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
14:27
Section 25: Excel 2013 Beginners: Sharing and Protecting
Protecting Worksheets
07:42
Protecting Workbooks
10:02
Sharing and SkyDrive
14:25
Section 26: Excel 2013 Beginners: More Backstage View Options
Trust Center; Export; Inspect Workbook
05:33
Section 27: Excel 2013 Beginners: Closing
Summary; More Help
01:49
Excel 2013 Quiz
45 questions
Section 28: Excel 2013 Advanced: Introduction
Prerequisites of Excel 2013 Advanced Course
Preview
09:55
Course Review
00:43
Excel 2013 Advanced Exercise Files
Article
Section 29: Excel 2013 Advanced: Functions
List of Functions; Common Types of Arguments; Basic Use of Functions
Preview
13:38
Advanced Aspects of Functions; Searching for a Function
11:00
Autosum
06:18
Section 30: Excel 2013 Advanced: Personal and Professional Financial Functions
Payment
12:48
Future Value
Preview
11:17
Principle Payment
12:02
Depreciations
13:25
Section 31: Excel 2013 Advanced: Date and Time Functions
How Dates and Times are Stored
11:57
Dates and Times Calculation
12:45

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 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,000+ 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 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course