Excel class - Intermediate

Microsoft Excel class: Intermediate - Topics covered

• 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.
• VLOOKUP: Learn the VLOOKUP function to retrieve information from a table based on a related value in another column. This skill is essential for tasks such as looking up a city name based on a ZIP code or finding a product price based on its ID.
• 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.