
Table of Contents/Timestamps
0:00 How to Use Excel Dark Mode
2:90 Using the Accounting Number Format Excel
7:45 How to Split Cells in Excel
11:19 How to Group Worksheets in Excel
13:50 How to Add Error Bars in Excel
17:53 How to Indent in Excel
21:28 Excel Format Painter - How to use it
26:02 How to Insert Checkboxes in Excel
34:27 How to Fix the Spill Error in Excel
38:27 How to Lock Cells in Excel
Table of Contents/Timestamps
0:00 How to Record a Macro in Excel
6:28 How to Delete a Named Range in Excel
10:39 How to Insert a Page Break in Excel
13:56 How to Fix Missing Scrollbar in Excel
17:26 How to Insert a Heat map in Excel
21:07 How to Fix the Name Error in Excel
26:18 How to Move Rows and Columns in Excel
30:06 How to Remove Space in Excel
32:52 How to Add Bullet Points in Excel
37:20 How to Make a Pie Chart in Excel
Ten Excel Tips and Tricks - Part 3 – Bonus
0:00 Freeze Rows in Excel
2:09 How to Convert Microsoft Excel to Word
5:23 How to Stop Excel rom Rounding
8:45 How to Calculate SUBTOTAL in Excel
12:02 How to Add an Excel Slicer
15:40 How to Graph a Function in Excel
19:42 How to Convert Text to Number in Excel
23:35 How to Copy Visible Cells Only
29:02 How to Add a Secondary Axis in Excel
37:32 How to Select Non-Adjacent Cells in Excel
Master the Ins and Outs of Microsoft Office and Boost Your Office’s Productivity.
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.
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.