by Brett Romero | Publisher: Stone River eLearning | Release Date: November 2017 | ISBN: 200000006A0408

Microsoft Excel is the most in demand tool for mining and making sense of data. Anyone that can harness this power will be a sought after employee. If you are running a business, being proficient in Excel can help you see your business in a whole new light. Excel Productivity shows you have to work faster and smarter in Excel. You'll pick up great tips that will make working in Excel a pleasure. Some of the areas covered include: Conditional formatting Various types of sorting Days and years between dates Removing duplicates Viewing multiple sheets in a single view and more The best part is that the above list will keep growing with great Excel insider, productivity tips for working smarter and faster.

1. Course Promo 00:00:32
2. Introduction
   • Saving/Opening Files & Ribbon Menu 00:10:23
   • Getting Started With Formulas 00:07:42
3. Formulas
   • Formulas Introduction 00:10:48
   • Concatenate 00:02:52
   • A Common Multi Column Summation Done Very Quickly 00:02:29
   • Calculating Time Spans 00:02:05
   • vlookup Exposed (project file attached) 00:06:23
   • Phone Numbers (project file attached) 00:12:46
4. Making Your Data Make Sense
   • Sorting 00:06:06
   • Removing Duplicates 00:03:45
   • Conditional Formatting 00:07:51
   • How Does Excel Know Which Data Format To Choose? 00:03:36
   • Updating an Existing Chart's Data Source (project file attached) 00:04:43
5. Productivity 10x Features
   • Quick Analysis 00:03:15
   • Multi-Sheet View 00:03:59
   • Freezing Panes 00:04:17
6. Ninja Shortcuts
   • Power of the Alt Key 00:03:58
   • Selecting Only Relevant Data 00:03:47
   • Shortcut Keys 00:02:36
   • Locking Cells & Showing All Formulas 00:04:14
7. Excel Overdrive
   • Create an Organizational Chart Fast (then add it to PowerPoint) 00:03:26
   • Building A Functional Database (project file attached) 00:06:43
8. Customizing Your Workspace
   • Hiding/Unhiding Single And Multiple Columns 00:03:19
   • Coloring Tabs For Better Grouping 00:02:58
9. Extending Excel
   • Solving Complex Problems Easily (project file attached) 00:11:23
   • Sourcing Data Directly From The FED Into Excel 00:07:07
   • Power Query 00:08:23