The Ultimate Microsoft Office 2013 Training Bundle 71 Hours
- Description
- Curriculum
- FAQ
- Reviews
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.
-
1Introduction
-
2WATCH ME: Essential Information for a Successful Training Experience
-
3Excel 2013 Exercise Files
-
4Downloadable Course Transcripts
-
5What's New
-
6Overview of Principles
-
7Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
-
8Templates; Creating, Opening, and Saving a Workbook
-
9Online, Offline, and Contextual Help
-
10Excel Options
-
11Ribbon Interface
-
12Quick Access Toolbar
-
13Mini Toolbar
-
14Create Backup Option; Auto-Recover and Autosave
-
15Entering Text and Numbers
-
16Date Formats
-
17Formatting Cells; Editing and Deleting Data
-
18Fill
-
19Flash Fill
-
20Themes and Cell Styles
-
21Inserting, Deleting, Hiding and Adjusting Rows and Columns
-
22Wrap Text and Alignment
-
23Merging Cells; Applying Themes and Styles
-
24Borders
-
25Copy, Cut and Paste
-
26Spell checking
-
27Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
-
28Inserting Comments
-
29Workbook Views, Zoom and Freeze
-
30Printing; Headers, Footers and Margins
-
31Overview of Formulas and Functions
-
32Cell References
-
33Names
-
34Finding Errors; New Excel Functions
-
35Multiple Workbooks and Windows; Comparing Workbooks
-
36Go to; Find and Replace Options
-
37Applying, Clearing and Managing Rules
-
38Chart Types; Chart Recommendation
-
39Basic Formatting
-
40Selecting Data, Positioning and Printing Charts
-
41Saving Workbooks; PDF and CSV Formats
-
42Sorting
-
43Filtering
-
44Tables
-
45VLOOKUP
-
46Text Function
-
47Date and Time Functions
-
48Logical Functions
-
49Financial Analysis Case Study - Part 1
-
50Financial Analysis Case Study - Part 2
-
51Quick Analysis Tool
-
52Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
-
53Protecting Worksheets
-
54Protecting Workbooks
-
55Sharing and SkyDrive
-
56Trust Center; Export; Inspect Workbook
-
57Summary; More Help
-
58Excel 2013 Quiz