Get certified as a Data Analyst (Excel)
Accelerate your career in data, and earn a data analysis certification teaching high-demand skills used by data analysts.
What you will learn:
Introduction: Getting to Know Excel- Understanding and working with Cell
- Understanding and working with Column
- Understanding and working with Row
- Mastering Copy Paste
- Mastering Autofill
- Intelligent navigation with Excel data
- Basic Mathematical functions
- Unlocking Keyboard Shortcuts with Master-key
- Homework: Entering 10 records in Excel
- Best Practices – Entering data in Excel
- Removing Duplicates
- Removing Spaces
- Spell check
- Replacing blank cells
- Using proper fonts
- Extracting Substring or part of data
- Merging data in cells
- Text to columns
- Data sorting
- Transpose data
- Flash fill
- Vlookup
- Hlookup
- Index and match
- Consolidate
- Append data with power query
- Manipulating dates – Date | Month | Year
- Manipulate dates – Name of The Year | Name of The Month
- Manipulating dates – Day of the week | Week of the year
- Day of the Year
- Quarter of the Year
- Dynamic TODAY | Tomorrow | Yesterday
- Calculating Age
- Adding conditional columns based on IF
- NESTED IF
- IF OR
- IF OR Multiple Column
- IF OR OR OR Practice
- IF AND
- IF AND AND AND Practice
- Freeze Panes
- Filters and advance filters
- Conditional Formatting
- Subtotals
- COUNTIF
- COUNTIFS
- SUMIF
- SUMIFS
- Introduction to Data Analysis and Data
Summary by a parameter - Adding parameters with drill down and drill up
- Breaking down information by Column
- Filtering the data in reports
- Understanding Value Field Settings
- Working with Dates in rows
- Grouping example
- Compiling data on one sheet
- Slicers
- Timeline
- Adding Calculated Fields
- Calculated Fields – Why this approach is better
- Introduction and first chart
- Exploring the chart options further
- Compiling data on one sheet
- Adding timeline (time slicer) on dashboard
- Adding and adjusting slicers
- Adding trendline charts
- Understanding Relational Data
- Adding Power Pivot to Excel
- Adding data to Data Model
- Data Modelling
- Power Pivot
Required Tools
Accelerator
Immersive practical training courses designed to take you form beginner level and help you navigate the journey to becoming a pro in your industry.
- 8 weeks training
- In-person or online
- Milestone projects
- Portfolio building
Nest
Immersive practical training courses designed to take you form beginner level and help you navigate the journey to becoming a pro in your industry.
- 8 weeks training
- In-person or online
- Milestone projects
- Portfolio building
What you will learn:
- Understanding and working with Cell
- Understanding and working with Column
- Understanding and working with Row
- Mastering Copy Paste
- Mastering Autofill
- Intelligent navigation with Excel data
- Basic Mathematical functions
- Unlocking Keyboard Shortcuts with Master-key
- Homework: Entering 10 records in Excel
- Best Practices – Entering data in Excel
- Removing Duplicates
- Removing Spaces
- Spell check
- Replacing blank cells
- Using proper fonts
- Extracting Substring or part of data
- Merging data in cells
- Text to columns
- Data sorting
- Transpose data
- Flash fill
- Vlookup
- Hlookup
- Index and match
- Consolidate
- Append data with power query
- Manipulating dates – Date | Month | Year
- Manipulate dates – Name of The Year | Name of The Month
- Manipulating dates – Day of the week | Week of the year
- Day of the Year
- Quarter of the Year
- Dynamic TODAY | Tomorrow | Yesterday
- Calculating Age
- Adding conditional columns based on IF
- NESTED IF
- IF OR
- IF OR Multiple Column
- IF OR OR OR Practice
- IF AND
- IF AND AND AND Practice
- Freeze Panes
- Filters and advance filters
- Conditional Formatting
- Subtotals
- COUNTIF
- COUNTIFS
- SUMIF
- SUMIFS
- Introduction to Data Analysis and Data
Summary by a parameter - Adding parameters with drill down and drill up
- Breaking down information by Column
- Filtering the data in reports
- Understanding Value Field Settings
- Working with Dates in rows
- Grouping example
- Compiling data on one sheet
- Slicers
- Timeline
- Adding Calculated Fields
- Calculated Fields – Why this approach is better
- Introduction and first chart
- Exploring the chart options further
- Compiling data on one sheet
- Adding timeline (time slicer) on dashboard
- Adding and adjusting slicers
- Adding trendline charts
- Understanding Relational Data
- Adding Power Pivot to Excel
- Adding data to Data Model
- Data Modelling
- Power Pivot
Required Tools
Accelerator
Immersive practical training courses designed to take you form beginner level and help you navigate the journey to becoming a pro in your industry.
- 8 weeks training
- In-person or online
- Milestone projects
- Portfolio building
Nest
Immersive practical training courses designed to take you form beginner level and help you navigate the journey to becoming a pro in your industry.
- 8 weeks training
- In-person or online
- Milestone projects
- Portfolio building
Upcoming Course Start Date
| Location | Start Date | Learning Mode | Path | Schedule | Length | Tuition Fee | Status |
|---|---|---|---|---|---|---|---|
| Ikeja | October 10,2023 | Excel | Accelerator | Weekdays or Weekends | 6 Weeks | N60,000 | Open |
| Online | October 10,2023 | Excel | Accelerator | Weekdays or Weekends | 6 Weeks | N50,000 | Open |
Upcoming Course Starts Date
| Location | Start Date | Learning Mode | Tuition Fee | Path | Schedule | Status |
|---|---|---|---|---|---|---|
| Ikeja | October 10,2023 | Excel | N60,000 | Accelerator 6 Weeks |
Weekdays or Weekends | Open |
| Online | October 10,2023 | Excel | N50,000 | Accelerator 6 Weeks |
Weekdays or Weekends | Open |
Pay As You Learn
Focus on gaining practical skills and worry less about your payments.
Passionate about a course?
We know how much you yearn to learn and advance to the next level of what the future holds for you. We have provided you with resources that makes persuading either your boss of relative easier. Take charge of your future now!
Creative and Collaborative Learning
Experience engaging and interactive sessions. At Torilo Academy training center, we leverage both group and individual sessions to ensure that our students practise working in teams and independently to build usable solutions.
Where Torilo grads. get hired
Where Torilo grads. get hired
Ready to start your Tech, Design,
Digital or Data journey?
Take the next step and speak to our admissions team. Book a 15-minute chat to ask questions and learn more about our programs.
Ready to start your Tech, Design, Digital or Data journey?
Take the next step and speak to our admissions team. Book a 15-minute chat to ask questions and learn
more about our programs.
Torilo Academy | Training Centre In Lagos, Nigeria
Out of 5 stars
Overall rating out of 100 Google reviews
Torilo Academy is one of the best Training Centres for Digital Marketing in Lagos. If you have been looking forward to taking advantage of digital space as a salesperson, Torilo Academy is the number 1 option for you; they are ever ready to train you step by step until you become competent in Digital Marketing.
Tutorials are amazing here in Torilo Academy
best IT firm ever ! very resourceful and professional
The product design course at Torilo academy exceeded my expectations! The instructors’ expertise and hands-on approach have truly elevated my design skills. Highly recommended!”
Best IT’s Academy have ever seen, courses are thought in the most simplest way you could ever imagine.
Good and concise teaching methods. Was a pleasant experience.
It's my first day, and I'm already loving the atmosphere and tutors. All smiling and jovial. You need to give them a chance, Torilo academy .
The training was awesome. The six week experience was as if the terminating day for the Digital Marketing class should not come. Torilo Academy is a top-notched training centre to get the best in this digital age
Torilo Academy is definitely your go to place for digital marketing. Within a space of 6 weeks, I was able to learn a lot about digital marketing. Teaching environment is very comfortable and the tutors are friendly.
Are you looking for a place to learn digital marketing, look no further. Torilo Academy is all you need, instructors are friendly, learning environment is conducive and they go all out with every little details. A big shout out to my instructor, Mr Peter Adetutu, you are awesome.
Had a great and impactful time at Torilo. They are very professional, from my first enquire via phone call with the contact person Ayo to the facilitator Sam (awesome guy) always ready to listen and provide solution. It was worth every penny.
Torilo Academy is an excellent training institution for design courses. My time spent learning web design was worth it. Professional facilitators and conducive learning environment.
Words cant express the joy and fulfillment in my heart right now. Thanks to Torilo Academy my long time wish to have deep knowledge of digital marketing is accomplished. With very conducive learning environment, great instructors.....Torilo Academy is truly a place to be
Torilo academy is the best place to learn digital marketing skills because they provide a conducive and comfortable learning environment, Mr. Peter Adetutu(digital marketing) is the best tutor I’ve come across and I’m extremely grateful to him. Learn digital skills at torilo academy and get that top notch quality learning .
The experience was a very great one. The teaching experience surpassed my expectations, well paced and thorough. I would advice/refer anyone to study at Torilo Academy.
In all sincerity it was a nice experience for me. My teacher always took his time to explain whatever i didn't understand and also made corrections to my work. Torilo Academy is a place and learn.
Torilo Academy is a very good place to be. I Enjoyed every bit of the classes, both in Digital marketing and Graphics Design. God Bless Torilo.....
