Advanced Microsoft Excel for Sales Professionals
Details
Course Overview
Some skills have become important for personal effectiveness and business process efficiency – Microsoft Excel stands out as one of them.
This course offers the needs of a sales professional to optimize their efficiency, productivity and accuracy with Microsoft Excel. From the basic use to the complex modelling application, there is knowledge and productivity to be gained. It is a 2-day instructor-led course that provides participants with the necessary knowledge and skill to create and manage spreadsheets. Training will be facilitated by experienced, qualified and tested Microsoft Office Trainers.
Learning Outcomes
Upon successful completion of this course students will be able to demonstrate and efficiently use the following:
- Demonstrate working knowledge of MS Excel advanced formatting techniques and presentation styles.
- Automate recurring processes
- Use the most powerful features of Excel
- Know which features and functions should be used for various high-level tasks
- Use Charts and Other graphics to present data
- Collate, organize and analyze data
- Improve efficiency in the use of Excel at work
Mode of Delivery
Instructor-led hands-on practical demonstration and learning. Each participant is expected to work individually on a computer
Outline
- Introduction to Excel Advanced
- Using Text to Columns
- The Paste Special Function
- Data Validation
- Subtotals and Grouping
- Consolidating Data
- Scenario Analysis
- Data Tables in Scenario Analysis
- What-if Analysis
- Mats and Trig Functions
- Text Functions in Excel
- Using Lookup Functions
- V-Lookups
- H-Lookups
- Using Statistical Functions
- Database Functions
- Formula Auditing and Error Tracing
- Hyperlinks in Excel
- Linking Data
- Understanding Pivot Tables
- Using Pivot Charts
- Workbook Properties
- Protecting and Sharing Worksheets
- Data Encrypting and Finalising Workbooks
- Understanding & Using Macros
- Custom Number Formats in Excel
- Using Custom Lists
- Working with Templates
- Tracking Changes in Excel
- Merging and Comparing Excel Workbooks
- Dashboards, Form Control & Power View
- PowerPivot -Intro
Special Offer
20% Discount applicable on registration of a minimum of 4 participants.
Both offers are mutually exclusive
The course fee covers tuition, course materials, certificate and meals
Autusbridge Consulting Ltd is a leading training provider in Nigeria. We offer training programs in Sales, Marketing, Business Management, Microsoft Office tools and Data Analytics, Leadership, Finance and Financial Modelling Courses. We are an authorised training partner to the Institute of Sales Management, UK and Cambridge Professional Academy, UK; for the provision of Sales, Marketing and Business Operations certifications in Nigeria. Our certification programs are globally recognised for professional practice and career growth.
Our fast-growing clientele cuts across multinationals/blue chips, MSMEs and SMEs, governments and not-for-profit organisations. Our highly professional, technology-enhanced and industry-focused training contents and delivery methodology give us greater advantage amongst our peers. We have a rich faculty of training facilitators with relevant training and hands-on background from academia and professional practice.