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
100 Lessons (19h)
- Introduction to Excel 20139:12What's New7:31Excel 2013 Beginner-Intermediate Course Exercise Files
- Overview of Principles3:39
- Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns11:20Templates; Creating, Opening, and Saving a Workbook10:54
- Online, Offline, and Contextual Help8:00
- Excel Options11:22
- Ribbon Interface15:00Quick Access Toolbar8:03Mini Toolbar2:58
- Create Backup Option; Auto-Recover and Autosave6:54
- Entering Text and Numbers15:15Date Formats15:57Formatting Cells; Editing and Deleting Data15:15Fill12:51Flash Fill5:08
- Themes and Cell Styles14:01Inserting, Deleting, Hiding and Adjusting Rows and Columns13:28Wrap Text and Alignment15:02Merging Cells; Applying Themes and Styles11:36Borders9: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:17Printing; Headers, Footers and Margins12:57
- Overview of Formulas and Functions14:08Cell References14:50Names15:38Finding 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:35Basic Formatting14:41Selecting Data, Positioning and Printing Charts15:47
- Saving Workbooks; PDF and CSV Formats11:21
- Sorting9:06Filtering10:43Tables12:25
- VLOOKUP12:58Text Function5:17Date and Time Functions5:32Logical Functions18:31
- Financial Analysis Case Study - Part 116:03Financial Analysis Case Study - Part 29:23Quick Analysis Tool7:57
- Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt14:26
- Protecting Worksheets7:42Protecting Workbooks10:02Sharing 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:55Excel 2013 Advanced Course Exercise
- List of Functions; Common Types of Arguments; Basic Use of Functions13:38Advanced Aspects of Functions; Searching for a Function11:00Autosum6:18
- Payment12:48Future Value11:17Principle Payment12:01Depreciations13:25
- How Dates and Times are Stored11:57Dates and Times Calculation12:45Exercise on Date and Time Functions; Date and Time Settings7:25
- Average13:05Percentile10:21Regression14:02LINEST Function9:49Example of Functions for Inferential Statistics12:39
- Text Function Case Study - 114:26Text Function Case Study - 210:35
- Lookup and Reference Functions15:43
- Logical Functions15:59
- Connecting to Other Workbooks16:04Connecting to Access Data14:11Connecting to Web Data10:18
- Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row13:48Inserting Columns and Rows; Resizing Tables15:02Table Reference9:18Table Styles7:07Table Selection4:08
- Basic Principles of Pivot Tables14:58Presentational Side of Pivot Tables15:40Filtering in Pivot Tables; Slices14:06
- What if15:32Scenario Manager14:06Goal Seek7:51Solver14:38
- Area Charts10:39Surface Charts7:40Stock Charts - Part 112:27Stock Charts - Part 212:47Radar Charts5:08Bubble Charts10:20
- Regression and Scatter Chart7:00
- Creating Pivot Charts12:32
- Using Sparklines15:30
- Creating Workbooks using a Web App15:15Sharing your Workbook10:00
- Closing0:19
- Quiz - Microsoft Excel 2013 Advanced
- Excel 2013 Keyboard ShortcutsCourse Transcript for Excel 2013 Beginners CourseCourse Transcripts for Excel 2013 Advanced CourseMP3 Excel 2013 Audio FilesMP3 Excel 2013 Advanced Audio Files
The Ultimate Microsoft Excel 2013 Training
$29.00$177.0083% OFF
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.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...


