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.
Unlock the Power Of Microsoft Office and Watch Your Productivity Soar!
Microsoft Office is the #1 office software used by +1 billion people worldwide. While many are familiar with Microsoft Office's basic features, few people know about its more advanced capabilities that are designed to save you time, money, and effort.
Using step-by-step instructions, Simon Sez IT will quickly guide you through the most popular programs of Microsoft Office 2013: Excel, Word, Outlook, PowerPoint, Access, and Publisher. In addition to mastering the basic features, you'll also learn highly useful advanced capabilities of both Excel and Access.
For example, Visual Basic for Applications (VBA) for Excel will show you how to automate repetitive tasks and operations that you perform frequently. This valuable time saving tool and productivity enhancer is a critical tool for anyone who uses Excel frequently.
Work inefficiencies add up quickly over time. If you're always 'learning the hard way' when using Microsoft Office 2013, or under-utilizing its full capabilities, then you'll want to invest in these game-changing courses that include lifetime Udemy access. Let your work productivity soar so that you'll have more time for the other things in life that matter!
**** Updated November 18, 2015: New Course Added: VBA Intermediate Training: Discover Excel Automation Secrets
In this 10-in-1 course collection, we'll show you important yet often over-looked or unknown features that will help skyrocket your productivity.
This Course Includes
Why Take This Course
Most work today happens on a computer – optimize your effort by learning useful software tips and tricks that you'll apply for decades to come! And that will save you valuable time, money and effort.
Want to get noticed by your boss or earn the respect of your colleagues? Become the office superstar by becoming the go-to expert on everything related to MS Office 2013!
Individual video training for these 6 programs would easily cost thousands of dollars, but this 10-in-1 package is available at one unbelievably low price. Tremendous learning at tremendous savings.
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!
Overview of PrinciplesPreview
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & ColumnsPreview
Excel 2013 Exercise Files
Templates; Creating, Opening, and Saving a Workbook
Online, Offline, and Contextual Help
Quick Access Toolbar
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 Recommendation
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
Microsoft 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 - 1
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.