4.46 out of 5
4.46
268 reviews on Udemy

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.
Instructor:
Simon Sez IT
3,006 students enrolled
English [Auto-generated]
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

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 course on creating documents and brochures, embedding videos, and set up for online collaboration.
  4. Microsoft Outlook 2013: Introductory course on email efficiencies to help clear the email clutter and gain control of your inbox.
  5. Microsoft PowerPoint 2013: Introductory course 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 course 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 Others Are Saying:

“Goes step by step with clear and simple instructions. Takes time in explaining each set before moving to the next.”
– Judy Weismann

“Great online tutorial. Instructor goes slowly and uses great visuals. Easy to understand.” – Lisa Armstrong

“Instructor’s lecture is easy to understand, and he leads at a comfortable pace. His technique of explanation is superior to many other courses I have taken on Udemy thus far.”  – Erma Trent

“I feel as though the teacher is talking to me and he explains everything with great clarity. I wish I knew about this course before, I really feel a lot of respect and admiration for how serious he is in explaining every little thing step by step.”
– A. Shan

Learn Microsoft Excel 2013 Beginner Course

1
Introduction
2
Essential Information for a Successful Training Experience
3
Excel 2013 Exercise Files
4
Downloadable Course Transcripts
5
What's New
6
Overview of Principles
7
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
8
Templates; Creating, Opening, and Saving a Workbook
9
Online, Offline, and Contextual Help
10
Excel Options
11
Ribbon Interface
12
Quick Access Toolbar
13
Mini Toolbar
14
Create Backup Option; Auto-Recover and Autosave
15
Entering Text and Numbers
16
Date Formats
17
Formatting Cells; Editing and Deleting Data
18
Fill
19
Flash Fill
20
Themes and Cell Styles
21
Inserting, Deleting, Hiding and Adjusting Rows and Columns
22
Wrap Text and Alignment
23
Merging Cells; Applying Themes and Styles
24
Borders
25
Copy, Cut and Paste
26
Spell checking
27
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
28
Inserting Comments
29
Workbook Views, Zoom and Freeze
30
Printing; Headers, Footers and Margins
31
Overview of Formulas and Functions
32
Cell References
33
Names
34
Finding Errors; New Excel Functions
35
Multiple Workbooks and Windows; Comparing Workbooks
36
Go to; Find and Replace Options
37
Applying, Clearing and Managing Rules
38
Chart Types; Chart Recommendation
39
Basic Formatting
40
Selecting Data, Positioning and Printing Charts
41
Saving Workbooks; PDF and CSV Formats
42
Sorting
43
Filtering
44
Tables
45
VLOOKUP
46
Text Function
47
Date and Time Functions
48
Logical Functions
49
Financial Analysis Case Study - Part 1
50
Financial Analysis Case Study - Part 2
51
Quick Analysis Tool
52
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
53
Protecting Worksheets
54
Protecting Workbooks
55
Sharing and SkyDrive
56
Trust Center; Export; Inspect Workbook
57
Summary; More Help
58
Microsoft Excel 2013 Quiz

Learn Microsoft Excel 2013 Advanced Training Course

1
Prerequisites of Excel 2013 Advanced Course
2
Essential Information for a Successful Training Experience
3
Excel 2013 Advanced Exercise Files
4
Downloadable Course Transcripts
5
List of Functions; Common Types of Arguments; Basic Use of Functions
6
Advanced Aspects of Functions; Searching for a Function
7
Autosum
8
Payment
9
Future Value
10
Principle Payment
11
Depreciations
12
How Dates and Times are Stored
13
Dates and Times Calculation
14
Exercise on Date and Time Functions; Date and Time Settings
15
Average
16
Percentile
17
Regression
18
LINEST Function
19
Example of Functions for Inferential Statistics
20
Text Function Case Study - 1
21
Text Function Case Study - 2
22
Lookup and Reference Functions
23
Logical Functions
24
Connecting to Other Workbooks
25
Connecting to Access Data
26
Connecting to Web Data
27
Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
28
Inserting Columns and Rows; Resizing Tables
29
Table Reference
30
Table Styles
31
Table Selection
32
Basic Principles of Pivot Tables
33
Presentational Side of Pivot Tables
34
Filtering in Pivot Tables; Slices
35
What if
36
Scenario Manager
37
Goal Seeker
38
Solver
39
Area Charts
40
Surface Charts
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
268 Ratings

Detailed Rating

Stars 5
132
Stars 4
100
Stars 3
26
Stars 2
5
Stars 1
5
2b603f64cdc4f8a1d8a6bdb87c9ae0b8
30-Day Money-Back Guarantee

Includes

80 hours on-demand video
27 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion