Looking to master Excel? We offer comprehensive introduction to Excel training services tailored to meet your needs. Whether you're a beginner or looking to enhance your skills, our training covers essential Excel features, including data entry, formulas, data analysis, and visualisation techniques. With practical, hands-on sessions, you'll gain the confidence to organise, analyse, and present data effectively. Join us in advancing your knowledge and skills in this dynamic field!
Mastery of Excel from basic to advanced levels.
Proficiency in data entry, analysis, and visualization.
Ability to create professional dashboards and automate workflows.
Skills to apply Excel tools for real-world business and research problems.
Uploads in progress
Understanding the Excel interface: Ribbon, workbook, worksheets, and cells.
Basic navigation: Selecting, copying, pasting, and formatting cells.
Saving, opening, and managing files in various formats (XLSX, CSV, etc.).
Hands-on activity: Creating a simple spreadsheet.
Entering and editing text, numbers, and dates.
Formatting cells: Font styles, colors, borders, and alignment.
Number formats: Currency, percentage, date, and custom formats.
Hands-on activity: Creating a formatted table for monthly expenses.
Introduction to formulas: Operators and cell references (relative and absolute).
Basic functions: SUM, AVERAGE, MIN, MAX, and COUNT.
Error handling in formulas: Common errors and fixes.
Hands-on activity: Calculating totals and averages for a dataset.
Sorting and filtering data for better analysis.
Data validation: Creating dropdown lists and restricting inputs.
Freezing panes and splitting windows for easier navigation.
Hands-on activity: Organizing a sales dataset with filters and validation.
Creating charts: Bar, line, pie, and scatter charts.
Customizing charts: Titles, labels, legends, and colors.
Introduction to conditional formatting: Highlighting trends and patterns.
Hands-on activity: Visualizing trends in a financial dataset.
Logical functions: IF, AND, OR, IFERROR.
Lookup functions: VLOOKUP, HLOOKUP, INDEX-MATCH.
Text functions: CONCATENATE, LEFT, RIGHT, TRIM, LEN.
Date and time functions: TODAY, NOW, DATEDIF, WORKDAY.
Hands-on activity: Analyzing employee attendance and performance data.
Creating and customizing PivotTables for data summarization.
Using slicers and filters in PivotTables.
Creating PivotCharts for dynamic data visualization.
Hands-on activity: Analyzing a sales dataset using PivotTables and PivotCharts.
Using Excel’s Data Analysis ToolPak:
Descriptive statistics.
Regression analysis.
Introduction to Solver for optimization problems.
Hands-on activity: Running a regression analysis on economic data.
Creating interactive dashboards with charts, slicers, and PivotTables.
Using sparklines for compact data visualization.
Best practices for dashboard design.
Hands-on activity: Building a sales performance dashboard.
Recording and running macros for repetitive tasks.
Advance to VBA: Writing basic scripts.
Automating data cleaning and report generation.
Hands-on activity: Automating a monthly financial report.
Sharing workbooks and tracking changes.
Protecting sheets and workbooks with passwords.
Using Excel online for real-time collaboration.
Hands-on activity: Collaborating on a shared project.