MS Office 2013: 10-in-1 Courses To Maximize Productivity

Comprehensive, all-in-one training to get the most out of Microsoft Office 2013. 10-in-1 courses with 80 hours of video.
4.3 (81 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,634 students enrolled Bestselling in Office
$19
$200
90% off
Take This Course
  • Lectures 499
  • Length 80 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

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

Contents and Overview

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.

  1. Microsoft Excel 2013 - Introductory: Spreadsheets for data analysis and formulas for tracking expenses.
  2. Microsoft Excel 2013 - Advanced: apply functions, filter data, and create advanced spreadsheet visuals.
  3. Microsoft Word 2013: Introductory courses on creating documents and brochures, embedding videos, and set up for online collaboration.
  4. Microsoft Outlook 2013: Introductory courses on email efficiencies to help clear the email clutter and gain control of your inbox.
  5. Microsoft PowerPoint 2013: Introductory courses on how to create dazzling presentations using animation, audio/video, and collaborative tools with minimal time and effort.
  6. Microsoft Access 2013 – Introductory: creating and using databases to become a master of data management, tracking customer information and buying patterns.
  7. Microsoft Access 2013 – Advanced: improve your database reporting and information security.
  8. Microsoft Publisher 2013: Introductory courses on print publications to create professional-looking print material that communicates your organization's strengths and purpose.
  9. Microsoft Essential VBA for Excel: learn how to automate repetitive and time-consuming Excel procedures and operations for maximum efficiency.
  10. VBA Intermediate Training: Discover Excel Automation Secrets: learn advanced methods for automating tedious Excel jobs, the next step for anyone who has completed basic VBA.

This Course Includes

  • 10 individual courses
  • 80 hours of training tutorials
  • Hundreds of educational videos
  • Exercise files
  • A certificate of completion

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.

What are the requirements?

  • Microsoft Office 2013

What am I going to get from this course?

  • Introductory tutorials for Microsoft Excel 2013
  • Introductory tutorials for Microsoft Word 2013
  • Introductory tutorials for Microsoft Outlook 2013
  • Introductory tutorials for Microsoft PowerPoint 2013
  • Introductory tutorials for Microsoft Access 2013
  • Introductory tutorials for Microsoft Publisher 2013
  • Advanced training for Excel 2013
  • Advanced training for Access 2013
  • Essential Visual Basic for Applications (VBA) for Excel

What is the target audience?

  • Anyone new to Microsoft Office 2013 or upgrading from a previous version.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Learn Microsoft Excel 2013 Beginner Course
Introduction
Preview
09:12
IMPORTANT - Read this to ensure the best video quality!
Article
What's New
Preview
07:31
Overview of Principles
Preview
03:39
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
Preview
11:20
Excel 2013 Exercise Files
Article
Templates; Creating, Opening, and Saving a Workbook
10:54
Online, Offline, and Contextual Help
08:00
Excel Options
11:22
Ribbon Interface
15:00
Quick Access Toolbar
08:03
Mini Toolbar
02:58
Create Backup Option; Auto-Recover and Autosave
06:54
Entering Text and Numbers
15:15
Date Formats
15:57
Formatting Cells; Editing and Deleting Data
15:15
Fill
12:51
Flash Fill
Preview
05:08
Themes and Cell Styles
14:01
Inserting, Deleting, Hiding and Adjusting Rows and Columns
13:28
Wrap Text and Alignment
15:02
Merging Cells; Applying Themes and Styles
11:36
Borders
09:25
Copy, Cut and Paste
17:06
Spell checking
11:57
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
14:51
Inserting Comments
06:54
Workbook Views, Zoom and Freeze
11:18
Printing; Headers, Footers and Margins
12:57
Overview of Formulas and Functions
14:08
Cell References
14:50
Names
15:38
Finding Errors; New Excel Functions
14:13
Multiple Workbooks and Windows; Comparing Workbooks
10:39
Go to; Find and Replace Options
11:14
Applying, Clearing and Managing Rules
15:35
Chart Types; Chart Recommendation
13:35
Basic Formatting
14:41
Selecting Data, Positioning and Printing Charts
15:47
Saving Workbooks; PDF and CSV Formats
11:21
Sorting
09:06
Filtering
10:43
Tables
12:25
VLOOKUP
12:58
Text Function
05:17
Date and Time Functions
05:32
Logical Functions
18:31
Financial Analysis Case Study - Part 1
16:03
Financial Analysis Case Study - Part 2
09:23
Quick Analysis Tool
07:57
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
14:27
Protecting Worksheets
07:42
Protecting Workbooks
10:02
Sharing and SkyDrive
14:25
Trust Center; Export; Inspect Workbook
05:33
Summary; More Help
01:49
Microsoft Excel 2013 Quiz
45 questions
Section 2: Learn Microsoft Excel 2013 Advanced Training Course
Prerequisites of Excel 2013 Advanced Course
Preview
09:55
Excel 2013 Advanced Exercise Files
Article
List of Functions; Common Types of Arguments; Basic Use of Functions
Preview
13:38
Advanced Aspects of Functions; Searching for a Function
Preview
11:00
Autosum
Preview
06:18
Payment
12:48
Future Value
11:17
Principle Payment
12:02
Depreciations
13:25
How Dates and Times are Stored
11:57
Dates and Times Calculation
12:45
Exercise on Date and Time Functions; Date and Time Settings
07:25
Average
13:05
Percentile
10:21
Regression
14:02
LINEST Function
09:49
Example of Functions for Inferential Statistics
12:39
Text Function Case Study - 1
14:26
Text Function Case Study - 2
10:35
Lookup and Reference Functions
15:43
Logical Functions
16:00
Connecting to Other Workbooks
16:04
Connecting to Access Data
14:11
Connecting to Web Data
10:18
Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
13:49
Inserting Columns and Rows; Resizing Tables
15:03
Table Reference
09:18
Table Styles
07:07
Table Selection
04:08
Basic Principles of Pivot Tables
14:58
Presentational Side of Pivot Tables
15:40
Filtering in Pivot Tables; Slices
14:06
What if
15:32
Scenario Manager
14:07
Goal Seeker
07:51
Solver
14:38
Area Charts
10:39
Surface Charts
07:40
Stock Charts - Part 1
12:27
Stock Charts - Part 2
12:48
Radar Charts
05:08

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 Courses

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.

Ready to start learning?
Take This Course