->
Oreilly - Excel Productivity - 200000006A0408
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.
  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
  10. Oreilly - Excel Productivity


 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.


 Coktum   |  

Information
Members of Guests cannot leave comments.




rss