Master Excel from Zero to Hero

Same Excel, Different Way to Learn
What you'll learn
Build up a solid foundation with basic Excel skills
Learn multiple ways to handle large sets of data
Learn Power Query for data importing and normalisation
Master logical and efficient method to smooth your workflow
Learn formula, table, conditional formatting, data validation and more
Equip yourself with Excel advance skills for analysis and reporting
Learn table, pivot table, sharing and more
Requirements
This course was tutored based on Excel from Microsoft 365
Most features and functions are also relevant to Excel earlier version
Description
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 Excel2. Stage Two - How to process your data in Excel3. Stage Three - How to share your work with othersDifferent 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 QUERY2. CONDITIONAL FORMATTING3. DATA FORMATTING4. TABLE5. FORMULAS6. REFERENCE7. DATA TRANSFORMATION8. PIVOT TABLE9. PAGE SETUP10. DATA VALIDATION11. ...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!After this course, you should be able to:1. See the big picture from a process design perspective before you execute your plan in Excel2. Smooth your workflow for projects in the long run3. Make the report neat and understandable for your audiencesBy following the below formula, you are halfway to becoming a successful Exceller:EXCEL=LEFT("EXperiment",2)&LEFT("Concrete",1)&LEFT("Elastic",1)&LEFT("Leverage",1)Let's dive in and start your Excel journey today!
Who this course is for
Beginner to heavy Excel user
Excel user who wants to learn more Excel from different perspectives
Homepage