Skills Accelerator - B1 - Session 6 - 28 April 2025

In the 6th session of the HLC Skills Accelerator, participants explored Excel and Google Sheets capabilities for smarter data analysis, formula building, and visualization. 🧠 Key Topics Covered: Logical tests: IF, nested IFs, COUNTIF, SUMIF Conditional formatting and error checking for data validation Relative vs. absolute referencing in formulas Lookup functions including VLOOKUP and advanced matching strategies Introduction to custom number formatting and lambda functions Techniques for converting text to numbers and managing formula errors Use of sparklines, subtotals, and Office 365-exclusive tools Preparation for future sessions on pivot tables and financial modeling 📌 This session emphasized structured logic in Excel formulas and highlighted essential skills for building dynamic, error-free spreadsheets used in real-world financial analysis and reporting. Practice exercises were encouraged, especially in applying referencing techniques and logical conditions across varied datasets. #ExcelTraining #ConditionalFormatting #LogicalFormulas #ExcelFunctions #DataAnalysis #PivotTables #Office365Excel #SpreadsheetSkills #HLCConsultants #SkillsAccelerator