- Start Date: 30th October 2023
- End Date: 24th November 2023
- Time: 10am – 12pm (WAT)
- Schedule: Tuesdays, Thursdays
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.
Who Should Attend?
Intermediate Excel Users
Freshers seeking jobs in Analytics/Consulting job streams
COURSES OBJECTIVES After the completion of the Microsoft Excel Course, you would have learnt the following: Learn to use formulas and functions. Create and modify charts. Convert, sort, filter, and manage lists. Insert and modify illustrations in a worksheet. Learn to work with tables. Learn to use conditional formatting and styles Create pivot tables and charts Learn to trace precedents and dependents Convert text and validate and consolidate data Collaborate with others by protecting worksheets and workbooks Create, use, edit, and manage macros Import and export data TRAINING FEATURES
- Instructor-led Live Sessions
- Real-life Case Studies
- 24 x 7 Expert Support
- Internationally Recognised Certificate
Operating System: Windows 7 or higher, Mac OS. Processor: 1 gigahertz (GHz) or faster processor or SoC RAM: 1 gigabyte (GB) for 32-bit or 2 GB for 64-bit Hard disk space: 16 GB for 32-bit OS or 20 GB for 64-bit OS Graphics card: DirectX 9 or later with WDDM 1.0 driver Display: 800 x 600
Do I receive a certificate after completing the Course? Yes, you receive an internationally recognized certificate after the course.