WEBINAROUTLINE

Excel Fundamentals: Working with Formulas and Functions

• Understanding cell references (relative, absolute, mixed)
• Writing basic formulas and function syntax
• Key Functions:

         o   Statistical Functions (SUM, AVERAGE, COUNT, MAX, MIN)

         o   Text Functions (LEFT, RIGHT, MID, CONCAT, TRIM)

         o   Date & Time Functions (TODAY, NOW, DATEDIF, YEAR, MONTH)

Data Formatting and Enhancement

• Best practices for organizing datasets
• Applying Conditional Formatting for data insights:

         o   Highlighting trends, duplicates, and outliers

         o   Using color scales and icon sets for quick analysis

Built-in Reporting and Data Analysis Tools

• Sorting data for better organization
• Filtering for focused analysis
• Using Subtotal Function for quick summaries
• (Optional quick demo) Introduction to Tables for dynamic reporting