Phone +234.811-111-1296 or visit www.charlesandgoldconsulting.com

Empower yourself to expand your role and opportunities. Achieve real and quantifiable returns by building a high level of interpersonal, planning and problem solving skills.

ADVANCED EXCEL TRAINING COURSE

Duration: 3 Days

Lagos Venue

106 Apapa Road beside
Zenith Bank Lagos.

Fee: N75, 000. VAT Incl.

4 - 5 participants: 5% discount
More than 6 ppl: 10% discount

Class Session

9:00am – 4:00pm daily.
(In plant training available upon request)
WEEKEND CLASSES May Sat 7 & 14, Sun 8 July Sat 2 & 9, Sun 3 Sept Sat 3 & 10, Sun 4
WEEKDAY CLASSES March Tue 1 - Thur 3 June Wed 1 - Fri 3 Oct. Wed 5 - 7


Share this course

Twitter Feeds

Course Overview:

To build on previous knowledge and explore advanced functionality within Excel, finishing with an introduction to Macros.

Course Duration

This is 3 - days Excel Advanced Course. Course starts at 09:00 and runs until 16:00

Course Locations/Schedule

This course can be run Onsite, or at our Excel training centre or any preferred location in Nigeria. The course is run on a date that suits you! We do not run public scheduled courses.

Excel Advanced Training Course Contents

Lookup & Information Functions

  • Build the Vertical Lookup (Vlookup) function
  • Build the Horizontal Lookup (Hlookup) function
  • Build the Match and Index functions
  • Build the IsText, IsValue, IsDate , IsNull , IsErr, IsNa functions
  • Build and use Database Functions

Pivot Tables

  • Create A PivotTable
  • Change the PivotTable layout
  • Manipulate PivotTable fields
  • Format the PivotTable and apply Styles
  • Use Banding (Formatting)
  • Group & Ungroup items
  • Filter data in the PivotTable
  • Insert calculated fields
  • Change calculation options
  • Change PivotTable Options
  • Display and hide data in fields
  • Lay out reports on worksheet
  • Create a PivotChart from report
  • Manipulate PivotChart fields
  • Use Slicers

What If Analysis

  • Create and manipulate Scenarios
  • Create and change Custom Views
  • Build scenario Reports
  • Use the Goal Seek tool
  • Use Solver & Advanced Solver Features
  • Build Data Tables

Protecting & Sharing Files

  • Share a file
  • Track changes
  • Accept or reject changes
  • View Change history
  • Apply Data validation rules
  • Insert, edit and delete comments

Introduction to Macros

  • Review the purpose of Macros
  • Record a macro
  • Save a macro
  • Edit a Macro
  • Absolute and relative records

Running macros:

  • Apply macro to Custom buttons on the Ribbon or Quick Access toolbar, keyboard shortcuts.

Customising Excel

  • Customise the Quick Access Toolbar and Ribbons
  • Set Workbook options
  • Change workbook defaults

Templates

  • View Template Types
  • Use Normal Template
  • Open Sample Templates
  • Create Custom Templates
  • Use Custom and online Templates
  • Open And Edit Templates
  • Setting Template Properties

Objects In Excel

  • Insert, Format And Delete Objects
  • Insert A Drawing Object
  • Use the design ribbon
  • Use SmartArt
  • Apply Formatting to SmartArt
  • Use QuickStyles
  • Explore 2D And 3D Formatting
  • Insert and use WordArt
  • Insert and Format Shapes
  • More on Themes and styles
  • Manually Format an object
  • Customise or create A Theme

Frequently Asked Question (FAQ's) On Excel Training

What equipment / facilities do we need for an Onsite Course?

The only requirement is that you have a room big enough to comfortably accommodate the delegates. If you have your own IT training room, that's great. If not, we can even provide laptops, projectors and flip charts. Our standard laptop hire charges may apply.

How do I book Onsite Training?

Charles and Gold Consulting Training has the simplest onsite training booking procedures. You simply contact us (info@charlesandgoldconsulting.com) with your request. We will then reach you to agree on a date, location, course and level with you. Done!

How soon can we arrange Onsite Training?

We do not run a schedule of dates. You dictate the days or time/ period in which you would like to run your onsite training course.

How much does Onsite Training cost?

Your onsite IT training course will be charged at our standard rates, which is £700 or N500, 000 per group up to 10 delegates. If your course is outside Lagos, then travel cost and a hotel cost may apply. We always agree these costs with you prior to the course, so no nasty surprises when you get your invoice! All costs exclude VAT.

Can our Onsite Training be tailored?

Of course! This is what makes us different from other training companies. We even provide a free Training Needs Analysis (TNA) to establish your current and required level of onsite training. All of this at no extra charge!

Our Training Courses