STARTS: 11th of January
ENDS: 12th of February
TIME: 10am – 12pm
SCHEDULE: Tue, Thur
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.
Who Should Attend?
Intermediate Excel Users
Freshers seeking jobs in Analytics/Consulting job streams
|Recording: Intro to Advanced Excel Recording 13 Jan, 2021 Details||02:00:00|
|Recording: Advance Excel Recording_Logical Functions 1_14-Jan-2021 Details||00:18:00|
|Recording: Advance Excel Recording_Logical Functions2_14-Jan-2021 Details||02:00:00|
|Recording: Advanced Excel Class Video Recording Database Functions 21 Jan, 2021 Details||02:00:00|
|Learning to work with Logical Functions|
|Learning to work with LOOKUP and database formula|
|Learning to work with Range Name and Drop Down List|
|Learning how to work with Pivot table and charts|
|Learning how to work with Scenarios and Macros|
|What can HOT do better? Details||00:00:00|
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
No Reviews found for this course.