UNLEASHING YOUR MS EXCEL SKILLS
MS Excel is a worksheet program developed by Microsoft. It’s a versatile tool used for Data organization, Data Analysis, Data Visualization, Financial modeling and Database Management. Employees with these skills becomes a vital asset for the company’s growth and development. This course provides participants with essential and advanced skills for managing large data and manipulating it to get the desired outcome.
Course Content
This training covers all the needed requirements to be equipped with MS Excel including building and naming cells, entering data, organizing information, making analysis and computing calculations. Participants will explore methods of analyzing data and make meaningful implementations.
Course Objectives
At the end of this, participants would be able to:
Perform Basic Operations in Excel, Such as Entries and Formatting
Utilize Functions and Formulas In Cells.
Develop Pivot Tables
Create Charts Using Excel
Sort and Filter Data Using Excel
Effectively Use Advanced Functions Such as VLOOKUP, IF Functions
Explore Data Validation in Excel.
Create Interactive Excel Dashboards
Benefits of Programs
2 days of hands-on and tailor-made training
Scenario-based interactive sessions
Training Materials (i.e.) PowerPoint presentation, manuals, sample activity templates, case studies, scenarios, videos, references, etc
Post-Module Assignments and Written Action Plan to take away.
Official MGA Consulting Certificate of Completion
Who is the Program Intended For?
This course is designed for Administrators, Account Officers/Managers, Operations Managers and Staff Whose Work Involves Data Analysis and Report Writing.