Excel PRO TIPS Part 1: Productivity MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1 Hour 45M | 963 MB Genre: eLearning | Language: English
It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical "hacks". It's about featuring some of the most powerful and effective tools and techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.
Unlike most courses, this one is non-linear, meaning that you can bounce around and explore individual lectures freely. Each video is designed to be an independent and self-contained demo, designed to help you learn these tools and techniques in quick, bite-sized lessons. __________ The tips and techniques covered in the full course fall into six parts: PART 1: Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.) PART 2: Formatting Tips (freeze panes, row/column grouping, custom number formats, etc.) PART 3: Formula Tips (auditing tools, fuzzy lookups, uniques/duplicates, randomization, etc.) PART 4: Visualization Tips (sparklines, filled maps, custom templates, form controls, etc.) PART 5: PivotTable Tips (slicers & timelines, custom layouts, value calculations, etc.) PART 6: Analytics Tips (outlier detection, simulation, forecasting, CUBE functions, etc.)