Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Ultimate Microsoft Excel 2010 and 2013 Training Bundle
Rating: 4.4 out of 5(147 ratings)
4,880 students

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
Created bySimon Sez IT
Last updated 3/2023
English

What you'll 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

Course content

5 sections217 lectures35h 36m total length
  • Introduction9:12
  • WATCH ME: Essential Information for a Successful Training Experience2:03
  • DOWNLOAD ME: Excel 2013 Exercise Files0:22
  • Downloadable Course Transcript0:21
  • What's New7:31
  • Using Touch3: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:18
  • 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:27
  • Protecting Worksheets7:42
  • Protecting Workbooks10:02
  • Sharing and SkyDrive14:25
  • Trust Center; Export; Inspect Workbook5:33
  • Summary; More Help1:49
  • Excel 2013 Quiz

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 love how this is broken down into bite sized chunks & the lectures are short & relevant, easy to follow.” –Andrea Levett 

★★★★★ Many great tips and tricks - even for the daily user!–Allison Daggs

★★★★★ "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

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

Who this course is for:

  • Anyone new to Microsoft Excel and those upgrading from previous software versions.