Duration: 1 Day
Course Overview
This Intermediate course is designed for users who are familiar with the basics of Excel and want to enhance their skills to work more efficiently with data. The course covers a range of tools, functions, and techniques for analyzing, organizing, and visualizing data to make it actionable and more insightful.
Target Audience
Participants will already have a basic knowledge of Excel, including working with basic calculations, data entry, and cell formatting, and want to further enhance their knowledge of Excel.
Formulas and Functions:
Logical functions: IF, AND, OR, NOT.
Lookup functions: XLOOKUP
Text functions: TEXTJOIN, TEXTSPLIT.
Dates and Time Functions: TODAY, NOW, YEAR, MONTH, DAY, DATEDIF.
Data Cleaning Techniques: Removing duplicates, splitting text, and using Flash Fill effectively.
Working with Tables: Creating and formatting tables, structured references, and table styles.
Advanced Charting Techniques: Combo charts, sparklines, scatter plots, and customization.
Data Validation: Setting rules for data entry, dropdown lists, and error messages.
Named Ranges: Defining and using named ranges for easier formula writing.
Pivot Tables Basics: Creating, modifying, and filtering pivot tables.
Conditional Formatting: Understanding and Using Conditional Formatting
By the end of this course, participants will feel more competent in Excel and equipped to handle various intermediate tasks, making them more effective in data-driven roles.
