Advanced Microsoft Excel
Advanced Microsoft Excel is much more than a quick way to add up numbers. In this course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This course also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.
Pre-requisite:
No knowledge of computer and/or IT is required to attend this program.
The courses that are covered in this program include:
- Using logical functions
- Naming ranges
- Creating named ranges
- Using named ranges in formulas
- The IF function (recap)
- Creating nested IF functions
- AND and OR functions
- Combining logical functions
- Working with lookups
- The VLOOKUP function
- The HLOOKUP function
- Advanced list management
- Using data validation
- Setting criteria for entry of text, values and dates
- Creating a dropdown list
- Using database functions
- Setting up criteria
- DSUM
- DAVERAGE
- DCOUNT
- Pivot Tables and Pivot Charts
- Using the PivotTable Wizard
- Rearranging PivotTables
- Using the PivotTable toolbar
- Creating Pivot Charts
- Using Slicers to manipulate PivotTables
- Using analytical options
- Using Goal Seek
- Using the Solver add-in
- Working with scenarios
- Creating and saving scenarios
- Viewing scenarios
- Macros
- Business analysts
- Administrative assistants
- Marketing managers
- Project managers
- Accountants
- Financial analysts
- Job Seekers or anyone that is required to work with computers on a day-to-day basis.
Duration: 4 weeks
Interested individuals can pay using the following methods:
Pay at the centre of your choice
Pay to the bank using the following bank details
Account Number: 2011745387
Account Name: HiiT Plc
Bank: First Bank
Full Payment (Attracts 5% discount of Course Fee)
Installmental Payments (First Payment= 60% of Course Fee)
| Location | Price |
| Lagos | ₦30,000 |
HiiT plc is a great place to be because the staffs are very social,hospitable and down to earth and our teacher was a great person to be around because he tries as much as possible to explain to the least possible detail for easy understanding,He was very good.
-NCHOR Barthelomeow Ojong
I love how they train,the tutor is friendly,he makes sure you understand what he is teaching.I am very grateful,HiiT is the best Computer training institute ever.HiiT you are the best!
-ADEDARE Adeshola
HiiT is a good organisation with well cultured workers and a very clean environment. I am impressed with the certificate in digital literacy program, the teacher was nice, he was always ready to impact knowledge irrespective of any challenges.Thanks to all,It was a pleasure all through my days.
-Augustine Edidiong Blessing
The instructor was very focused and always ready to impact knowledge, HiiT Plc is a lovely place.
-Muyiwa Alimotu
The training was cool and we had a nice teacher who is always ready to for us, i loved the class and i am going to tell my friends at home to come for the training.
-Ajibola Ademola
The training i underwent was very interesting and i learnt alot from the teachers/instructors because they made sure we understood everything we being taught,I will also want to use this opportunity to thank the staffs and everyone for their love and also for them to keep up the good work!
-UKAWOKO Ngozichukwu Blessing
This training was very nice and conducive and i am so glad on how we were being treated in this training centre. More power to your elbows.
– ANIOKO Francisca
Infact am so happy with this computer program, Why? because i can now operate computers and i can do alot in the office without any problems I give thanks to the management for their understanding and cooperation.
-LEKPARA Obi
The training conducted on certificate in digital literacy was quite okay and well delivered courtesy of the qualified and dedicated instructors in the institute. Based on this i recommend it to all and sundry.
-UBA Philips NYEBUK
It was awesome being in Hiit, the tutor was competent, the students were friendly, the environment was convenient. In fact it was a wonderful experience.
-Udoette Mary Cyril
The training was very comprehensive, impactful and friendly. I will return again for further training in other areas if time and resources permit. I am more than impressed.
-Odeyemi Abiola.O
The teaching has been excellent and top class, the environment is conducive for learning and I don’t have any problems with the institution.” Keep it up”.
-Kukoyi Oluwatobi Anthony
Hiit is a computer institute that helps students to really know what computer is all about with both theory and practical aspect.
-Martino Tayo Oluwatoyin
The program was great one, it helped me to develop more skills about computer and how to be useful and friendly with the system. Thanks to those involved
-Akeju Oluwakemi
Well, the training went smoothly without incident. The teaching was top class as usual and the environment was very accommodating and conducive for learning. I am happy that I came to study here, I have gained a lot, keep up the good work.
-Kuroyi Oluwatobi
My time in Hiit has been well spent from our instructors to the environment, everything was well coordinated.
-Farounbi Blessing
Honestly, it was a very good experience, I learnt a lot of things, concerning information technology, good instructor, conducive environment for learning.
-Afolabi Olaoluwa
[/su_note] [/su_animate]
My expectations were met in the just concluded training and my instructor helped me achieve my aims of coming for the training.
-Sanni Damilola Taiwo
They taught us in a good way for easy assimilation.
-Adebowale Sunday Ayomide
I am amazed,I thought i would be rushed without learning to understand but the time spent in each class was great.All i can say is that i am satisfied.
-OSHO ADEDOTUN ISIAH