Advanced Excel Training

Nairobi CBD, Nairobi Added at 09:14, 17 October 2017, Ad ID: 1000729001

Offer from Individual
 

MS Excel is the most used spreadsheet application. Learning how to use MS Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, analyse vast amounts of data, etc.

Become an EXPERT in MS Excel NOW! Learn the expert features of MS Excel NOW.

This will get you beyond the basics to more advanced-level proficiency within the Excel suite.

Topics Covered:

MODULE 1: Grouping & Outlining and Subtotals
• Outlining and Grouping Data
• Using the Subtotals Tool

MODULE 2: What-If Analysis
• Exploring Scenarios
• Goal Seek and Data Tables
• Using Solver

MODULE 3: PivotTables
• Getting Started with PivotTables
• Displaying Data in a PivotTable
• Formatting a PivotTable
• Using the Classic PivotTable Layout
• Slicers

MODULE 4: Charting Pivoted Data
• Getting Started with PivotCharts
• Using the PivotChart Tools Tabs
• Formatting a PivotChart

MODULE 5: Advanced Excel Tasks
• Excel and Hyperlinks
• Using Custom AutoFill Lists
• Sharing Workbooks

MODULE 6: Creating HLOOKUP and VLOOKUP Functions
• Using the VLOOKUP Function
• Using the LOOKUP Function

MODULE 7: Introduction to Macros in Excel
• Recording and Playing Macros
• Copying and Deleting Macros
• Visual Basic and Macros

MODULE 8: Excel Intermediate
• Advanced File Tasks
• Working with Functions and Formulas
• Managing Tables in Microsoft Excel
• Data Tools in Excel
• Doing More with Charts in Excel
• Sparklines

MODULE 9: Excel Professional
• Advanced Conditional Formatting
• Using Form Controls and Templates
• Advanced Lookup Functions
• Advanced Functions in Excel
• Advanced Pivot Table Tools
• Introduction to User Defined Functions Using VBA

MODULE 10: Excel Dashboards
• Introduction to Dashboards
• Inserting Graphics for a Dashboard
• Specialist Functions and Formulas
• Dashboard Navigation
• Preparing your Workbook's Layout and Structure
• Using Excel Objects for Specialist Dashboard Views
• Using Macros and VBA with Dashboards

MODULE 11: Excel VBA Introduction
• Recording and Running Macros in Excel
• Introduction to the Excel VBA Editor
• Creating Procedures and Functions
• Working with the Excel Object Model
• Controlling Program Flow

MODULE 12: Excel VBA Advanced
• Advanced Procedures
• Advanced Variables
• Interacting with Office Applications
• Debugging and Error Traps
• Creating Custom User Forms
• Workbook and Worksheet Events

MODULE 13: Excel Business Intelligence (BI)
• Importing and Linking Data
• Data Manipulation with Pivot Tables
• Advanced Reporting Functions
• Automating Reports with Controls
• Advanced Charting Features

****We can customize the training to fit your needs.

Call Peter NOW and start your journey to ABSOLUTE SKILLS!

Advanced Excel Training Nairobi CBD - image 2
Advanced Excel Training Nairobi CBD - image 3
Advanced Excel Training Nairobi CBD - image 4
 Share via Email
Views:38

Contact advertiser

All Ads of this user

User Ads Peter

Internal Hard Disk - 120GB

Internal Hard Disk - 120GB

Computers & Laptops

17 Oct

KSh 1,500

Negotiable
Refab Computers and Laptops 20K

Refab Computers and Laptops 20K

Computers & Laptops

17 Oct

KSh 20,000

Negotiable
Mobile Phone Accessories

Mobile Phone Accessories

Accessories

17 Oct

KSh 999

Negotiable
Professional Web Design, Domain Names and Hosting
Show other Ads of this user
Send message
Nairobi CBD, Nairobi Show on the map

Peter On site since Nov 2013 See their other ads

  • Mark as Favourite
  • Print
  • Edit
  • Report