Master Microsoft Excel, PowerPoint and Word 2013 - 27 Hours

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2013 Inside And Out—Quickly, No Travel or Classes.
4.4 (34 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,360 students enrolled
$19
$150
87% off
Take This Course
  • Lectures 167
  • Length 28.5 hours
  • Skill Level Beginner Level
  • 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 4/2015 English

Course Description

Master the Ins and Outs of Microsoft Office 2013

  • Spreadsheets with Excel 2013
  • Documents with Word 2013
  • Presentations with PowerPoint 2013

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 27 hours of video lectures and 3 quizzes, you'll learn the essentials with these 3 popular courses:

  • Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.
  • Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.
  • PowerPoint 2013: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools.

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 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 PowerPoint 2013
  • Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • 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.
  • Pivot tables and slicing.
  • Working with flash fill.
  • Bonus exercise files.
  • 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
  • Creating backgrounds and working with templates
  • Images, audio, and video
  • Using a touch device
  • Trust Center and data protection
  • Align guides feature and shape merges

What is the target audience?

  • Anyone new to Microsoft Office 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: Excel 2013: Introduction
Introduction to Excel 2013
Preview
09:12
IMPORTANT - Read this to ensure the best video quality!
Article
What's New
Preview
07:31
Section 2: Excel 2013: Using Touch
Overview of Principles
Preview
03:39
Section 3: Excel 2013: Getting Started
Course Exercise Files
Article
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
11:20
Templates; Creating, Opening, and Saving a Workbook
10:54
Section 4: Excel 2013: Help
Course Review
00:43
Online, Offline, and Contextual Help
08:00
Section 5: Excel 2013: Settings and Preferences
Excel Options
11:22
Section 6: Excel 2013: The Ribbon and Toolbars
Ribbon Interface
Preview
15:00
Quick Access Toolbar
08:03
Mini Toolbar
02:58
Section 7: Excel 2013: Backup and Recovery
Create Backup Option; Auto-Recover and Autosave
06:54
Section 8: Excel 2013: Entering and Deleting Data
Entering Text and Numbers
15:15
Date Formats
15:57
Formatting Cells; Editing and Deleting Data
15:15
Fill
12:51
Flash Fill
05:08
Section 9: Excel 2013: Formatting a Worksheet
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
Section 10: Excel 2013: Copy, Paste and Paste Special
Copy, Cut and Paste
17:06
Section 11: Excel 2013: Proofing
Spell checking
11:57
Section 12: Excel 2013: Managing Worksheets
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
14:51
Section 13: Excel 2013: Comments
Inserting Comments
06:54
Section 14: Excel 2013: Viewing and Printing
Workbook Views, Zoom and Freeze
11:18
Printing; Headers, Footers and Margins
12:57
Section 15: Excel 2013: Formulas and Functions
Overview of Formulas and Functions
14:08
Cell References
14:50
Names
15:38
Finding Errors; New Excel Functions
14:13
Section 16: Excel 2013: Working with Workbooks
Multiple Workbooks and Windows; Comparing Workbooks
10:39
Section 17: Excel 2013: Find and Replace
Go to; Find and Replace Options
11:14
Section 18: Excel 2013: Conditional Formatting
Applying, Clearing and Managing Rules
15:35
Section 19: Excel 2013: Graphing and Charting
Chart Types; Chart Recommendation
Preview
13:35
Basic Formatting
14:41
Selecting Data, Positioning and Printing Charts
15:47
Section 20: Excel 2013: File Types
Saving Workbooks; PDF and CSV Formats
11:21
Section 21: Excel 2013: Managing Data
Sorting
09:06
Filtering
10:43
Tables
12:25
Section 22: Excel 2013: Functions Case Study
VLOOKUP
Preview
12:58
Text Function
05:17
Date and Time Functions
05:32
Logical Functions
18:31
Section 23: Excel 2013: Analyzing Data
Financial Analysis Case Study - Part 1
16:03
Financial Analysis Case Study - Part 2
09:23
Quick Analysis Tool
07:57
Section 24: Excel 2013: Shapes and Pictures
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
14:27
Section 25: Excel 2013: Sharing and Protecting
Protecting Worksheets
07:42
Protecting Workbooks
10:02
Sharing and SkyDrive
14:25
Section 26: Excel 2013: More Backstage View Options
Trust Center; Export; Inspect Workbook
05:33
Section 27: Excel 2013: Closing
Summary; More Help
01:49
Excel 2013 Course Quiz
45 questions
Section 28: Introduction to PowerPoint 2013
Acquiring PowerPoint 2013
Preview
13:40
What's New in PowerPoint 2013
Preview
09:24
Course Exercise Files
Article
Section 29: PowerPoint 2013: Using Touch
Overview of Principles
07:01
Section 30: PowerPoint 2013: Getting Started
PowerPoint Workspace; Opening, Saving and Exiting
09:39
Backstage View; Protecting Presentations; Editing Properties
15:05
Section 31: PowerPoint 2013: Help
Online and Offline Help
09:41
Section 32: PowerPoint 2013: PowerPoint Options
Customize Settings and Preference
10:15
Section 33: PowerPoint 2013: The Ribbon and Toolbars
The Ribbon
15:55

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