Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. You'll unlock powerful techniques that will help you complete tasks quickly.
What You'll Learn
Navigation tricks & shortcuts
Summarize data with Pivot Tables
VLOOKUP function
Join and split text
Create drop-down menus
Sort & filter data
Tricks to speed up workflow
Logical functions: IF, AND, OR
What You'll Learn
Navigation tricks & shortcuts
Summarize data with Pivot Tables
VLOOKUP function
Join and split text
Create drop-down menus
Sort & filter data
Tricks to speed up workflow
Logical functions: IF, AND, OR