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.
No knowledge of computer and/or IT is required to attend this program.
Duration: 36 hours over eight (4) weeks. Three (3) hours daily Mondays,Wednesday Fridays.
Morning : 9am. - 12p.m.
Afternoon : 2p.m. - 5p.m.
Evening : 6pm. - 8:30p.m.
The courses that are covered in this program include:
Using logical functions
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
Pivot Tables and Pivot Charts
Using the PivotTable Wizard
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
" I love how they train,the tutor is friendly,he makes sure you understand what he is teaching.I am very grateful, GoldTech ICT HUB is the best Computer training institute ever.GoldTech ICT HUB you are the best! "
"GoldTech ICT HUB 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 "
"The instructor was very focused and always ready to impact knowledge, GoldTech ICT HUB is a lovely place. "
"GoldTech ICT HUB 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"
" 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 "
" 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! "
" 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. "
" 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 "
" 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 "
" It was awesome being in GoldTech ICT HUB, the tutor was competent, the students were friendly, the environment was convenient. In fact it was a wonderful experience. "
" 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. "
"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 "
" GoldTech ICT HUB is a computer institute that helps students to really know what computer is all about with both theory and practical aspect. "
" 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 "
"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."
"My time in GoldTech ICT HUB has been well spent from our instructors to the environment, everything was well coordinated"
"Honestly, it was a very good experience, I learnt a lot of things, concerning information technology, good instructor, conducive environment for learning"
Course Fee: #45 000.00 Forty-five Thousand Naira Only.
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: 1020968783
Account Name: Goldtech Ict hub ltd
Full Payment (Attracts 5% discount of Course Fee)
Installmental Payments (First Payment= 60% of Course Fee)
Who is this course for?
Job Seekers or anyone that is required to work with computers on a day-to-day basis.
Choose from the large selection pre-made blocks - full-screen intro, bootstrap carousel, slider, responsive image gallery with, parallax scrolling, sticky header and more.