Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Ultimate Microsoft Office 2013 Training Bundle 71 Hours
Rating: 4.5 out of 5(879 ratings)
7,236 students

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.
Created bySimon Sez IT
Last updated 4/2023
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

Course content

9 sections446 lectures73h 46m total length
  • Introduction9:12
  • WATCH ME: Essential Information for a Successful Training Experience2:03
  • DOWNLOAD ME: Course Exercise Files0:22
  • Downloadable ME: Course Transcripts0:21
  • 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
  • Excel 2013 Quiz

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 this course is for:

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