MS EXCEL FOR BUSINESS & OFFICE PROFESSIONALS

INVITES YOU TO OUR ADVANCED MS EXCEL FOR BUSINESS & OFFICE PROFESSIONALS CLASS

INTRODUCTION
This hands-on training course has been specifically designed to assist you in simplifying and speeding up the task you perform with MS Excel every day.

In this class, you will discover how to refine and improve the spreadsheet that you work with to get the most out of MS Excel and save loads of time. We will show, step-by-step, some practical ways to work with spreadsheets, sort and validate data, take control of your work quality by learning how to create your own template, toolbars and styles. Become a whiz with auto-filling, auto-summing and other time-saving functions.

Take this opportunity to learn easy ways to create and automate spreadsheets - which will save you time while increasing the quality and usability of the information you are preparing. This will also result in you being able to source and provide key information for yourself and your manager.

WHO SHOULD ATTEND?
This training is recommended for anyone with basic knowledge of Microsoft Excel and everyone who wishes to enhance their skills in spreadsheet management.

EXPECTED OUTCOME: 

• Use advanced filters, VLOOKUP, Pivot Tables, Data manipulation and searching
• Design Excel-based templates and make an impressive and powerful presentation of reports
• Validate data captured to be sure of authenticity and accuracy for reliable output/information
• Plot a graph that changes its bars dynamically using tools like a slicer, sparkline, pivot chart etc.
• Use Excel macros to convert figures to words, automatically print a continuous report at a particular time and interval
• Set indicators (amber light, yellow light and red light) to prompt you about expiring periods (staff confirmation dates; leave resumption dates; re-order level; bill renewal due date etc.)
• Drive departmental performance using the KPI Command using conditional formatting in excel
• Preview and print documents, adjust margins and create headers
• Manage and control project deadlines using Advanced Excel Functions
• Transform business data into meaningful dashboards and dynamic charts
• Perform advanced calculations on Excel

COURSE CONTENT

SESSION 1:

• Creating and Working with Templates
• Creating and Working with Pivot Tables
• Creating and Working with Pivot Charts
• Using Logical Functions (IF, OR, AND, NOT, etc.
• Using Date and Time Functions
• Using Array Formulas
• Displaying and Printing Formulas
• Using Lookup Functions (VLOOKUP & HLOOKUP)
• Using MATCH and INDEX Creating Data Tables
• Creating a Dashboard with Pivot Charts
• Changing the Pivot table layout
• Formatting
• Producing reports
• Manipulating query headings
• Grouping and ungrouping data fields

SESSION 2:

• Adjusting Scale of Charts
• Formatting Data Points
• Creating Combination Charts
• Creating Trendlines
• Inserting Sparklines
• Adding and Formatting Graphical Elements
• Adding and Viewing Comments in Cells and Workbooks
• Protecting Worksheets with Passwords
• Protecting Worksheet Structure
• Sharing, Merging and Tracking Changes in Workbooks
• Understanding Data Quality issues
• Gathering data from different sources
• Linking Data
• Merging and Consolidating Data
• Excel Hints and Tips when working with data
   

TRAINING DETAILS

Duration: 1 Day
Date: January 27, 2019
Time: 9:00am – 4:00pm
Venue: CHEMLINE EXECUTIVE TRAINING HALL, Plot C, Obasa Avenue, Behind AP Filling Station, Off Oba- Akran, Ikeja, Lagos
Fee: N45,000

Please note that the training fee covers refreshments, certificates, writing pads, e-manuals and other training materials

HOW DO I REGISTER FOR THIS TRAINING?

Kindly send the details of your company nominees or your details to bomosaku@gmail.com.

 Payment can be made to BARBADOS SOLUTIONS, GTB Account Number 0159819628