Contents
Use Range Names
Create and use a range name
Change and delete a range name, define its scope (workbook, worksheet)
Calculations with advanced functions
Use functions: SumIf, CountIf, Vlookup, If, And, Or, Match ….
Nesting functions
Goal seek
Conditional Formatting
Apply a built-in conditional format
Customize a conditional format
Manage databases
Sorting data: by value, by color or icon
Filtering data: automatic and advanced filters
Remove duplicates
Use subtotals
Pivot Tables
Pivot Charts
Check data
Use the Audit tools
Evaluate a formula
Consolidate data
Keyjob
Key Job
65
Avenue de la Gare
1611 Luxembourg
Luxembourg
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!
With you consent, we collect data such as your advertising ID and your IP address.
They allow us to provide our services 100% free of charge and to continue improving them so that we provide you with relevant content.
For more information, please refer to our data privacy policy
To check your Favorites, connect to your account!
To check your Favorites, connect to your account!
Sign in to get access to your preferences!
Sign in to follow this category!
Sign in to follow this Good Address!
Sign in to follow this business!
Yes I want to delete it
