Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MS Office 2013: 10-in-1 Courses To Maximize Productivity
Rating: 4.3 out of 5(718 ratings)
5,247 students
Created bySimon Sez IT
Last updated 12/2025
English

What you'll 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
  • Essential Visual Basic for Applications (VBA) for Excel

Course content

12 sections525 lectures83h 10m total length
  • Introduction9:12
  • WATCH ME: Essential Information for a Successful Training Experience2:03
  • DOWNLOAD ME: Excel 2013 Exercise Files0:22
  • Downloadable Course Transcripts0:18
  • What's New7:31
  • Overview of Principles3:39
  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns11:20
  • Templates; Creating, Opening, and Saving a Workbook10:54
  • Online, Offline, and Contextual Help8:00
  • Excel Options11:22
  • Ribbon Interface15:00
  • Quick Access Toolbar8:03
  • Mini Toolbar2:58
  • Create Backup Option; Auto-Recover and Autosave6:54
  • Entering Text and Numbers15:15
  • Date Formats15:57
  • Formatting Cells; Editing and Deleting Data15:15
  • Fill12:51
  • Flash Fill5:08
  • Themes and Cell Styles14:01
  • Inserting, Deleting, Hiding and Adjusting Rows and Columns13:28
  • Wrap Text and Alignment15:02
  • Merging Cells; Applying Themes and Styles11:36
  • Borders9:25
  • Copy, Cut and Paste17:06
  • Spell checking11:57
  • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets14:51
  • Inserting Comments6:54
  • Workbook Views, Zoom and Freeze11:18
  • Printing; Headers, Footers and Margins12:57
  • Overview of Formulas and Functions14:08
  • Cell References14:50
  • Names15:38
  • Finding Errors; New Excel Functions14:13
  • Multiple Workbooks and Windows; Comparing Workbooks10:39
  • Go to; Find and Replace Options11:14
  • Applying, Clearing and Managing Rules15:35
  • Chart Types; Chart Recommendation13:35
  • Basic Formatting14:41
  • Selecting Data, Positioning and Printing Charts15:47
  • Saving Workbooks; PDF and CSV Formats11:21
  • Sorting9:06
  • Filtering10:43
  • Tables12:25
  • VLOOKUP12:58
  • Text Function5:17
  • Date and Time Functions5:32
  • Logical Functions18:31
  • Financial Analysis Case Study - Part 116:03
  • Financial Analysis Case Study - Part 29:23
  • Quick Analysis Tool7:57
  • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt14:27
  • Protecting Worksheets7:42
  • Protecting Workbooks10:02
  • Sharing and SkyDrive14:25
  • Trust Center; Export; Inspect Workbook5:33
  • Summary; More Help1:49
  • Microsoft Excel 2013 Quiz

Requirements

  • Microsoft Office 2013

Description

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

Who this course is for:

  • Anyone new to Microsoft Office 2013 or upgrading from a previous version.