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 - Advanced

Course Description

This is a Microsoft Excel Advanced 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 familiar with the mosre advanced functions of Microsoft Excel and also be equipped with the necessary skills to produce complex documents and integrate them with output from other Windows applications.

Course Content

FUNCTIONS
Getting help about using a particular function
TODAY
DAY
MONTH
YEAR
SUMIF
ROUND
COUNT
COUNTA
COUNTIF
PROPER
UPPER
LOWER
CONCATENATE
FV
NPV
PMT
PV
RATE
HLOOKUP
VLOOKUP
IF
AND
OR
ISERROR
DSUM
DMIN
DMAX
DCOUNT
Using nested functions

USING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES
Using a one input data table command
Using a two input data table command

A FIRST LOOK AT PIVOT TABLES
Creating a Pivot Table
Dropping data into the Pivot Table
Modifying data and refreshing the Pivot Table
Grouping data within a Pivot table

SCENARIOS
Scenario Manager - an example
Showing a scenario
Viewing an alternative scenario
Create a scenario summary

AUDITING
Tracing precedent cells
Tracing the dependants of a cell
Displaying all formulas within a worksheet
Adding comments
Displaying comments
Removing comments
Editing comments

MACROS

Displaying the Developer tab
Recording and running macros
Lowering your macro security level
Customizing the Quick Access Toolbar
Changing the Quick Access Toolbar Macro icon
Removing a macro icon from the Quick Access Toolbar
Raising your macro security level

Who should attend?

Aimed at frequent users who have an excellent knowledge of Microsoft Excel’s basic and intermediate principles, this course provides candidates with practical experience of the topics listed in the course outline. 

Pre-requisites

Those attending should have an understanding of Microsoft Excel to an intermediate level, be competent Microsoft Windows users, and be familiar with the basics of file and disk management.
Powered by Create your own unique website with customizable templates.