The Ultimate Microsoft Excel 2013 Training

The Ultimate Microsoft Excel 2013 Training

19 Hours
Deal Price$29.00
Suggested Price
$177.00
You save 83%
The Ultimate Microsoft Excel 2013 Training
$29.00$177.0083% OFF
The Ultimate Microsoft Excel 2013 Training

100 Lessons (19h)

  • Introduction to Excel 20139:12
    What's New7:31
    Excel 2013 Beginner-Intermediate Course Exercise Files
  • Overview of Principles3:39
  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns11:20
    Templates; Creating, Opening, and Saving a Workbook10:54
  • Online, Offline, and Contextual Help8:00
  • Excel Options11:22
  • Ribbon Interface15:00
    Quick Access Toolbar8:03
    Mini Toolbar2:58
  • Create Backup Option; Auto-Recover and Autosave6:54
  • Entering Text and Numbers15:15
    Date Formats15:57
    Formatting Cells; Editing and Deleting Data15:15
    Fill12:51
    Flash Fill5:08
  • 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
  • Copy, Cut and Paste17:06
  • Spell checking11:57
  • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets14:51
  • Inserting Comments6:54
  • Workbook Views, Zoom and Freeze11:17
    Printing; Headers, Footers and Margins12:57
  • Overview of Formulas and Functions14:08
    Cell References14:50
    Names15:38
    Finding Errors; New Excel Functions14:13
  • Multiple Workbooks and Windows; Comparing Workbooks10:39
  • Go to; Find and Replace Options11:14
  • Applying, Clearing and Managing Rules15:35
  • Chart Types; Chart Recommendation13:35
    Basic Formatting14:41
    Selecting Data, Positioning and Printing Charts15:47
  • Saving Workbooks; PDF and CSV Formats11:21
  • Sorting9:06
    Filtering10:43
    Tables12:25
  • VLOOKUP12:58
    Text Function5:17
    Date and Time Functions5:32
    Logical Functions18:31
  • Financial Analysis Case Study - Part 116:03
    Financial Analysis Case Study - Part 29:23
    Quick Analysis Tool7:57
  • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt14:26
  • Protecting Worksheets7:42
    Protecting Workbooks10:02
    Sharing and SkyDrive14:24
  • Trust Center; Export; Inspect Workbook5:33
  • Summary; More Help1:49
  • Quiz - Learn Microsoft Excel 2013 Beginners Course
  • Pre-requisites of Excel 2013 Advanced Course9:55
    Excel 2013 Advanced Course Exercise
  • List of Functions; Common Types of Arguments; Basic Use of Functions13:38
    Advanced Aspects of Functions; Searching for a Function11:00
    Autosum6:18
  • Payment12:48
    Future Value11:17
    Principle Payment12:01
    Depreciations13:25
  • How Dates and Times are Stored11:57
    Dates and Times Calculation12:45
    Exercise on Date and Time Functions; Date and Time Settings7:25
  • Average13:05
    Percentile10:21
    Regression14:02
    LINEST Function9:49
    Example of Functions for Inferential Statistics12:39
  • Text Function Case Study - 114:26
    Text Function Case Study - 210:35
  • Lookup and Reference Functions15:43
  • Logical Functions15:59
  • Connecting to Other Workbooks16:04
    Connecting to Access Data14:11
    Connecting to Web Data10:18
  • 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
  • Basic Principles of Pivot Tables14:58
    Presentational Side of Pivot Tables15:40
    Filtering in Pivot Tables; Slices14:06
  • What if15:32
    Scenario Manager14:06
    Goal Seek7:51
    Solver14:38
  • Area Charts10:39
    Surface Charts7:40
    Stock Charts - Part 112:27
    Stock Charts - Part 212:47
    Radar Charts5:08
    Bubble Charts10:20
  • Regression and Scatter Chart7:00
  • Creating Pivot Charts12:32
  • Using Sparklines15:30
  • Creating Workbooks using a Web App15:15
    Sharing your Workbook10:00
  • Closing0:19
  • Quiz - Microsoft Excel 2013 Advanced
  • 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
The Ultimate Microsoft Excel 2013 Training
$29.00$177.0083% OFF
View similar items

Become a Master of This Essential Office Software

SS
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.
Processing order...