Oreilly - Excel Productivity
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.
- Course Promo 00:00:32
- Introduction
- Saving/Opening Files & Ribbon Menu 00:10:23
- Getting Started With Formulas 00:07:42
- 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
- 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
- Productivity 10x Features
- Quick Analysis 00:03:15
- Multi-Sheet View 00:03:59
- Freezing Panes 00:04:17
- 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
- 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
- Customizing Your Workspace
- Hiding/Unhiding Single And Multiple Columns 00:03:19
- Coloring Tabs For Better Grouping 00:02:58
- 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
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.