Excel - Formulas and Functions
Formula's and Functions
- Date and Time Functions
- SUM, AVERAGE, MIN, MAX and COUNT
- IF, AND, OR, and CHOOSE functions
- COUNTIF/SUMIF (s)
- MATCH AND INDEX
- 3D Formulas
- Learn how to instantly display all formula's in a worksheet
- Use entire row and column references in formula's
- Identify and correct errors in formula's
About Microsoft Building Blocks
Our Microsoft Building Block training allows you to mix and match any of our short training blocks to create a customised training day which meets all of your learning needs.
Please note that our Building Block sessions are designed to be combined together to create a unique training day and are not stand alone sessions.
SquareOne is among the UK's leading providers of IT training to businesses of all shapes and sizes. Our company pledge is to deliver inspiring, motivational and cost effective training which brings about tangible improvements in productivity. Through our training courses, individuals are able to gain lifelong skills and realise their full potential while clients achieve their corporate goals.
This interactive, Half day session focuses on teaching you how to simplify and automate your data calculations and analysis using the many functions and formulae available in Microsoft Excel.
Course Duration: Half day Classroom Training or Online
The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course.
These sessions can be provided in the following formats:
Seminar Format – Maximum of 100 delegates. This seminar will be delivered by a trainer as a demonstration. Session can last between 60 minutes to 90 minutes. If this is to be delivered to small groups then this can be repeated up to 3 sessions per day.
Walkabouts – These can be one-ones or small groups of people trained at their desks using their own PCs or Laptops. Timings to suit. Trainer to be onsite for the full day.
Classroom Training – Small groups of people using their own PCs or Laptops – or these can be provided by SquareOne at an additional cost. Sessions to be 3 hours in length. Can be combined with another session or walkabouts. Trainer to be onsite for the full day.
Clinics – Drop-in centre where a trainer can be onsite for the day and delegates come with problems or queries that they have on Microsoft Office software. Covers – Excel, Word, PowerPoint, Outlook and Windows. Additional software such as Project, Access and SharePoint would need to be arranged prior to booking.
Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at any office location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead, Aberdeen and Ireland.
Closed courses can also be delivered in European countries such as Austria, Belgium, Denmark, Greece, France, Finland, Hungary, Italy, Ireland, Netherlands, Norway, Portugal, Spain, Poland, Sweden, Switzerland and off shore.... Either in English or local languages
We offer training solutions for all versions of Excel - 2003, 2007, 2010, 2013 and 2016.
Below are a list of upcoming dates and locations where this course is scheduled to take place.