Free

Excel - Building Formulate and Graphs 2

Event Information

Share this event

Date and Time

Location

Location

Coombs Wood Business Centre

Halesowen

B62 8BB

United Kingdom

View Map

Event description

Description

This is a middle level course, designed to follow on from Building Formulae 1 and Picturing Data with Graphs. It seeks to extend delegates ability to use a variety of calculations and go beyond the basics with graphs in Excel.

Delegates should have already attended the Building Formulae 1 course (or be confident with the content) which covered basic calculations including the appropriate use of brackets, percentages and simple functions were explored as well as some initial methods for error checking. An existing knowledge of creating and formatting graphs would also be an advantage.

Course Content

  • Explore more complex formulae with operators and brackets

  • Further functions (eg Round, Rank, And/Or)

  • Introduction to nested functions and consolidation across sheets

  • Adjust graph settings and add details such as droplines and data tables

  • Create graphs to chart progression or display breakeven information

Share with friends

Date and Time

Location

Coombs Wood Business Centre

Halesowen

B62 8BB

United Kingdom

View Map

Save This Event

Event Saved