Excel tips & tricks course

If you have previous experience in Excel, whether self-taught or learned long ago, this Excel course helps you to improve your skills and improve your efficiency. This Excel class covers a range of essential topics, ensuring you can work smarter and faster with Excel spreadsheets. Some of the topics covered include:

• Workbook and File Management: Learn techniques for managing Excel workbooks and files, saving time when navigating complex spreadsheets.
• Data Formatting for Impactful Presentations: Master formatting to transform raw data into easy to understand and visually appealing presentations, making your information more readable and persuasive.
• Advanced Formulas and Error Prevention: Unlock the full potential of Excel formulas, discover tips, reference strategies, and error prevention methods, to ensure accurate and efficient data handling.
• Data Manipulation Techniques: Gain proficiency in creating drop-down lists, conditional formatting, and dynamic data transposition to streamline and customize your data workflows.
• Tables and Pivot Tables for Data Analysis: Explore the power of tables and pivot tables to analyze and present data comprehensively, helping you derive meaningful insights with ease.
• Charts and Graphs Configuration: Learn to create charts and graphics, enabling you to present complex data in clear and engaging visual formats.
• In-line Progress Trackers and Spark Lines: Enhance data visualization with embedded visual progress indicators and tiny, powerful sparkline charts directly within Excel cells. Show trends, progress, and performance at a glance.
• Advanced Table Functions: Leverage advanced table features in Excel, including structured references and automatic formula propagation across tables. Use table designs, advanced sorting, and filtering to streamline your data analysis and create dynamic, self-updating reports.
• New GROUPBY and PIVOTBY functions: Simplify complex summarizations and reshaping of data tables without needing a PivotTable. Dynamically group datasets and instantly pivot based on row, column, and value within a formula.
• Advanced Table Functions: Leverage advanced table features in Excel, including structured references and automatic formula propagation across tables. Use table designs, advanced sorting, and filtering to streamline your data analysis and create dynamic, self-updating reports.
• Advanced lookups and returns using Using DGET and FILTER: Use DGET and FILTER functions to perform advanced data retrieval and dynamic extraction directly from lists and datasets. Return single database records or extract multiple matching rows dynamically based on specific criteria.
• Advanced Pivot Tables using Calculated Items and Fields: Create custom Calculated Items and Fields for on-the-fly computations inside a Pivot. Customize how data is aggregated using summarization techniques to create more meaningful reports and gather deeper insights.

By the end of the course, you'll have a set of Excel skills that will help you to work more effectively and accurately.