The Ultimate Microsoft Office 2013 Training Bundle 71 Hours
4.3 (148 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.
4,037 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Ultimate Microsoft Office 2013 Training Bundle 71 Hours to your Wishlist.

Add to Wishlist

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.
4.3 (148 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.
4,037 students enrolled
Created by Simon Sez IT
Last updated 6/2017
English
Current price: $10 Original price: $200 Discount: 95% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 71.5 hours on-demand video
  • 21 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Microsoft Office 2013
Description

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.

Who is the target audience?
  • Anyone new to Microsoft Office or upgrading from a previous version
Students Who Viewed This Course Also Viewed
Curriculum For This Course
441 Lectures
71:41:23
+
Learn Microsoft Excel 2013 Beginner Course
57 Lectures 10:13:51

Essential Information for a Successful Training Experience
01:36

Excel 2013 Exercise Files
00:25

Downloadable Course Transcripts
00:20




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


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


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

Excel 2013 Quiz
45 questions
+
Learn Microsoft Excel 2013 Advanced Training Course
50 Lectures 09:08:02

Essential Information for a Successful Training Experience
01:36

Excel 2013 Advanced Exercise Files
00:26

Downloadable Course Transcripts
00:20

List of Functions; Common Types of Arguments; Basic Use of Functions
13:38

Advanced Aspects of Functions; Searching for a Function
11:00


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


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

Bubble Charts
10:21

Regression and Scatter Chart
07:00

Creating Pivot Charts
12:32


Creating Workbooks using a Web App
15:15

Sharing your Workbook
10:00

Closing
00:19

Excel 2013 Advanced Quiz
45 questions
+
Learn Microsoft Word 2013
58 Lectures 09:07:05

Essential Information for a Successful Training Experience
01:36

Word 2013 Exercise Files
00:25

Downloadable Course Transcripts
00:20

What's New
08:09

Overview of Principles
05:18

Starting and Exiting; Templates; Creating, Opening and Saving Documents
10:41

Word Workspace; Backstage View
08:48

Online and Offline Help
09:05

Settings and Preferences
11:45

The Ribbon
12:46


Mini Toolbar/Bar
02:51

Setting Up AutoSave and AutoRecover Preferences
08:06

Typing, Editing, and Deleting Text; Customizing Status Bar
14:33

Navigation; Word Wrapping; Making a Selection
10:49

Inserting Symbols, Date and Time, and Document Property
08:08

Various Methods of Copying, Cutting and Pasting
15:25

Uses of Navigation Pane
07:35

Find and Replace; Go to
07:32

Keyboard Shortcuts and Key Tips
09:33


Zoom
04:57

Read Mode
07:52

Spelling and Grammar Errors; Language Settings
10:09

AutoCorrect; Proofing Settings; Spell Checking
12:48

Fonts, Font Size, and Font Colors; Text Effect and Text Highlight
13:24

Alignment; Line and Paragraph Spacing; Indent
11:37

Fill/Shading; Border Tab; Format Painter
13:49

Bulleted, Numbered and Multilevel Lists
13:48

File Formats
15:53

Printing
14:42

Page Layout, Sections and Margins
09:13

Headers, Footers and Page Numbers
17:13

Using Templates
07:13

Using Themes and Styles
16:04

Opening and Editing PDFs
05:06

Creating a Table; Inserting, Selecting and Deleting Rows and Columns
11:30

Formatting Tables
14:39

Inserting, Cropping, Resizing and Positioning Pictures
13:27

Picture Styles; Picture Adjustments, Corrections and Effects
14:06

Online Pictures and Clipart
06:12

Inserting and Formatting Shapes and Textbox
12:27

Smart Art and WordArt
10:56

Screenshots
05:13

Creating Charts
10:19

Resume Reading and Editing
02:04

Object Zoom
02:03


Mail Merge Wizard Part 2
12:36

Send to Email; Post to Blog; SkyDrive; Invite People
13:34

Restrict Editing, Comments, Simple Markup and Tracking Changes
13:29

Navigation, Headings, Table of Contents, Update Page numbers and Outline View
13:11

Watermarks
03:31

Page Borders
04:36

Types of Hyperlinks
09:07

Inspecting and Protecting Documents
05:00

Microsoft Update; Closing
01:13

Word 2013 Quiz
45 questions
+
Learn Microsoft Outlook 2013
58 Lectures 08:05:31
Information about Installation and Upgrade
15:04

Essential Information for a Successful Training Experience
01:17

Downloadable Course Transcripts
00:20


Using Touch
08:25

Online, Offline, and Contextual Help
10:45

Outlook 2013 Workspace
12:00

The Ribbon
13:03

Quick Access Toolbar
06:44

Mini Toolbars
03:37

Contextual Menu
03:59

Status Bar
02:44

Customizing Settings and the Use of Outlook
08:43

List of Keyboard Shortcuts; Using Key Tips
06:59

Setting Up an Account
11:15

Sending and Receiving Email
09:32



Adding Tasks
12:27

Creating Notes
06:15

Managing RSS Feeds
13:37

Printing Emails and Contacts; Print Properties
12:37

Favorites; PST and OST Files; Folder Size
15:56

Setting Up Gmail and POP Accounts
14:44

Adding New Folder, Moving and Deleting Items, and Emptying Folders
11:41

Backup and Restore a PST file
06:05

AutoArchive and Manual Archive
08:47

Import and Export Wizard
05:54


Calendar Amendments and Rescheduling
04:07

Calendar Recurrence
05:30

Calendar Attachments
06:02

Calendar Events
07:28

Managing Reminders
06:08

Basics of Search; Searching Contacts
06:44

Search Folders
03:03

Color Categories
09:36

Managing Tasks
14:51

Contacts Options
02:48

Contact Information
09:15

Outlook Social Connector
05:03

Contact Views
06:46

Contact Groups
04:52

Email Options
13:56

Email Send and Receive Settings
06:04

Composing Email
13:39

Email Signatures
06:02

Email Inbox
09:58

Email Actions
09:06

Touch Action Bar
04:17

Junk Email
10:44

Stationery
06:00

Rules
11:50

Quick Steps
07:20

Outlook Journal
09:15

Mail Merge using Word
09:10

Trust Center
10:23

Microsoft Updates; Closing
01:24

Outlook 2013 Quiz
35 questions
+
Learn Microsoft PowerPoint 2013
57 Lectures 09:14:57
Acquiring PowerPoint 2013
13:40

Essential Information for a Successful Training Experience
01:36

PowerPoint 2013 Exercise Files
00:25

Downloadable Course Transcripts
00:20

Course Review
00:43


Using Touch
07:01

PowerPoint Workspace; Opening, Saving and Exiting
09:39

Backstage View; Protecting Presentations; Editing Properties
15:05

Online and Offline Help
09:41

Customize Settings and Preference
10:15

The Ribbon
15:55


Mini Toolbar
04:34

Status Bar
02:43

Backup Files; Adjust AutoSave; Recover Unsaved Presentation
12:13


Adding Contents; Adding and Deleting Slides
11:26

Adjusting View and Adding Notes in Normal View; Promote/Demote
12:26

Moving Slides in Slide Sorter View; Notes Page and Reading View
07:06

Zoom
06:58

Undo and Redo Actions; Set Maximum Number of Undos
06:30

Adding and Formatting Text; Placeholder Textbox
11:33

Manual Textbox; Inserting Symbols
08:54

Using Clipboard and Mini Toolbar; Paste Option
12:05

AutoCorrect and Proofing
15:03

Templates, Slides and Masters
11:35


Header and Footer
06:28

Bulleted and Numbered Lists
14:12

Alignment, Line Spacing, Ruler and Tabs
15:32

Inserting Pictures
10:16

Formatting Pictures
13:01

Photos and Photo Albums
08:47

Clip Art
03:25

Screenshots
04:02

Drawing and Formatting Shapes
10:39

Creating Complex Shapes
09:59

SmartArt
14:53

Save Options, Create PDF/XPS Document, Change File Type
09:45

Creating and Formatting Tables
11:46

Creating Charts using Excel; Editing Data, Chart Type and Chart Element
14:33


Controlling Animation; Motion Path
11:15

Animation of SmartArt
07:49

Printing Slides and Handouts
14:15

Linking to a Webpage and a Slide
14:31

Aligning Objects; Grid and Guides; Nudging
15:35

Spell check; Create Handouts and Videos; Inspect Document; Hide Slide
14:43

Transitions and Timings; Setting up and Recording a Slide Show
11:50

Manual Presentation; Presenter View and Tools
12:47


Saving your Presentation on SkyDrive
12:21

PowerPoint Web App; Send Email; Get a Link
10:55

Presenting on the Web
02:50

Inserting and Formatting Video; Adding Audio
14:24

Protecting your Presentation; Trust Center; Closing
04:03

PowerPoint 2013 Quiz
45 questions
+
Learn Microsoft Access 2013 Beginner Course
55 Lectures 10:18:26
Acquiring Access 2013; Course Overview
14:32

Essential Information for a Successful Training Experience
01:36

Access 2013 Exercise Files
00:26

Downloadable Course Transcripts
00:20


Using Touch
05:53

Database Templates; Creating, Opening and Saving Databases
11:26

Workspace and Backstage View
10:31

Online, Offline, and Contextual Help
05:49

Finding Keyboard Shortcuts and Key Tips
05:57

Customizing the Settings and Use of Access 2013
11:23

The Ribbon
11:22

Quick Access Toolbar
04:49


Overview of the Main Features of Access Database
16:43

Web App Basics
10:42


Creating Tables - Part 2
14:46

Relationships Between Tables - Part 1
14:32

Relationships Between Tables - Part 2
08:38

Inserting and Formatting Fields; Field Validation; Navigation Buttons
12:19

Sorting, Filtering and Finding Data
13:21

Entering Data; Changing the Order of Columns, Field Width and Height
08:00

Design View; Field Properties
13:36

Saving Data; Data Types, Attachments and Field Size
14:06

Input Masks; More on Field Properties
15:06

Creating Forms; Form Wizard
14:36

Single Forms; Insert, Delete, Modify, Sort and Filter Records
12:35

Layout View; Adding Existing Fields
15:55

Design View; Arranging Fields
16:27

Controls
14:06

Form Design
13:25

Query Design
15:30

Joins and Query Wizard
15:03



Operators and Expressions - Part 2
07:32

Operators and Expressions - Part 3
15:04

Subforms
12:32

Report Wizard; Previewing a Report
09:41

Report Design
13:57

Grouped and Summary Reports; Modifying a Report
15:27

Adding Subreports
11:40

Documenter; Print Properties and Options
09:20

Import and Append; Copy and Paste; Export Access Database
13:45

Database Templates and Application Parts
14:21

Navigation Form
10:45

Modal Dialogs - Part 1
11:52

Modal Dialogs - Part 2
13:33

Modal Dialogs - Part 3
09:39

Actions; Example of VBA; Creating AutoExec Macro
15:25

More Access Options
08:45

Info Tab
11:49

Trust Center
12:58

Updates; Closing
02:22

Access 2013 Quiz
50 questions
+
Learn Microsoft Access 2013 Advanced Training Course
43 Lectures 09:27:10

Essential Information for a Successful Training Experience
01:36

Access 2013 Advanced Exercise Files
00:26



Controlling the Display and Advanced Sorting and Filtering in Datasheet View
15:21

Linking to Other Access Database Tables
14:41

How to Install SQL Server Express
14:49

Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
16:50

Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
15:19

Consequences of the Split; Moving a Database; Adding a Trusted Location
16:07

Access Options relating to Multi-user Issues; Record Locking
14:58

Basics of Macros and Properties of Macro Editor
14:24

Examples of Macros; Autoexec
14:29

More Autoexec
14:43

Macro Security
08:37

Customizing the Quick Access Toolbar and the Ribbon
15:17

Convert Macro to VBA; VBA Editor
14:13

Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
14:27


Scope of Variables
16:13

Branch and Loop
14:38

Customizing Events
15:08

Responding to Events and Developing Error Handles
14:00

More on Events
14:12

Getting Help with Events
08:24

Basics of Forms: Review and Tips and Tricks
15:39

Advanced Features of Forms - Part 1
17:19

Advanced Features of Forms - Part 2
14:33

Advanced Features of Forms - Part 3
14:49

Advanced Features of Forms - Part 4
15:19

Basics of Queries: Review
13:57

Main Features and Syntax of SQL Statements
15:53

Use of Multiple Criteria of a Where Clause
12:55


Update Query
15:42

Delete and Make Table Queries
12:20

Append Query
07:13

Protecting your Database and Codes
15:08

Making your Database More User-Friendly
07:23

Setting up an Access Web App
16:33

Building Basic Web Apps
16:48

Closing
00:44

Access 2013 Advanced Quiz
45 questions
+
Learn Microsoft Publisher 2013
63 Lectures 06:07:31

Essential Information for a Successful Training Experience
01:36

Downloadable Course Transcripts
00:20


Interface Overview: The Publisher Application
09:07

Insert, Move, Rename and Delete Pages
06:05

Viewing and Navigating Pages
06:46

Rulers, Measurements, and Guidelines
05:27

Establishing Business Information
05:36

Setting Preferences
11:52

Saving Your Publication
03:17

Inserting a Text Box
08:57

Formatting a Text Box
05:12

Character Formatting Options
10:06


Importing Text from Word
04:52

Working with Columns
04:20

Setting Paragraph and Line Spacing Options
09:19

Inserting Hyperlink Text
04:21

Inserting Special and Break Characters
11:44

Performing a Spell Check
04:21

Using Find and Replace Feature
03:43

Paragraph Formatting Options
07:46

Working with Tab Stops
04:50

Working with Styles
09:00

Bitmap vs. Vector Images
06:57

Digital Image File Formats
08:07

Inserting Images and Image Placeholders
10:00

Move, Resize and Crop Images
08:25

Utilizing the Adjustment Settings
05:31

Adding Captions and Alternate Text to Images
03:23

Inserting Page Parts, Borders and Accents
03:04

Inserting a Basic Shape
07:10

Formatting a Shape
11:29


Editing a Shape using Anchor Points
06:11

Comparing Color Models
05:04

Exploring RGB, CMYK, and Pantone Colors
05:21

Using Adobes Kuler Tool
07:04

Creating and Applying Color Schemes
04:26

Tints, Gradients, Textures and Patterns
06:28

Applying Custom Colors
07:50

Utilizing the Scratch Area
03:53

Arranging, Grouping and Ungrouping Objects
06:50

Rotating, Flipping, Nudging and Aligning Objects
08:05

Wrapping Text around Objects
03:18

Utilizing the Format Painter
02:41

Saving an Object as a Building Block
03:36

Inserting a Table
04:00

Inserting and Deleting Rows and Columns
02:14

Formatting a Table
09:13

Working with Master Pages
10:42

Applying a Page Background
04:41

Managing Page Setup Options
03:58

Starting a Mail Merge
03:37

Selecting Mail Merge Recipients
08:35

Inserting Merge Fields
04:31

Previewing and Completing a Mail Merge
03:47

Working with Skydrive
04:46

Running Design Checker and Managing Embedded Fonts
04:43

Printing a Publication
01:54

Additional Saving and Print Options
03:20

Course Summary
01:10

Publisher 2013 Quiz
40 questions
About the Instructor
Simon Sez IT
4.4 Average rating
10,293 Reviews
293,586 Students
114 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ 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,500+ 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 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.