Live Sessions and Courses

Data Analytics with Excel & Power BI

Data analytics track prepare students for analyzing large datasets, deriving insights, and making informed decisions in various sectors.

Enroll Now

40+ already enrolled!

Course Detail

Microsoft Excel & Power BI

Course Features

Live Class Sessions.
Recorded videos (on course portal).
24/7 Instructor Support.

Ernest Larbi Okai

Instructor

Okai Larbi Ernest is a seasoned professional with extensive experience in the IT Training using Power BI, Excel, Microsoft Word, PowerPoint, Outlook, Teams and other PowerApps

20 hours on-demand video
Full Lifetime Access
Access on Mobile and TV
Certificate of Completion

Excel – Course Content

11 sections • 28 lecture • 19h 33m total length

Importing Data:

Importing CSV and Excel files.
Importing data from web and other external sources.

Data Cleaning:

Removing duplicates.
Handling missing values.
Text-to-Columns for parsing data.
Using Flash Fill for quick data formatting.
Filling empty cells.
Using Find and Replace.
Handling errors with IFERROR.

Sorting and Filtering:

Sorting data by single or multiple columns.
Filtering data using AutoFilter.

Conditional Formatting:

Highlighting cells based on rules.
Using data bars, color scales, and icon sets.

Data Manipulation:

Removing duplicates from worksheets.
Validating data entries.
Referencing cells dynamically.

Basic Formulas:

Arithmetic operations (SUM, AVERAGE, MIN, MAX).
Counting functions (COUNT, COUNTA, COUNTIF).

Text Functions:

CONCATENATE (or CONCAT), TEXTJOIN.
LEFT, RIGHT, MID.
TRIM, LEN, FIND, SEARCH.

Logical Functions:

IF, AND, OR, NOT.
Nested IF statements.

Lookup and Reference Functions:

VLOOKUP, HLOOKUP.
INDEX and MATCH.

Date and Time Functions:

TODAY, NOW.
DATE, DATEDIF, YEAR, MONTH, DAY.

Array Formulas and Functions:

Basic introduction to array formulas.
Using array functions like TRANSPOSE, SEQUENCE.

Data Import and Connection

Connecting to various data sources (Excel, SQL, Web, etc.).

Data Transformation

Removing and renaming columns.

Changing data types.

Splitting and merging columns.

Data Aggregation

Grouping data by columns.

Summarizing with aggregation functions (SUM, COUNT, AVERAGE).

Data Merging and Appending

Merging queries (like SQL JOIN).

Appending data from multiple queries.

Adding New Columns

Creating custom, conditional, or indexed columns.

Data Cleaning

Removing duplicates and blanks.

Trimming text, fixing casing issues.

Sorting and Filtering

Sorting data by columns.

Filtering rows based on conditions.

Pivoting and Unpivoting Data

Transforming data by pivoting or unpivoting columns.

Date and Time Functions

Handling and manipulating date and time data.

Data Load and Refresh

Refreshing data from the source.

Loading transformed data into Power BI or Excel.

Power BI -Course Content

11 sections • 28 lecture • 19h 33m total length

Refer to Course Handout

We are open to go the next extra mile with you. Register Now

Ernest Okai Larbi

Chief Executive Trainer

Unlimited Online Resources

Once you join the class, you have access to join our live sessions as well as access to all our recorded videos, handouts, practice sheet and other important resources even after the course duration.

Access to Instructor

Your instructor will guide you throughout the course, regardless of your current skill level. After completing the course, you’ll continue to receive support from your instructor for any personal or work-related tasks you may have.

Future Opportunities

Upon graduation, our students become part of the Graduate Community, where we help them secure internship opportunities. For our working professionals, we provide job alerts through the platform, and our alumni in prestigious institutions actively support the younger members in finding better opportunities.

Start Getting New Knowledge and Experience, Together!

Embark on a journey of discovery and growth as you explore new knowledge and experiences alongside others!