We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Advanced Microsoft Excel for Sales Professionals

ENDED
Inquire Now
On-Site / Training

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

Course Content
  • 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

15% Discount applicable on registration 2 weeks before the date.
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
Reviews
Be the first to write a review about this course.
Write a Review

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.

 

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.