Welcome to Blitz Business Intelligence Program (BBIP)
Self-paced learning that matches your lifestyle
Start a transformative journey in business data analytics with the Blitz Business Intelligence Program (BBIP). Our online, self-paced courses are designed by industry experts to empower you with the essential skills needed to excel in today's data-driven world.
If you are a tech professional, or you are new to tech, you can be sure that our trainers are ready to guide you to become an expert in data analysis, visualization, manipulation, and interpretation.
Learn Microsoft Excel the way it should be taught
Blitz Business Intelligence Program (BBIP)-MS Excel Beginner to Pro is a comprehensive online training program that equips you with the knowledge and skills to leverage data for informed decision-making. Whether you're new to business intelligence or looking to advance your career, BBIP offers a flexible learning experience tailored to your needs.
You pay only a fraction of the whole program fee.
Learn from Seasoned Instructors
Master Microsoft Excel
Flexible, Self-Paced Learning
Blitz Business Intelligence Program (BBIP) Overview
What you will access by enrolling into Blitz Business Intelligence Program (BBIP)
Data Manipulation
Data visualization
Data modeling
Self paced virtual classes
Industry-Relevant Expertise
Microsoft Excel: Beginner to Pro
Program Details
Our instructors are industry veterans with years of experience in business intelligence and data analytics. They bring real-world insights and practical knowledge to help you succeed in the course and in the work environment where you will be applying the knowledge.
The cost of the Microsoft Excel specialized course is CA$100 (₦100,000.00).
However we have heavily subsidized the program as a BlackFriday offer for you!
Just for you today, the program fee is CA$50 (₦20,000) only!
Sneak Peek of The Training
Registration for this program is now closed!
Enrollment into our Comprehensive Data Analysis Program is currently ongoing.
We implore you to join CDAP today.
See What Our Students Have To Say
Each course in the BBIP program is designed to provide you with comprehensive knowledge and practical skills in a specific area of business intelligence. Explore our courses to find the perfect fit for your learning goals.
BBIP courses are self-paced, allowing you to learn at your own convenience.
Start anytime and progress through the courses at your own pace.
This is a self paced course that could be completed in a month or less, if you pace yourself.
1.0 Introduction
2.0 Excel Interface and Ribbons
2.1 Columns, Rows, Cells, and the Name Box
2.2 Excel Formular Bar
2.3 Working with the Function Wizard
2.4 Navigating Around a Spreadsheet
2.5 Navigating Around a Spreadsheet
2.6 Other Features of Rows and Columns
2.7 working with Sheets
3.1 Entering and Formatting Data in Excel
3.2 More Data Formatting Functions
4.1 Introduction to Excel Formulas
4.2 Relative and Absolute Referencing in Excel
4.3 Relative and Absolute Referencing - Multiplication Table
4.4 Relative and Absolute Referencing - Summarized
4.5 Introduction to Functions in Microsoft Excel
4.6 SUM Function
4.7 MIN and MAX Functions
4.8 Date Functions
4.9 IFS Function
4.10 VLOOKUP Function
4.11 XLOOKUP Function
4.12 SUMIFS Functions
4.13 COUNTIFS Function
5.1 Sorting Data in Excel
5.2 Filtering in Excel
6.1 Data Tools - Text to Column
6.2 Data Fills- Flash Fill
6.3 Data Validation
7.1 Bar or Column Chart
7.2 Stacked Column Chart
7.3 Line Chart
7.4 Pie Chart
7.5 Waterfall Charts
8.1 Conditional Formatting Highlight Rule
8.2 Conditional Formatting: Top -Button Rule
9.0 Protecting Worksheets and Workbooks
Introduction to Microsoft Excel Basics
Day 1: Understanding the Excel Interface
- Overview of the Excel interface (ribbon, cells, columns, rows)
- Navigating and selecting cells
- Introduction to Excel terminology (workbook, worksheet, cell, range)
Day 2: Data Entry and Formatting
- Entering data into cells (text, numbers, dates)
- Basic text formatting (font, size, bold, italic, underline)
- Introduction to cell formatting (alignment, borders, fill color)
Basic Formulas and Functions
Day 1: Formulas and Cell References
- Introduction to basic mathematical operators (+, -, *, /)
- Creating simple formulas
- Understanding cell references (relative, absolute)
Day 2: Common Functions
- Introduction to common functions (SUM, AVERAGE, MAX, MIN)
- Practical exercises using functions
- Tips for troubleshooting formulas
Data Management and Analysis
Day 1: Sorting and Filtering Data
- Sorting data in Excel
- Filtering data using AutoFilter
- Custom filtering options
Day 2: Data Validation and Data Tools
- Setting up data validation rules
- Introduction to Data Tools (Text to Columns, Remove Duplicates)
- Overview of Flash Fill for data manipulation
Charts and Graphs, Advanced Features
Day 1: Creating Charts and Graphs
- Introduction to chart types (bar, line, pie)
- Creating and customizing charts
- Adding data labels and legends
Day 2: Advanced Excel Features
- Introduction to PivotTables
- Data consolidation techniques
- Overview of conditional formatting
- Protecting worksheets and workbooks
Frequently Asked Questions
A computer with a minimum of 4GB RAM is required. However, if you intend to get a new laptop for the program, it is advisable to get a Windows computer with at least 8GB RAM for more efficiency.
Mathematics is not a requirement for the program. The program does not require any form of manual calculation or having to memorize mathematical formulas.
Upon registration, you will be provided with a step-by-step guide on installing the software required.
A MacBook could be used; however, it is not recommended.
The training will be delivered by video.
The training videos will be available and accessible the next business day after the training.
Yes. The training is broken down into modules that will help all beginners get up to speed with every other person in the class.
No, not entirely. Only Python requires coding and the guidance required to learn this will be provided. With adequate practice, each participant will be able to acquire the required skills.
Getting a job after the training is the goal of the training faculty, however, this is not automatic. The dedication and resilience of the participants is also required to ensure that all the prerequisites for employment are met.
Our program offers more value for your money than other trainers. Our Data Analytics curriculum has been tested over the years to cater to both tech newbies and professionals who simply want to upskill, and we keep upgrading it. Our training sessions are more granular and our cohorts are more intensive.
Our training goes beyond just acquiring a set of skills. While you are attending the training, you will earn a completion badge for each of the courses you complete. This is sharable on LinkedIn as you build your profile. At the end of the training, you will also obtain a certificate. This will serve as a symbol of your commitment to completing the program to potential employers.
Earn one of the most desirable certifications in Canada and the United States
You will be earning a certificate to show employers your competence.
This certificate signifies you have not only completed the training but also the capstone projects.
Meet the Trainer That's Invested in Your Success
Charles Otoghile
Trainer
Meet Charles Otoghile, an expert guide to mastering business strategy, spreadsheets, data analysis and financial modeling/valuation. With over a decade of experience working in multinational corporations, Charles brings a wealth of practical knowledge in hands-on data analytics and business management to the table. Holding a degree in Management Sciences and certified as a Microsoft Office Specialist in Microsoft Excel and Microsoft Access, Charles is a Master of Data Management and its associated tools in the everyday life of business. He expertly uses and provides training on Microsoft Excel, Microsoft Access, SQL, Python/Pandas and PowerBI. Renowned for his passion for best practices in financial modeling and business data analysis, Charles is into business consulting and shares his expertise in spreadsheet modeling, valuation, and data analysis/analytics
Read More Read Less
Share This Opportunity With Your Friends
Click on any of the social icons below to share!
Facebook
Twitter
LinkedIn
WhatsApp
Email
Telegram
© Hitech Blitz Consulting. All Rights Reserved.