This course
Advanced Excel
$1,000
One course from the outline.
Beginner friendly100% online, self-paced
Advanced Excel
Formulas, lookups, pivot tables, data cleaning and charts for analysis.
What you will learn
Clean, organise and analyse data in Excel with formulas, lookups and pivot tables.
What you will build
This course feeds the program's Sales Performance Workbook portfolio piece.
Project 01
Clean a messy sales dataset in Excel and build a summary report with pivot tables and charts.
Skills shown
- Excel
- Data cleaning
- Pivot tables
Skills you'll learn
- Data cleaning
- Data analysis
Certification pathway
This course prepares fellows for this industry certification. Exams are taken with the certifying body, and exam fees are paid separately.
Microsoft
Microsoft Office Specialist: Excel Associate (MO-210)
Prepared in
PL-300 is the most widely recognised of the three for data analyst roles. Most fellows take it after finishing the Power BI course.
Prerequisites and requirements
Prior experience
None. Basic computer skills and comfort with simple maths are enough. No coding background is needed.
Language
Good written and spoken English.
Equipment
A laptop or desktop computer and a reliable internet connection. A phone or tablet alone is not enough for the tools used. Power BI Desktop runs on Windows, so Mac users need a Windows setup or the online version.
How learning works at FairChild
Fully online and self-paced
Study from anywhere, on your own schedule, through the FairChild learning portal.
Learn by doing
Every course ends with practical work, and the projects build a portfolio employers can review.
Choose your pace
Finish in 6 months on the accelerated track or spread the work over 12 months.
Join the fellows community
Connect with other FairChild fellows working through the same courses.
Add mentorship and career support
Pair the program with Guided Mentorship & Career Development, or join through the FairChild Fellowship, for interview preparation and career coaching.
Take it on its own, or with the full program
Full program
Data Analysis Institute
$5,000$5,500
All 5 courses, all projects, 6- or 12-month access.
- Advanced Excel(this course)
- SQL
- Python & R
- Power BI
- Data Storytelling & Documentation
Only The Best Brains Teach at FairChild Institute
Our mentors aren't just teachers. They're practitioners solving real problems with data every day.
CRM Platform & Projects
Oluwaseyi Allison
I work in CRM every day. I teach project delivery from the field, not the textbook.
Data Analytics & Business Intelligence
Malik Pelumi Bello
Data and BI are my world. I teach you to make numbers tell a story.
Business analysis
Baba Nureni-Yusuf
BA is where I made my name. I teach the craft and the interview game.
Agile and Scrum Mastery
Babajide Onabajo
Agile is how I run teams. I teach Scrum without the jargon.
Salesforce Service Cloud with Projects
Debo Fafore
I build on Service Cloud. I teach solutions that survive go-live.
Salesforce Essentials
Samson Bavo
Salesforce got me in the door. I teach the essentials that still do.
Salesforce Sales Cloud
Sophie Mokah
I live in Sales Cloud. I teach setups that help teams sell.
Data Analytics & Business Intelligence
Qahhar Okenla
BI is my thing. I teach dashboards people actually open.
Salesforce Experience Cloud
Ogenna Odebatu
Experience Cloud is my space. I teach portals built for real users.
Triple Play Course B - Salesforce Flow Automation Implementations
Niloy Debnath
Flow is what I do. I teach automations that work on day one.
Triple Play Course A - 8+ Salesforce Project Implementation
Oladipo Ojo
8+ projects in. I teach Salesforce how it's done on the job.
Triple Play Course C - Salesforce Admin Platforms Implementations
Olanrewaju Badiru (Ola B)
Admin platforms are my lane. I teach configs built for production.
CRM Platform & Projects
Oluwaseyi Allison
I work in CRM every day. I teach project delivery from the field, not the textbook.
Data Analytics & Business Intelligence
Malik Pelumi Bello
Data and BI are my world. I teach you to make numbers tell a story.
Business analysis
Baba Nureni-Yusuf
BA is where I made my name. I teach the craft and the interview game.
Agile and Scrum Mastery
Babajide Onabajo
Agile is how I run teams. I teach Scrum without the jargon.
Salesforce Service Cloud with Projects
Debo Fafore
I build on Service Cloud. I teach solutions that survive go-live.
Salesforce Essentials
Samson Bavo
Salesforce got me in the door. I teach the essentials that still do.
Salesforce Sales Cloud
Sophie Mokah
I live in Sales Cloud. I teach setups that help teams sell.
Data Analytics & Business Intelligence
Qahhar Okenla
BI is my thing. I teach dashboards people actually open.
Salesforce Experience Cloud
Ogenna Odebatu
Experience Cloud is my space. I teach portals built for real users.
Triple Play Course B - Salesforce Flow Automation Implementations
Niloy Debnath
Flow is what I do. I teach automations that work on day one.
Triple Play Course A - 8+ Salesforce Project Implementation
Oladipo Ojo
8+ projects in. I teach Salesforce how it's done on the job.
Triple Play Course C - Salesforce Admin Platforms Implementations
Olanrewaju Badiru (Ola B)
Admin platforms are my lane. I teach configs built for production.
CRM Platform & Projects
Oluwaseyi Allison
I work in CRM every day. I teach project delivery from the field, not the textbook.
Data Analytics & Business Intelligence
Malik Pelumi Bello
Data and BI are my world. I teach you to make numbers tell a story.
Business analysis
Baba Nureni-Yusuf
BA is where I made my name. I teach the craft and the interview game.
Agile and Scrum Mastery
Babajide Onabajo
Agile is how I run teams. I teach Scrum without the jargon.
Salesforce Service Cloud with Projects
Debo Fafore
I build on Service Cloud. I teach solutions that survive go-live.
Salesforce Essentials
Samson Bavo
Salesforce got me in the door. I teach the essentials that still do.
Salesforce Sales Cloud
Sophie Mokah
I live in Sales Cloud. I teach setups that help teams sell.
Data Analytics & Business Intelligence
Qahhar Okenla
BI is my thing. I teach dashboards people actually open.
Salesforce Experience Cloud
Ogenna Odebatu
Experience Cloud is my space. I teach portals built for real users.
Triple Play Course B - Salesforce Flow Automation Implementations
Niloy Debnath
Flow is what I do. I teach automations that work on day one.
Triple Play Course A - 8+ Salesforce Project Implementation
Oladipo Ojo
8+ projects in. I teach Salesforce how it's done on the job.
Triple Play Course C - Salesforce Admin Platforms Implementations
Olanrewaju Badiru (Ola B)
Admin platforms are my lane. I teach configs built for production.
FAQ
No. Every program starts with the basics and builds up step by step.
