Master Microsoft Excel, Outlook and Word 2013 - 26 Hours
4.4 (160 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,056 students enrolled

Master Microsoft Excel, Outlook and Word 2013 - 26 Hours

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2013 Inside And Out—Quickly, No Travel or Classes.
4.4 (160 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,056 students enrolled
Created by Simon Sez IT
Last updated 6/2018
English
English [Auto]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 36.5 hours on-demand video
  • 11 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • Tips for mouse and touch screen users.
  • Graphs and charts using templates or custom designs.
  • SkyDrive and other tools for sharing work.
  • Pivot tables and slicing.
  • Working with flash fill.
  • Bonus exercise files.
  • Working with dates and times
  • Calculating depreciation
  • Averages, percentiles, and LINEST functions
  • Payments
  • Inserting and formatting tables
  • Sparklines and data bars
  • Pivot charts
  • Inserting images and videos directly from the internet
  • Opening and editing PDFs
  • Read mode, resume reading, object zoom, and collapsible headings
  • Protecting data with back-up and AutoRecover
  • Sharing work through email, blogs, and SkyDrive
  • Document security and editing restrictions
  • Setting up email accounts, POP and Gmail
  • Using touch devices
  • Importing contacts
  • Calendar appointments and attachments
  • Tasks and reminders
  • Email signatures
  • ‘Sneak a Peek’ and workspace customization
  • RSS feeds
  • Archiving and the Trust Center
  • Spam and junk mail removal
Requirements
  • Microsoft Office 2013
Description

Master the Ins and Outs of Microsoft Office 2013

  • Spreadsheets with Excel 2013
  • Emails and Calendars with Outlook 2013
  • Documents with Word 2013

Contents and Overview

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

Through 26 hours of video lectures, you'll learn the essentials with these 3 popular courses:

  • Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.
  • Outlook 2013: Get organized with your emails and calendar so you can start getting more done.
  • Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.

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.

What People Are Saying:

★★★★★ “The lesson is very clear. Easy to understand and perfect for beginners like me.” –Rachelle Deciembre

★★★★★ It’s very straight forward from what I have seen so far. Great resource for someone who has never used excel with clear explanations.” -Jennifer Janczak

** Updated June 2017. Course transcripts now available.

Who this course is for:
  • Microsoft Office users who are new to Microsoft Office or upgrading from a previous version
  • Individuals and office professionals who need to master the capabilities of Microsoft Office 2013
Course content
Expand all 224 lectures 36:36:24
+ Introduction to Excel 2013
5 lectures 18:43
Essential Information for a Successful Training Experience
01:19
Course exercise files
00:23
Downloadable Course Transcripts
00:17
+ Getting Started
2 lectures 22:14
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
11:20
Templates; Creating, Opening, and Saving a Workbook
10:54
+ Help
1 lecture 08:00
Online, Offline, and Contextual Help
08:00
+ The Ribbon and Toolbars
3 lectures 26:01
Quick Access Toolbar
08:03
Mini Toolbar
02:58
+ Backup and Recovery
1 lecture 06:54
Create Backup Option; Auto-Recover and Autosave
06:54
+ Entering and Deleting Data
5 lectures 01:04:26
Entering Text and Numbers
15:15
Formatting Cells; Editing and Deleting Data
15:15
Fill
12:51
Flash Fill
05:08
+ Formatting a Worksheet
5 lectures 01:03:32
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