Excel PRO TIPS Part 3 Formulas

[mitsumi]

Excel PRO TIPS Part 3: Formulas
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | 1.10 GB
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.)
           

               

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction