Excel (Intermediate)

by Systematix Training Claim Listing

This course is designed for learners who already have foundational knowledge and skills in Microsoft Excel and who wish to take advantage of some of the higher-level functionality in Excel to analyze and present data

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Systematix Training Logo

img Duration

1 Day

Course Details

Overview

This course is designed for learners who already have foundational knowledge and skills in Microsoft Excel and who wish to take advantage of some of the higher-level functionality in Excel to analyze and present data.

Upon completion of this course, you will be able to leverage the power of data analysis and presentation to make better informed, intelligent organizational decisions.

 

Course Requirements

Learners should have used Excel before and be familiar with creating basic formulas, using Autofill along rows or columns and working with Absolute Cell References (e.g. $C$5) to refer to fixed figures – such as VAT rates or performance targets.

 

What You Will Learn

In particular you will be able to:

  • Create advanced formulas
  • Work with named ranges
  • Analyze data by using functions and conditional formatting
  • Organize and analyze datasets and tables
  • Manipulate worksheets
  • Reading Branch

    Soane Point, 6-8 Market Place, Reading

Check out more MS Excel courses in UK

Prospect IT Training Logo

Microsoft Visio Training

Microsoft Visio is a diagramming and vector graphics application and is part of the Microsoft Office family. Visio is used to create ‘technical’ drawings for such things as business processes and floor plans.

by Prospect IT Training [Claim Listing ]
Storm Training & Solutions Logo

MS Excel (Intro)

Learn how to make spreadsheet design easy in the comfort of your work place onsite, learn the fastest tips and tricks to use formulae and functions, relative vs absolute references, page set up and print. Learn valuable short cut keys and be more productive.

by Storm Training & Solutions [Claim Listing ]
Olas Logo

Microsoft Access

Microsoft Access course is offered by Olas. Olas uses a variety of delivery methodologies and believe a blended learning approach leads to the participants retaining the knowledge learnt through the learning event.

by Olas [Claim Listing ]
Media Training Logo

Microsoft Excel VBA

Harness the power of VBA to manage large and variable amounts of data. Learn best practice for writing and editing VBA code and improve your data's usability.

by Media Training [Claim Listing ]
Act Training and Testing Logo

MS PowerPoint (Level 1)

MS PowerPoint for course is offered by Act Training and Testing for beginners. Students will learn the basic skills necessary to begin to effectively create presentations in Microsoft PowerPoint.

by Act Training and Testing [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy