Complete Data Skills Curriculum - Analytics to Business Intelligence
Master the Complete Data Professional Stack - From Analytics to Database Management
Our comprehensive data skills curriculum covers the complete technology stack used by data professionals. From Excel analytics and SQL databases to Python programming and Power BI visualization - gain the skills needed for data careers in Kenya's digital economy.
Course Introduction Video
Watch our course introduction to discover how you'll master Excel from basics to advanced professional skills
10
Comprehensive Modules
120+
Excel Topics Covered
30+
Hands-on Projects
KES 10K
Monthly Investment
Module 1
Excel Fundamentals & Environment Setup
What You'll Learn:
- Excel Interface Navigation and Customization
- Understanding Workbooks, Worksheets, and Cell References
- Data Entry Best Practices and Validation Rules
- Basic Formatting: Fonts, Colors, Borders, and Alignment
- File Management: Save, Open, Import from Various Sources
- Essential Keyboard Shortcuts for Speed and Efficiency
- Setting up Professional Templates and Themes
- Understanding Excel Versions: 365, 2021, 2019 Differences
- Ribbon Customization and Quick Access Toolbar Setup
- Page Setup: Headers, Footers, Print Areas, and Scaling
- Data Types: Numbers, Text, Dates, and Boolean Values
- Cell Protection and Worksheet Security Basics
Module 2
Data Management & Organization Mastery
What You'll Learn:
- Data Import from Multiple Sources: CSV, TXT, XML, Database Connections
- Advanced Data Cleaning: Remove Duplicates, Fix Inconsistencies
- Text Functions: CONCATENATE, LEFT, RIGHT, MID, TRIM, SUBSTITUTE
- Date and Time Functions: TODAY, NOW, DATE, DATEDIF, NETWORKDAYS
- Data Validation: Drop-down Lists, Input Messages, Error Alerts
- Advanced Sorting: Multi-level Sort, Custom Sort Orders
- Filtering Techniques: AutoFilter, Advanced Filter, Unique Values
- Named Ranges: Static and Dynamic Named Ranges Creation
- Table Formatting and Structured References
- Find & Replace with Wildcards and Regular Expressions
- Text to Columns: Delimited and Fixed Width Parsing
- Data Consolidation from Multiple Worksheets
Module 3
Advanced Formulas & Functions Mastery
What You'll Learn:
- Logical Functions: IF, AND, OR, NOT, IFS, SWITCH
- Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH fundamentals
- Mathematical Functions: SUM, AVERAGE, COUNT and their variations
- Statistical Functions: MEDIAN, MODE, STDEV, PERCENTILE, RANK
- Error Handling Functions: IFERROR, ISERROR, ISBLANK, ISNA
- Text Analysis: LEN, FIND, SEARCH, EXACT, UPPER, LOWER, PROPER
- Date Calculations: WEEKDAY, MONTH, YEAR, EDATE, EOMONTH
- Array Formulas: Traditional Arrays and Dynamic Array Functions
- Nested Functions: Building Complex Multi-level Formulas
- Formula Auditing: Trace Precedents, Dependents, Error Checking
- Absolute vs Relative References: $ symbols and F4 shortcuts
- Function Categories: Math, Text, Date, Logical, Lookup & Reference
Module 4
Power Functions & Dynamic Analysis
What You'll Learn:
- XLOOKUP: The Future of Lookups with Multiple Match Modes
- SUMIFS, COUNTIFS, AVERAGEIFS: Multi-criteria Analysis Mastery
- Dynamic Array Functions: FILTER, SORT, UNIQUE, SEQUENCE
- INDIRECT Function: Creating Dynamic References and Formulas
- OFFSET Function: Building Dynamic Ranges and Moving References
- Power Query Introduction: Connect, Transform, Load Data
- Conditional Formatting with Formulas: Dynamic Visual Cues
- Advanced Array Formulas: SUMPRODUCT, Array Constants
- Spill Functions: Understanding Spill Ranges and # Errors
- LET Function: Variable Definition for Complex Formulas
- LAMBDA Functions: Creating Custom Reusable Functions
- Advanced Text Processing: TEXTJOIN, TEXTSPLIT, REGEX functions
Module 5
Data Visualization & Chart Excellence
What You'll Learn:
- Chart Types Deep Dive: Column, Line, Pie, Scatter, Area Charts
- Advanced Chart Formatting: Colors, Fonts, Legends, Data Labels
- Dynamic Charts: Using Named Ranges and OFFSET Functions
- Combination Charts: Primary and Secondary Axes Setup
- Sparklines: In-cell Mini Charts for Trend Analysis
- Interactive Charts: Form Controls, Scroll Bars, Check Boxes
- Professional Dashboard Design: Layout, Color Theory, Typography
- Chart Animation: Creating Presentation-Ready Visualizations
- Waterfall Charts: Step-by-step Value Analysis
- Gantt Charts: Project Timeline Visualization in Excel
- Heat Maps: Conditional Formatting for Data Patterns
- Advanced Chart Techniques: Error Bars, Trendlines, Annotations
Module 6
PivotTables & Advanced Business Intelligence
What You'll Learn:
- PivotTable Fundamentals: Structure, Fields, and Basic Operations
- Advanced PivotTable Techniques: Grouping, Custom Calculations
- Calculated Fields and Calculated Items: Custom Metrics Creation
- PivotCharts: Integration of Tables and Visual Analytics
- Slicers and Timeline Filters: Interactive Data Exploration
- Power Pivot: Data Model Creation and Relationships
- DAX Formulas: Data Analysis Expressions for Power Pivot
- Multiple Data Source Analysis: Combining Different Datasets
- PivotTable Formatting: Professional Report Appearance
- Drill Down and Drill Through: Detailed Data Analysis
- PivotTable Automation: Refresh, VBA Integration
- Advanced Filtering: Report Filters, Label and Value Filters
Module 7
Financial Modeling & Business Analysis
What You'll Learn:
- Financial Functions Deep Dive: NPV, IRR, PMT, FV, PV, RATE
- Scenario Analysis: Best Case, Worst Case, Most Likely Modeling
- Data Tables: One-Variable and Two-Variable Sensitivity Analysis
- Goal Seek: Reverse Engineering Target Values
- Solver Add-in: Complex Optimization and Constraint Problems
- Financial Statement Modeling: P&L, Balance Sheet, Cash Flow
- Budget Planning and Variance Analysis: Actual vs Budget
- ROI and Business Metrics: ROIC, ROE, Debt-to-Equity Ratios
- Investment Analysis: Payback Period, Profitability Index
- Risk Analysis: Monte Carlo Simulations, Standard Deviation
- Depreciation Calculations: Straight Line, Double Declining
- Loan and Mortgage Analysis: Amortization Schedules
Module 8
VBA Programming & Advanced Automation
What You'll Learn:
- VBA Development Environment: Editor, Project Explorer, Properties
- Recording and Editing Macros: Understanding Generated Code
- Variables and Data Types: String, Integer, Boolean, Object
- Control Structures: If-Then-Else, For Loops, Do-While Loops
- User Forms: Creating Custom Dialog Boxes and Input Forms
- Error Handling: On Error Resume Next, Try-Catch Equivalents
- File System Operations: Open, Close, Save, Directory Navigation
- Email Automation: Outlook Integration and Report Distribution
- Web Scraping: Extracting Data from Websites Automatically
- Custom Functions: UDF (User Defined Functions) Creation
- Event Handling: Worksheet Change, Workbook Open Events
- Add-in Development: Creating Professional Excel Extensions
Module 9
Professional Reporting & Executive Dashboards
What You'll Learn:
- Report Design Principles: Layout, Hierarchy, White Space
- Executive Dashboard Development: KPI Focus and Clean Design
- Performance Metrics: Creating Meaningful Business Indicators
- Interactive Controls: Buttons, Drop-downs, Option Groups
- Data Storytelling: Narrative Structure and Visual Flow
- Print Optimization: Page Breaks, Scaling, Professional Output
- PDF Export and Digital Distribution: Protecting and Sharing
- Template Standardization: Company Branding and Consistency
- Client-Ready Presentations: Executive Summary Formats
- Mobile-Friendly Design: Responsive Layout Considerations
- Version Control: Tracking Changes and Document Management
- Collaboration Features: Comments, Track Changes, Sharing
Module 10
Capstone Project & Professional Portfolio
What You'll Learn:
- Comprehensive Financial Analysis: Complete Business Case Study
- Real-world Dataset: Industry-Standard Data Analysis Project
- End-to-End Dashboard: From Raw Data to Executive Presentation
- Automated Reporting System: Self-Updating Reports and Alerts
- Portfolio Project Documentation: Professional Case Study Write-up
- Presentation Skills: Defending Your Analysis and Recommendations
- Interview Preparation: Technical Questions and Portfolio Review
- Career Advancement Strategies: Networking and Skill Marketing
- Continuing Education Path: Advanced Excel Certifications
- Industry Applications: Finance, Marketing, Operations, HR Use Cases
- Best Practices Summary: Professional Standards and Ethics
- Final Project Presentation: Executive-Level Delivery Skills
Course Features
- ✅ 100% Project-Based Learning
- ✅ Real-world Financial Sector Projects
- ✅ Expert Instructor with 8 Years Experience
- ✅ Portfolio-Ready Capstone Project
Investment
KES 10,000/Month
Was: KES 20,000/Month
50% Early Bird Discount!
Get Started
Phone: +254 705 572 368
Email: info@insightskillslab.co.ke