
MICROSOFT EXCEL APPLICATION WORKSHOP (ADVANCED LEVEL)
CLASSROOM FEE: ₦140,000 | ONLINE FEE: ₦110,000
SYNOPSIS: Microsoft Excel is one of the most powerful software used for analyzing data to make a better decision. It helps in data organizing, data analyzing, and data interpretation. Utilizing Microsoft Excel for inventory tracking is an easy way to cut costs, save time, and organize inventory. This course will take participants through intermediary and advanced excel tutorials, they will understand how Excel work. They will learn complex functions, nesting, data manipulation and automation using basic macros in excel. They will further be taken through tutorials on how to use excel for inventory management. The course is for both intermediate and advanced excel and its dynamic application.
COURSE OBJECTIVES
At the end of the program, participants will be able to:
- Use Logical Functions, Financial and Statistical Functions
- Use Nest Functions
- Use Multiple Worksheet Management and Formulae
- Create Charts, Use What-If Tools
- Protect Worksheets & Workbooks
- Use Lookup & Informational Functions
- Create simple Inventory system with Excel Template
- Create and manage an inventory system with excel spreadsheet
COURSE OUTLINE
Data analytics Excel Philosophy,
- Excel interface, Excel shortcut keys
- Naming & Date Function and Logical Test, Text to column
- Cell referencing,
- Conditional Function and Formatting,
- Count if, Average if and Sum if
Advanced Formula V & H Lookup and its application to data analysis
- Concatenation and Rept function
- Data Consolidation,
- Linking worksheet, workbook together, hyperlink
- Match and index function,
- Pivot Table and its dynamic application
- Introduction to macro
Introduction to Excel Dashboard Reporting
- Expected to be covered are:
- Combo chart,
- water flow chart,
- option tab, list box,
- Gant chart,
- Side by side comparism among others.
Case Study/Class Assignment for hands on practical examples and exercises.
WHO SHOULD ATTEND? Office Managers and Administrators, Supervisors, Office Clerks, Secretaries, Accountants, Cashiers and anyone wanting to up skill