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

Redesigning a Better Life

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

1 year ago

Adobe Premiere Pro – Quickstart

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

2 years ago

Project Management Quickstart

In this introductory course, students learn all of the basics of project management. Perfect for…

2 years ago

MS Sharepoint – Users

In this hands-on course, we will demonstrate and practice the essential skills you need to…

6 months ago

Document Design in Word

A well-designed document reflects well on you because a good page layout makes any document…

2 years ago

MS SharePoint – Owners

SharePoint features are robust and complex. Site owners can determine which features and options to…

6 months ago