Your cart
![Excel Tricks & Techniques Online Course - LearnDrive Key - GLOBAL](http://keynd.com/cdn/shop/files/3e3f231a7324d281ef6634a2e3bf5398_765x.png?v=1713280605)
Enrol in our Excel Tricks & Techniques Online Course to unlock the full potential of Excel and revolutionise the way you work with data. Sign up now and transform your Excel skills from fundamental to extraordinary!
- Introduction: Begin with an overview of what to expect from the course. Set the foundation for a journey into advanced Excel functionalities and how they can transform your data handling capabilities.
- Neat Tricks to Supercharge Your Productivity: Discover a variety of shortcuts, hidden features, and efficiency-boosting tricks. Learn how to streamline your workflow and make Excel work harder for you.
- Using Wildcards with Formulas: Master the use of wildcards (*, ?, ~) in Excel formulas to perform flexible and dynamic searches within your data.
- The Awesome SUMPRODUCT Function - The Swiss Army Knife of Functions: Dive into the SUMPRODUCT function, exploring its versatility in performing multiple calculations, conditional sums, and array operations within a single, powerful function.
- Advanced PivotTable Tricks: Uncover advanced techniques for manipulating and analysing data with PivotTables. Learn to create complex reports, visualise data trends, and unlock the analytical power of PivotTables.
- The Hidden Power of the MOD Function: Explore the MOD function's capabilities in solving complex problems, from conditional formatting to generating patterns and sequences in your data.
- The Magic of the INDIRECT Function: Understand how to use the INDIRECT function to reference cells dynamically, making your formulas more flexible and powerful.
- The Incredible INDEX Function: Gain insights into the INDEX function, a versatile tool for retrieving specific values within a range or array, enhancing data lookup and reference capabilities.
- COUNTIF Function - A Mega Useful Excel Function: Leverage the COUNTIF function to count cells that meet specific criteria, a fundamental skill for data analysis and management.
- Introducing Custom Number Formatting: Learn to apply custom number formats, transforming how data is displayed without altering the actual cell value, for clearer and more effective data presentation.
- Advanced Custom Formatting Examples that Users did not know were Possible: Delve
- into complex custom formatting techniques that can change the way you visualise and work with data in Excel.
- Advanced Chart Tricks for Dynamic Interactive Charts: Discover how to create dynamic and interactive charts, elevating your data visualisation skills and making your reports and dashboards more engaging and informative.