4.32 out of 5
4.32
342 reviews on Udemy

The Ultimate Microsoft Office 2013 Training Bundle 71 Hours

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2013 Inside And Out—Quickly, No Travel or Classes.
Instructor:
Simon Sez IT
4,767 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

Master the Ins and Outs of Microsoft Office and Boost Your Office’s Productivity.

  • Spreadsheets with Excel 2013
  • Documents with Word 2013
  • E-mail with Outlook 2013
  • Presentations with PowerPoint 2013
  • Databases with Access 2013
  • Print Publications with Publisher 2013

Make Your Office More Efficient with Microsoft’s Premier Office Management Software

Whether you need to create a spreadsheet for data analysis, a database of customer contacts, or a brochure that outlines the strengths and appeal of your organization, Microsoft Office is the choice of many office professionals. Enjoy significant control over your calendar and communication with Outlook or create engaging presentations with PowerPoint.

Many people are aware of the basics of what Office can do, but learning the more advanced capabilities of the programs in Office gives you greater flexibility and opportunities for creativity. Microsoft Office is designed to make accomplishing office tasks easier and more efficient.

Contents and Overview

The course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office.

Through over 71 hours of video lectures and 8 quizzes, you’ll learn everything you need to know to make your office run more efficiently with Office 2013.

  • Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.
  • Excel 2013 Advanced: Use complex formulas and perform data analysis on your organization’s revenue and expense patterns.
  • Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.
  • Outlook 2013: Gain control of your inbox and avoid accumulating hundreds of unanswered emails.
  • PowerPoint 2013: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools.
  • Access 2013 For Beginners and Access 2013 Advanced: Become a master of data management, tracking customer information and buying patterns.
  • Publisher 2013: Create professional looking print publications to communicate the strengths and purpose of your organization.

When you complete this course, you’ll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft Office 2013.

** Updated June 2017. Course transcripts now available.

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
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.3
4.3 out of 5
342 Ratings

Detailed Rating

Stars 5
153
Stars 4
119
Stars 3
57
Stars 2
6
Stars 1
6
e0de621c9e24700488f3cfde0906fa1d
30-Day Money-Back Guarantee

Includes

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