fbpx
NEXT CLASS STARTS

● September 7: 2024

Days
Hours
Minutes
Seconds
Analytics skills will always be needed forever!!

Prepare your Teenagers for the JOB Market even while they are still in School.

WHY SHOULD YOUR CHILD LEARN EXCEL/GOOGLE SHEET FOR DATA ANALYTICS

There is almost no company that doesn’t use Microsoft Excel or Google sheet. Excel and google sheet are so basic that no matter how small a company is, there will always be be a need for someone who has excel skills for analytics.

It is no more news that the whole world has now gone digital.. It is no more going.. it has gone already. So anyone who doesn’t have digital skills right now including teenagers are already left behind. 

One way to ensure that your kids and teenagers catch up with the reality of the job landscape in the 21st century is by ensuring they learn digital related skills early enough by using analytic tools like Excel

Any teenager who likes numbers and mathematics will find excel and google sheet really interesting.. 

You can set your kids on the path to becoming a certified data analyst  right from now by enrolling them for Microsoft Excel/Google sheet.

 Some of the career paths your kids can go into if they are proficient with microsoft excel are:

  • Data Analytics
  • Data science
  • Data Engineering
  • Data Governance among others

As a matter of fact, over 1.1 billion people were already using Excel as at may 2022. Now imaging how many people by 2024

So there is no way your kids are going to escape the importance of knowing how to use excel

YOUR KIDS NEED TO START NOW..

Program details:

  • Suitable for Ages (12-20)
  • Class times :
    • Saturdays: 10am-12 noon (Nigerian time)
    • Sundays: 5pm – 7pm
  • Duration: 2 Months
  • Replays available after each class
  • Scroll down to see the tuition
  • Free whatsapp support group for personal development even after the training
  • Classes are done remotely. You don’t have to leave your location
  • Live Intructor-led classes
  • 2 months of hand-on session 
  • Free support/Development whatsapp group post completion
  • Certificate of completion
  • Replay available after each class
  • Mini tasks after each class
  • Capstone projects
  • Career roadmap
WHAT YOU WILL GAIN
WHO THIS PROGRAM IS FOR
THE CURRICULUM IS FOUND BELOW:
  • EXCEL DATA ANALYTICS/GOOGLE SHEET
  • Pleas note that we can either teach them microsoft Excel/Google sheet depending on the one that is easier for your teenagers to get access to because we want to ensure it is accessible as possible to limit installation stress etc. But they work the same way (whether excel or google sheet)
WEEK 1
DATA CLEANING & MANIPULATION I
  • Navigating through a worksheet.
  • Data formats in Excel.
  • Fill, copy, insert, move, and delete data.
  • Simple excel shortcuts.
  • Range, Relative and Absolute Addressing.
  • Find and Replace texts.
  • Removing duplicates from data
WEEK 2
DATA CLEANING II
  • Data cleaning and preparation with text functions.
    like Substitute, Mid, Concatenate.
  •  Trim, Proper, Lower, Upper, Left and Right functions.
  • Split data with text-to-columns in Excel.
  •  Sorting and Filtering data.
WEEK 3
Aggregation Functions
  • SUM, COUNT, AVERAGE, MAX, MIN, STDEV, and MEDIAN.
  • Simple Logical Functions and Comparison Operators.
  • Error Reduction via Data Validation.
  • If  functions, If AND, IF OR.
WEEK 4
Conditional Analysis
  • SUMIF, COUNTIF, SUMIFS, COUNTIFS
  • Conditional formatting 
  • VLOOKUP, XLOOKUP, INDEXMATCH
WEEK 5
MINI TEST/PROJECT
WEEK 6
TABLES and PIVOT TABLES
  • Introduction to tables and simple graphs and charts
  • Creating Tables, formatting tables, creating graphs, pie chart 
  • Introduction to Pivot tables
WEEK 7
  • Solving simple business problems using Pivot tables
  • Creation of Charts and Interpretation of these charts to derive actionable insights
WEEK 8
MAIN PROJECT
BONUS
- PLUS 3 MONTHS FREE MENTORSHIP PLAN
  • Real time simulation of daily stand up, Sprint planning, sprint review and sprint retrospective.
  • Real Time Interview Simulation
image

16

16

16

Live Sessions

image

90%

90%

90%

Certified

Please fill in your Details to get the registration steps

Student Reviews

What Our Past Students Say

The program was quite impressive and all-encompassing. The practical hands-on experience sets TrevoTech apart. My expectations for the class training were exceeded. Real kudos to the instructor.

Damilola Ogunnibosi

  • Ratings

I am glad I was part of the program. it was so impactful and I learned what I needed to excel in my career. My tutor was very patient and detailed in her explanations. 

Oyediran Blessing Dorcas

  • Ratings

The program was more than what I expected. A detailed explanation of all course modules and the instructor had enough time to explain if things were not clear to you and we were given assignments as a group helped us interact with each other properly.

I am so excited and grateful that I did this program, especially in this program.

Ezerendu Ugochukwu Jerry

  • Ratings

The program was value for money. I enjoyed every bit of the classes, this program was all that I needed to kick-start my career in Business Analysis. 

Adedeji Oluwagbeminiyi Oriyomi

  • Ratings

 I have always wished and dreamed of having Business tech skills and experience as a Business Projects Manager, Business developer, and Analyst. 

studying Business Analysis with trevotech I have gained a lot of knowledge on Business Analysis and project planning and management using some digital and technical tools like Jira. I have also gained mental theoretical and practical industrial practices experience as a Business analyst, working as a member of a team on a group project gave me the experience to work with different stakeholders.

I say a very Big thank you to Trevotech Management and all our tutors and Mentors.

 

Ehijie Jeffery Ebhodaghe

  • Ratings

Trevotech is a very beautiful academy whereby knowledge and success are their watchword.

Our tutor did a lot of teaching for us that she made sure we understood everything that was being taught the creation of groups for the project was a good way of learning whereby everyone could drop opinions and I also learned teamwork 

The classes were very interactive whereby she tended to ask questions and she made a lot of practical and real examples she broke them down for us all to understand. Business analysis is a very beautiful course to learn program is eye-opening and very informative. The program simplified the complex assumption of business analysis and how it relates to all aspects of business. I want to thank the tutor for her people management skills. I enjoyed the program and this has motivated me to pursue a career in business analysis.

Ogunwa OluwaTomisin

  • Ratings

The program is eye-opening and very informative. The program simplified the complex assumption of business analysis and how it relates to all aspects of business. I want to thank the tutor for her management skills. I enjoyed the program and this has motivated me to pursue a career in business analysis.

Oluseye Ayodeji Olusanya

  • Ratings

The program is well thought out, especially the availability of resources and the sharing of information, and the instructor made it simple by giving detailed lectures.

FRANK OBIORA ONWUEGBUNA

  • Ratings

The Program was very organized and educative. My experience was beyond my expectations.

Dr Chinyem Uzoamaka Esther

  • Ratings

My enrollment for business analysis boot camp with Trevotech is one of the best decisions I have ever made. The class was very educative and insightful. I was privileged to attend all the classes and it was indeed impactful. So much appreciation to our tutor, Miss Hope, she always ensure everyone in class is carried along, creating room for interactions and ensuring everyone understands before moving on. And also, the group class assignments helps to understand much more of everything learnt. I look forward to take more courses with Trevotech.

JOHN EBEHIREMEN UKEKE

Graduate
  • Ratings