This course takes a solo case study approach to bring you into this fantastic Excel world. Combining one case study with different Excel features and skills, this course will help you enhance those techniques/methods when you interact with a real-world example.
You will be walked through a complete process of problem-solving in Excel, which consists of the following:
1. Stage One – How to bring your data into Excel
2. Stage Two – How to process your data in Excel
3. Stage Three – How to share your work with others
Different features/methods will be introduced in various degrees per underlying issues at different stages.
There are many features and methods, including but not limited to the following:
1. POWER QUERY
2. CONDITIONAL FORMATTING
3. DATA FORMATTING
4. TABLE
5. FORMULAS
6. REFERENCE
7. DATA TRANSFORMATION
8. PIVOT TABLE
9. PAGE SETUP
10. DATA VALIDATION
11. …
Whether a feature is basic or advanced is determined by how you use it. That’s why we do not label any features as either basic or advanced. Even some so-called advanced features can be learned in just 30 secs!
