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.

INTERMEDIATE 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:

This course is designed to build on the Intermediate Excel course. It focuses on more functions and formulae and better Excel worksheet management, Data List Handling and working with names also included is charting your data in Excel.

Excel Intermediate Training Course Contents

1. Recap

  • Absolute references
  • Basic function creation methods
  • Formulae
  • Data entry and formatting
  • Date, Text, Number principles

2. Range Names

  • Concept and Purpose
  • Naming individual or range cells
  • Deleting and amending named ranges
  • Using named cells/ranges in formulae
  • Create Named Ranges and Cells
  • Manage Names (Setting Scope, Deleting, Renaming)
  • Navigate Named Ranges
  • Use names to Calculate
  • Use ranges in Functions
  • Paste Names
  • Filter Names

3. Formula Auditing Tools

  • Revealing Formulae
  • Tracing Precedents/Dependents
  • GoTo Special
  • 3D Calculations
  • Linking sheets in the same file
  • Linking different Excel files
  • Using Edit, Links
  • Viewing different files at once
  • Saving a workspace
  • Viewing different sheets at once
  • Window Split
  • Data consolidation

4. Conditional Functions & Formats and Date Calculations

  • Work with Styles.
  • Use If Statements, Nested If.
  • Use And, Or, Not.
  • Nesting If, And, Or, Not.
  • Use the Sumif , Countif, Averageif.
  • Use the Sumifs, Countifs, Averageifs.
  • Use the Iserror, Iferror functions.
  • Apply Conditional Formatting.
  • Date Calculations.
  • Calculate working days.
  • Use the DAY(),MONTH(),YEAR() functions.
  • Create and use Time calculations.

5. Formulae Auditing

  • Use the Formula Auditing Tools.
  • Reveal Formulae (in a cell).
  • Trace Precedents/Dependents.
  • Setting a Watch.
  • GoTo Special.

6. Worksheet Management & Linking

  • Link sheets in the same workbook.
  • Link cells in different Excel files.
  • Manage and edit Links.
  • View different files at same time.
  • Saving a workspace.
  • View different sheets at same time.
  • Data consolidation (within same file).
  • Data consolidation (across workbooks).

7. Data List Management

  • Create an Excel data list.
  • Use the Excel List Tools.
  • Use Autofilter.
  • Sort the Data.
  • Use the Advanced Filter.
  • Add Subtotals to a list.
  • Apply Data Validation to keep data clean.
  • Group and Outline your data.
  • Use the Data Form.

8. Excel Charts/Graphs

  • Create a Chart with keyboard.
  • Use the Chart Wizard.
  • Edit and Format a chart.
  • Change the Chart source Data.
  • Apply Trendlines.
  • Use Sparklines.
  • Change Charts from objects to sheets.
  • Add labels and axes to chart.
  • Show specific Data Points.
  • Save custom chart types.
  • Change the default chart type.
  • Using the Chart Wizard.
  • Editing and Formatting charts.
  • Saving custom chart types.
  • Setting a default chart type.

Our Training Courses