You will become comfortable with:

    » Auto-filling cells; Custom lists; Flash Fill
    » Date and Time arithmetic
    » Named Ranges
    » Data Validations
    » Conditional functions incl. SUMIFS
    » Lookups incl. VLOOKUP
    » Introduction to INDIRECT
    » Conditional formatting
    » Worksheet/book protection
    » Excel tables/Structured References
    » Advanced Filters
    » Pivot Tables; Slicers; Dashboards
    » Quick Analysis
    » Mail Merge with Word
    » and much more

You will benefit most from this course if you:

    » Need to organize/manage/analyze lists of data or items
    » Are comfortable using Excel ribbons and formatting cells
    » Have written basic Excel formulas
    » Know about the $ (dollar sign) in formulas for absolute referencing
    » Know basic data filtering+sorting
torocq

Recent Posts

MS Teams – Essentials

Communication is one of the biggest keys to success in the workplace. Microsoft Teams offers…

1 month ago

MS Teams – Quickstart

No question, the speed of work has increased exponentially. Whether you work remotely or in…

1 month ago

Microsoft Power Automate

If you are looking to streamline repetitive tasks and processes, you can use Microsoft Power…

1 month ago

Microsoft Planner

With Planner you and your team can to create plans, assign tasks, chat about tasks,…

3 months ago

Redesigning a Better Life

Redesigning a Better Life is about creating your own unique path and living a more…

2 years ago

Adobe Premiere Pro – Quickstart

Creating short videos is becoming an indispensable skill. In this one-day workshop, you will learn…

2 years ago