Atlanta

New York City

Boston

London

Lausanne

Barcelona

Dubai

Cambridge

Kuwait City

Fontainebleau

Excel is the most widely used piece of software for creating actionable insight. Accordingly, Excel Lab: From Excel Beginner to Guru provides a comprehensive overview of the core functions of Excel and is designed to take absolute beginners to proficiency in the shortest amount of time possible.

Participants will leave with a strong knowledge of how to analyse, structure and solve real-world business problems using Excel.

Agenda
Session 1: Introduction & Data Auditing
Session 2: Formulas
Session 3: Relative References
Session 4: Lookups - VLookup
Session 5: Grouping & Summarising - Pivot Tables, Aggregate Functions
Session 6: Charts

Excel I - From Excel Beginner to Guru

Learning these techniques from scratch usually equates to hours of googling and frustration as you search for real examples rather than theory. In this course, we focus on the most relevant and practical methodologies to help you solve real-life business problems that ensures you are able to rapidly up-skill and drive actionable insight from data.

Participants will leave with a full proficiency in how to solve real-world business problems using Excel.

Agenda
Session 1: Introduction to the Data Lifecycle
Session 2: Index-match
Session 3: Excel Tables & Array formulas
Session 4: Analysis
Session 5: Modelling
Session 6: Dashboards

Excel II - Advanced Techniques &  Data Lifecycle in Practice

Diving Into Data: Fundamentals of SQL is a course designed specifically for non-technical business professionals wanting to learn SQL in a fast, fun and efficient manner. The course is designed with business practicality in mind at every step to ensure the concepts taught are grounded in business applications rather than technical theory. To do this, you will be granted access to the Afterskills SQL coding environment to practice writing and executing queries in real-time allowing you to rapidly up-skill in a safe environment that you wouldn't have the opportunity to do otherwise.

Upon completion of this course, participants will understand SQL's basic syntax, how to write their own queries and ultimately how to use SQL to rapidly generate business insights.

Agenda
Session 1: Introduction & Writing Your First Query
Session 2: Where & Operands
Session 3: Aggregate functions
Session 4: Group By
Session 5: Join
Session 6: Like
Session 7: Order By

SQL I - Diving Into Data: Fundamentals of SQL

Business Applications: SQL in the Workplace builds on SQL I concepts and begins with an introduction to greater SQL functionalities that can optimize and make more complex queries possible.  The remainder of the course is focused purely on practice and mastery of Structured Query Language in the workplace.  Beginning with business prompts one would encounter on the job, students can trial and error their answers in Afterskills' proprietary platform to rapidly up-skill in a safe and collaborative environment.

Upon completion of this course, participants will have a solid understanding of SQL syntax, how to write and debug their own queries and ultimately how to efficiently use SQL in more complex situations to generate business insights.

Agenda
Session 1: Case
Session 2: Nested Queries
Session 3: Having
Session 4: Dates
Session 5: Exercises I
Session 6: Exercises II
Session 7: Exercises III

SQL II - Business Applications:  SQL in the Workplace

Fundamentals of Python is designed specifically for business professionals to learn Python in a fast, fun and efficient manner with business practicality and applicability as the common theme throughout. Therefore, rather than learning all the technical and theoretical aspects of a coding language, you will learn only what's needed to get the job done.

Upon completing this course, participants will have a fundamental understanding how Python works and handles different types of data, its basic syntax and how to both write and utilise pre-built functions to generate insight from data.

Agenda
Session 1: Intro to Programming & Data Types
Session 2: Variable Assignment & Functions
Session 3: Lists, Sets, & Tuples
Session 4: Conditional Statements
Session 5: Loops

Don’t lose your preferences!