Course Details

Learn how to harness the power of Excel for data analysis, reporting, and problem-solving. This syllabus will take you from Excel beginners to advanced users, equipping you with the tools needed for real-world data challenges covering practical skills that help to manipulate data, perform calculations, create visualizations, and automate tasks with advanced tools.

MICROSOFT EXCEL

Learn how to harness the power of Excel for data analysis, reporting, and problem-solving. This syllabus will take you from Excel beginners to advanced users, equipping you with the tools needed for real-world data challenges covering practical skills that help to manipulate data, perform calculations, create visualizations, and automate tasks with advanced tools.

Course Fee

₦ 30,000

Duration

4weeks

APPLY
  • Navigating the Excel workspace.
  • Understanding worksheets, workbooks, and file management.
  • Basic operations (entering data, copying/pasting, etc.)
  • Data entry techniques.
  • Formatting cells, rows, and columns.
  • Working with dates, text, and numbers.
  • Sorting and filtering data for quick insights.
  • Introduction to basic formulas (SUM, AVERAGE, MIN, MAX, etc.).
  • Using relative and absolute cell references.
  • Logical functions (IF, AND, OR, etc.).
  • Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
  • Conditional formatting for dynamic visuals.
  • Data validation and drop-down lists.
  • Pivot tables for summarizing and exploring data.
  • Pivot charts for visualization of pivot data
  • Creating different types of charts (bar, line, pie, scatter).
  • Customizing chart elements (titles, legends, axes, etc.).
  • Best practices for visualizing data
  • Array functions and formulas (SUMPRODUCT, INDEX/MATCH).
  • Text functions (LEFT, RIGHT, MID, CONCATENATE).
  • Date and time functions (TODAY, NOW, DATEDIF).
  • Introduction to financial functions (NPV, IRR, PMT).
  • Creating dynamic financial models.
  • Budgeting and forecasting techniques
  • Removing duplicates, handling missing data.
  • Text to columns, Flash Fill.
  • Using Power Query for data transformation.
  • Recording and editing macros.
  • Automating repetitive tasks.
  • Introduction to VBA (Visual Basic for Applications).
  • Building dashboards for business insights.
  • KPI tracking with Excel.
  • Scenario analysis and data forecasting.