Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
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 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."
"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Learn Microsoft Excel 2013 Beginner Course|
IMPORTANT - Read this to ensure the best video quality!
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
Excel 2013 Exercise Files
Templates; Creating, Opening, and Saving a Workbook
Online, Offline, and Contextual Help
Quick Access ToolbarPreview
Create Backup Option; Auto-Recover and Autosave
Entering Text and Numbers
Formatting Cells; Editing and Deleting Data
Themes and Cell Styles
Inserting, Deleting, Hiding and Adjusting Rows and Columns
Wrap Text and Alignment
Merging Cells; Applying Themes and Styles
Copy, Cut and Paste
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
Workbook Views, Zoom and Freeze
Printing; Headers, Footers and Margins
Overview of Formulas and Functions
Finding Errors; New Excel Functions
Multiple Workbooks and Windows; Comparing Workbooks
Go to; Find and Replace Options
Applying, Clearing and Managing Rules
Chart Types; Chart RecommendationPreview
Selecting Data, Positioning and Printing Charts
Saving Workbooks; PDF and CSV Formats
Date and Time Functions
Financial Analysis Case Study - Part 1
Financial Analysis Case Study - Part 2
Quick Analysis Tool
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
Sharing and SkyDrive
Trust Center; Export; Inspect Workbook
Summary; More Help
Excel 2013 Quiz
|Section 2: Learn Microsoft Excel 2013 Advanced Training Course|
Prerequisites of Excel 2013 Advanced CoursePreview
Excel 2013 Advanced Exercise Files
List of Functions; Common Types of Arguments; Basic Use of FunctionsPreview
Advanced Aspects of Functions; Searching for a FunctionPreview
How Dates and Times are Stored
Dates and Times Calculation
Exercise on Date and Time Functions; Date and Time Settings
Example of Functions for Inferential Statistics
Text Function Case Study - 1Preview
Text Function Case Study - 2
Lookup and Reference Functions
Connecting to Other Workbooks
Connecting to Access Data
Connecting to Web Data
Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
Inserting Columns and Rows; Resizing Tables
Basic Principles of Pivot Tables
Presentational Side of Pivot Tables
Filtering in Pivot Tables; Slices
Stock Charts - Part 1
Stock Charts - Part 2
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.