Fundamentals of Microsoft Excel (Beginners and Intermediate)

One of the most paramount and most sought-after skills of the 21st century is the Excel skills. The versatility or proficiency of an individual in the use of Microsoft office packages, especially Microsoft Excel has been attracting awesome rewards in the workplace. The use of Excel cut-cross all professionals because the world has migrated to the era of efficient presentation and storage of data for easy retrieval. Thus, Ms. Excel skills are highly imperative for all and sundry.

Ms. Excel training course that will take you through the beginners’ and intermediate levels in Ms. Excel with practical sessions that are learner-centered and applicable to real-life scenarios. Participants will learn how to create spreadsheets in Excel, format and print workbooks, navigate the Excel user interface, create basic calculation formulas and commands, clear, sort and filter data, visualize data and draw charts.

Learning Objectives

• Navigate the Excel user interface that is using the appropriate tools on the toolbars and ribbon.
• Create a basic workbook and spreadsheet on Excel.
• Understand how to import functions/formulas, duplicate data, lock functions, and apply functions to a given set of data on both column and roll.
• Apply basic Excel functions and commands while working with data.
• Summarize data with Excel by infusing formulas, formatting, and charts and graphs.
• Optimize your worksheets using templates, graphs, and charts.
• Use the sort and filter tools in Excel to arrange and clear data in an easy-to-use manner. 
• Present data with accurate and better interpretation
• Handle excel situations confidently 
• Have high comfort working with Excel which will lead to high turnaround time. 
• Use the right formulas in the right scenarios.

Target Participants
This course will be of immense benefits to the following: 

• Managers and supervisors
• Beginners and intermediate Officers
• Support Business Units to Logistics: HR, Finance, 
• Sales and Marketing
• Business Owner
• Any other professional who would like to know more about Microsoft PowerPoint and excel.

Course Outline

Module 1: Customizing Excel

Module 2: Navigating/Formatting A Worksheet

Module 3: Analysing Data

Module 4: Mathematical Functions

Module 5: Printing And Filtering