The Ultimate Microsoft Excel 2013 Training

19 Hours

$29.00$177.00

You save 83%

100 Lessons (19h)

Chapter 1: Introduction
Introduction to Excel 20139:12
What's New7:31
Excel 2013 Beginner-Intermediate Course Exercise Files
Chapter 2: Using Touch
Overview of Principles3:39
Chapter 3: Getting Started
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns11:20
Templates; Creating, Opening, and Saving a Workbook10:54
Chapter 4: Help
Online, Offline, and Contextual Help8:00
Chapter 5: Settings and Preferences
Excel Options11:22
Chapter 6: The Ribbon and Toolbars
Ribbon Interface15:00
Quick Access Toolbar8:03
Mini Toolbar2:58
Chapter 7: Backup and Recovery
Create Backup Option; Auto-Recover and Autosave6:54
Chapter 8: Entering and Deleting Data
Entering Text and Numbers15:15
Date Formats15:57
Formatting Cells; Editing and Deleting Data15:15
Fill12:51
Flash Fill5:08
Chapter 9: Formatting a Worksheet
Themes and Cell Styles14:01
Inserting, Deleting, Hiding and Adjusting Rows and Columns13:28
Wrap Text and Alignment15:02
Merging Cells; Applying Themes and Styles11:36
Borders9:25
Chapter 10: Copy, Paste and Paste Special
Copy, Cut and Paste17:06
Chapter 11: Proofing
Spell checking11:57
Chapter 12: Managing Worksheets
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets14:51
Chapter 13: Comments
Inserting Comments6:54
Chapter 14: Viewing and Printing
Workbook Views, Zoom and Freeze11:17
Printing; Headers, Footers and Margins12:57
Chapter 15: Formulas and Functions
Overview of Formulas and Functions14:08
Cell References14:50
Names15:38
Finding Errors; New Excel Functions14:13
Chapter 16: Working with Workbooks
Multiple Workbooks and Windows; Comparing Workbooks10:39
Chapter 17: Find and Replace
Go to; Find and Replace Options11:14
Chapter 18: Conditional Formatting
Applying, Clearing and Managing Rules15:35
Chapter 19: Graphing and Charting
Chart Types; Chart Recommendation13:35
Basic Formatting14:41
Selecting Data, Positioning and Printing Charts15:47
Chapter 20: File Types
Saving Workbooks; PDF and CSV Formats11:21
Chapter 21: Managing Data
Sorting9:06
Filtering10:43
Tables12:25
Chapter 22: Functions Case Study
VLOOKUP12:58
Text Function5:17
Date and Time Functions5:32
Logical Functions18:31
Chapter 23: Analyzing Data
Financial Analysis Case Study - Part 116:03
Financial Analysis Case Study - Part 29:23
Quick Analysis Tool7:57
Chapter 24: Shapes and Pictures
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt14:26
Chapter 25: Sharing and Protecting
Protecting Worksheets7:42
Protecting Workbooks10:02
Sharing and SkyDrive14:24
Chapter 26: More Backstage View Options
Trust Center; Export; Inspect Workbook5:33
Chapter 27: Closing
Summary; More Help1:49
Chapter 28: Course Quiz
Quiz - Learn Microsoft Excel 2013 Beginners Course
Chapter 1: Introduction
Pre-requisites of Excel 2013 Advanced Course9:55
Excel 2013 Advanced Course Exercise
Chapter 2: Functions
List of Functions; Common Types of Arguments; Basic Use of Functions13:38
Advanced Aspects of Functions; Searching for a Function11:00
Autosum6:18
Chapter 3: Personal and Professional Financial Functions
Payment12:48
Future Value11:17
Principle Payment12:01
Depreciations13:25
Chapter 4: Date and Time Functions
How Dates and Times are Stored11:57
Dates and Times Calculation12:45
Exercise on Date and Time Functions; Date and Time Settings7:25
Chapter 5: Statistical Functions for Description, Prediction and Interference
Average13:05
Percentile10:21
Regression14:02
LINEST Function9:49
Example of Functions for Inferential Statistics12:39
Chapter 6: Text Functions
Text Function Case Study - 114:26
Text Function Case Study - 210:35
Chapter 7: Lookup Functions
Lookup and Reference Functions15:43
Chapter 8: Logical Functions
Logical Functions15:59
Chapter 9: Connecting to External Data
Connecting to Other Workbooks16:04
Connecting to Access Data14:11
Connecting to Web Data10:18
Chapter 10: Tables
Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row13:48
Inserting Columns and Rows; Resizing Tables15:02
Table Reference9:18
Table Styles7:07
Table Selection4:08
Chapter 11: Pivot Tables
Basic Principles of Pivot Tables14:58
Presentational Side of Pivot Tables15:40
Filtering in Pivot Tables; Slices14:06
Chapter 12: Data Analysis
What if15:32
Scenario Manager14:06
Goal Seek7:51
Solver14:38
Chapter 13: Charts
Area Charts10:39
Surface Charts7:40
Stock Charts - Part 112:27
Stock Charts - Part 212:47
Radar Charts5:08
Bubble Charts10:20
Chapter 14: Graphs
Regression and Scatter Chart7:00
Chapter 15: Pivot Charts
Creating Pivot Charts12:32
Chapter 16: Sparklines
Using Sparklines15:30
Chapter 17: Web App
Creating Workbooks using a Web App15:15
Sharing your Workbook10:00
Chapter 18: Conclusion
Closing0:19
Chapter 19: Course Quiz
Quiz - Microsoft Excel 2013 Advanced
Bonus Materials
Excel 2013 Keyboard Shortcuts
Course Transcript for Excel 2013 Beginners Course
Course Transcripts for Excel 2013 Advanced Course
MP3 Excel 2013 Audio Files
MP3 Excel 2013 Advanced Audio Files

DescriptionInstructorImportant DetailsRelated Products

Become a Master of This Essential Office Software

Simon Sez ItSince 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 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Description

Microsoft Excel is the far and away leader in spreadsheet software and is used by all types of businesses throughout the world. Knowing Excel basics is perhaps one of the most essential modern computing skills, while become a real master of this software will allow you to solve complex number problems and manage data with ease.

Access over 100 lectures & 19 hours of content 24/7
Understand data entry, cell formatting, working w/ multiple worksheets & the "Ribbon" interface
Gain tips for mouse & touch screen use
Implement graphs & charts using templates or custom designs
Use SkyDrive & other tools for sharing work
Work w/ flash fill, dates & times
Learn how to calculate averages, percentiles, depreciation & LINEST functions
Practice your Excel expertise w/ included exercise files

Specs

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels

Compatibility

Internet required
Microsoft Excel 2013 required

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...