c2
Connect on:
  • Home
  • Course Centre
    • Project Management >
      • Professional Project Management
      • Project Management Essentials
      • Managing Project Requirements
      • Scheduling & Cost Control Project Managers
      • Project Leadership, Management & Communication
      • Risk Management for Project Managers
      • Negotiation Skills for Project Managers
      • Managing Remote Project Teams
      • Project Quality Management
      • Project Procurement Management
      • Earned Value Management
      • Professional Project Management - Best Practice
      • Professional Project Management - Exam Preparation
      • PRINCE2® Foundation & Practitioner
      • PRINCE2® Overview
    • Agile Project Management Courses >
      • Agile Project Management
      • Using Scrum in organistations
      • Certified ScrumMaster
    • Java >
      • Core Java Programming
      • Advanced Java Programming
      • Java Programming & XML
      • Java Networking
      • Java Virtual Machine (JVM)
      • Java & Java EE Open Source Testing Tools
    • Java Enterprise Edition (EE) >
      • Enterprise Java with Hibernate and Spring
      • Developing Java Web Applications
      • Java & Java EE Open Source Testing Tools
      • Spring Framework Development
    • C/C++ Programming >
      • C Programming Techniques
      • C++ Programming Fundamentals
      • C++ for C Programmers
      • Advanced C++ Programming
      • C++ & STL Design Patterns
      • Object Oriented C++ for Real-time Applications
    • Unix/Linux >
      • Linux Fundamentals
      • Linux Administration Essentials
    • Windows Server Courses >
      • Installing and Configuring Windows Server 2012
      • Windows Server 2008 - Server Administration
      • Configuring Windows Server 2008 Active Directory
    • .NET Courses >
      • ASP.NET MVC 4.0
    • Perl Programming Courses >
      • Perl Programming
      • Advanced Perl Programming
    • Python Programming Courses >
      • Python Programming
    • Database Courses >
      • MySQL for Developers
    • CompTIA >
      • CompTIA Network+
    • Scripting >
      • JavaScript - Introduction
      • JavaScript - Advanced
    • Data Analysis & Design >
      • Data Analysis & Design - Introduction
      • Data Analysis & Design with UML
    • Microsoft Office Courses >
      • Microsoft Word - Introduction
      • Microsoft Word - Intermediate
      • Microsoft Word - Advanced
      • Microsoft Access - Introduction
      • Microsoft Access - Intermediate
      • Microsoft Access - Advanced
      • Microsoft Excel - Introduction
      • Microsoft Excel - Intermediate
      • Microsoft Excel - Advanced
      • Microsoft Excel - Dashboards
      • Microsoft Excel - Macros
      • Microsoft Excel - Expert
      • Microsoft PowerPoint - Level 1
      • Microsoft PowerPoint - Level 2
      • Microsoft PowerPoint - Advanced
      • Microsoft Outlook - Introduction
      • Microsoft Outlook - To Manage Your Time Efficiently
      • Microsoft Project - Introduction
      • Microsoft Project - Advanced
      • Microsoft Publisher - Introduction
      • Microsoft Visio - Introduction
    • Solaris >
      • Solaris 10 Administration
  • Testimonials
  • About
  • Contact

Microsoft Excel - Expert

Course Description

This is a Microsoft Excel Expert course.  The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending.  For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.

Course Duration

1 day

Course Objectives

On completion, candidates should be equipped with the necessary skills to create Pivot Tables, produce complex nested functions, create array functions and record and edit macros.

Course Content

ANALYZING DATA WITH PIVOTTABLES
Building PivotTables
Building a PivotTable from a Table or Range
Working with and Customizing a PivotTable
Working with PivotTable Subtotals
Customizing the Subtotal Calculation
Changing the Data Field Summary Calculation
Using Summary Calculations
Creating a Calculated Field
Using PivotTable Results in a Worksheet Formula

NESTED FUNCTIONS
Nesting IF statements
Nesting AND and OR with IF statements
Nesting IFERROR with VLOOKUP functions
Nesting MATCH with VLOOKUP functions
Nesting INDEX and MATCH functions

ARRAY FUNCTIONS
What are array functions?
Working with standard array functions in Excel
Working with CSE array functions (Ctrl + Shift + Enter)
Returning array solutions from an array

MACROS AND MACRO EDITING

Recording a simple macro (recap only – see pre-requirements above)
Editing a simple macro
Creating an input message box
Displaying a message box
Working with cells
Working with columns and rows
Working with sheets
Working with workbooks
VBA code to increase macro efficiency
Error handling
Where to from here?        

Who should attend?

Aimed at advanced users who have an excellent knowledge of Microsoft Excel, this course provides candidates with practical experience of the topics listed in the course outline.      

Pre-requisites

Those attending should have a very good understanding of standard Microsoft Excel functions, be able to record a simple macro and be competent Microsoft Windows users.
Powered by Create your own unique website with customizable templates.