Data Analytics

Excel & SQL

The two tools every analyst job asks for

Phone: +237 672 149 730

ImageImageImageImageImage

Course Description

Excel and SQL are what employers mean when they ask whether you can work with data. Excel is where most business records still live, and SQL is how you reach the ones that have outgrown a spreadsheet.
Excel & SQL takes you from structured tables and lookups through to querying a database directly. You will master the formulas and pivot tables that summarise thousands of rows, then write SQL that filters, groups and joins tables so you are never limited by what somebody else exported for you.

Course Outline

Avatar
Week 1

Excel For Real Business Data

Work the way analysts do: structured tables, absolute and relative references, named ranges, and the keyboard work that makes a thousand-row file quick instead of painful.
Avatar
Week 2

Formulas, Lookups And Pivot Tables

Join data across sheets, summarise thousands of rows by product, branch or month, and build the pivot tables that answer most business questions in seconds.
Avatar
Week 3

Querying Databases With SQL

Ask a database directly for what you need. Filter, sort and limit records so you stop waiting on somebody else to send you an export.
Avatar
Week 4

Grouping And Joining Tables

Aggregate records into the totals a report needs, then combine customers, orders and products across tables to answer questions no single table can.
Avatar
Week 5

From Query To Report

Close the loop: query the database, bring the result into Excel, build the summary, and set it up so next month is a refresh rather than a rebuild.
Message Us