Live Sessions and Courses

Data Analytics with Excel, Power BI & SQL

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, SQL, Excel, Microsoft Word, PowerPoint, Outlook, Teams and other PowerApps

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

Excel – Course Content

5 Models

Refer to Course Content

Refer to Course Content

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.

Refer to Course Content

Refer to Course Content and Project Document

Power BI -Course Content

5 Models

Refer to Course Handout

Refer to Course Handout

Refer to Course Handout

Refer to Course Handout

Refer to Course Handout

SQL – Course Content

5 Models

Refer to Course Handout

Refer to Course Handout

Refer to Course Handout

Refer to Course Handout

Refer to Course Handout

Start Getting New Knowledge and Experience, Together!

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

Register Now