Excel class - Intermediate

This intermediate Excel course moves into more advanced functionality to locate, calculate, summarize and format data. Learn to summarize and organize data in Excel with Pivot Tables, write advanced functions using XLOOKUP, and create advanced charts. Discover statistical formulas like COUNTIFS and SUMIFS to better understand data, and learn Excel techniques to work more efficiently. Attend this intermediate Excel training and learn to use tools and techniques that will make you efficient in summarizing, calculating and validating data.

What you learn in this intermediate Excel course

• Data Validation: Control what data can be entered into a cell by creating rules and restrictions. Learn to create drop-down menus for selecting from pre-populated data, ensuring data consistency and reducing input errors. For example, restrict entries to dates within a specific range or allow only numeric values.
• Sort & Filter: Discover how to efficiently organize your data by sorting it alphabetically, numerically, or by custom criteria. Learn to filter data to display only the information you need, making it easier to analyze and interpret large datasets. For instance, sort a list of employees by last name or filter sales data to show only the results from a specific region.
• PivotTable: Learn PivotTables like a pro. Gain expertise in using PivotTables to quickly analyze and summarize large datasets. Learn to create dynamic reports that allow you to compare different variables, identify trends, and make data-driven decisions. For example, summarize sales data by region and product to understand performance trends.
• LOOKUP functions: Learn to use XLOOKUP, VLOOKUP, and HLOOKUP to retrieve data from tables based on matching values. Find a city from a ZIP code, a product price by an ID number, or a customer name from an invoice number. Discover how XLOOKUP offers a simple way to search both vertically and horizontally using a single formula.
• IF Statements: Explore how to create complex formulas using IF statements to produce different outcomes based on specified conditions. For instance, calculate a discount based on whether a purchase amount exceeds a certain threshold or assign grades to test scores.
• SUMIFs: Master the SUMIF function to sum values that meet specific criteria you define. This is useful for tasks such as totaling sales for a particular product category or calculating expenses for a specific department.
• COUNTIFs: Learn how to use the COUNTIF function to count the number of cells within a range that meet a particular condition. For example, count the number of employees in a department or the number of orders that exceed a certain amount.
• Split and Join Text: Understand how to use the Text to Columns feature to split text into multiple columns based on delimiters, such as commas or spaces. Additionally, learn to join text from different cells into a single cell, useful for combining first and last names or merging addresses.
• Navigation Shortcuts: Enhance your efficiency by mastering keyboard shortcuts and techniques to quickly navigate around worksheets. Learn to jump between cells, select ranges, and manage multiple sheets with ease, saving you time and effort.
• Using Templates: Discover the benefits of using templates to maintain consistent branding, colors, styles, and fonts across your documents. Learn to create and customize templates for different types of reports and presentations, ensuring a professional and uniform look.