Excel Functions and Formulas - training course (1 day)

Excel training
Course code 
QEx-F&F
Course difficulty 
Introduction
Course duration: 
1 day
Course fees 
now £180 + VAT
Course PDF 
Course dates 
12 Nov 2018

This Excel training course teaches good techniques to structure calculations in spreadsheets.
 

Target Audience for Excel Functions & Formulas

This course is aimed at users with a fairly basic understanding of Microsoft Excel who need to create more complex spreadsheets and those who want to know more about creating and using functions and formulas in their work and building spreadsheets from scratch. If you already have a good level of knowledge about functions and formulas then maybe our higher level Excel Data Analysis course may be for you, or for even more advanced knowledge into the world of macros and Visual Basic then look at our Excel Visual Basic (VBA) training course

Excel Training Course Objectives

To understand how to structure spreadsheets and gain a good grasp of the most frequently used functions.

Excel Training Pre-Requisites

Basic Understanding of Microsoft Excel would be beneficial

Topics covered in this course

Excel Basics 

  • Review of Basic Shortcuts
  • Drag and Drop
  • Using AutoFill
  • Using AutoComplete
  • Rules for working with Formula
  • Basic Formula construction
  • How to lay out and design spreadsheets
  • Using cells in formula
  • Editing and Creating basic formula 

Cell Referencing 

  • Basic Cell Referencing
  • Fixed and Mixed Cell References
  • Shortcuts for Fixed Cell Referencing
  • Using Natural Language and Named Cells
  • Using the Name Manager
  • Referencing Named Cells 

Tables and Named Ranges

  • Using Data in Tabular format
  • Using External Constants
  • Creating a Data Table
  • Named Table Function
  • Formatting Named Tables
  • Assets of Named Tables
  • Adding Header, Footer and Total rows
  • Using Named Table Data in calculations
  • Named Row and Column conventions

Functions

  • Check on basic function
  • Sum, Average, Count, Min, Max..
  • Conditional Functions
  • CountIF, SumIF 

Data Validation

  • Using Data Validation
  • Using Data Validation drop downs
  • Using Data Validation to find Corrupt data such as blank spaces, misspellings etc 

Discovering Functions

  • Querying a function for its definition
  • Using the Insert function button
  • Searching for a function to solve a problem
  • Search techniques 

Text Functions

  • Importing Text strings
  • Converting Text to Columns
  • Separating Text strings
  • Find, Len, Right, Mid, Left 

More Functions

  • Multiple conditional function
  • Countifs, Sumifs, averageifs
  • Vlookup
  • HLookup
  • Analysing Filtered Data
  • The Subtotal function

Testimonials for this course

"I really enjoyed it! Everyone was very friendly and welcoming. The trainer was very engaging."
- Auditor, Plan Insurance May 2016
"I got more out of this course than I expected before walking through the door this morning. This will be a great benefit for me and the company. The training provided was efficient and detailed and set at a pace that anyone could keep up with regardless of the level of knowledge or experience you had. Would recommend this course to anyone who is clueless like I was in Excel or for people that would just like a refresher".
- Service Administrator, Cleankill Pest Control
"This course was very useful, learnt a lot more about Excel than I thought there was! "
- Receptionist, Nucleus Commercial Finance July 2017
"Andrew was excellent. Very affable and very clear and concise in his explanations. The whole day was thoroughly enjoyable and very relaxed. Lovely pub lunch included! Thank you."
- Admin Assistant, The HR Dept June 2017
Get a pub lunch when you come on a Qdos training course£60 off your first course at QdosGet a discount when you bring a friendResell our courses and earn referral commission
Qdos software training suite in Purley

CANCELLATION/REFUND POLICY

If you can no longer attend a course you have booked on, the following terms will apply depending on how many calendar days remain before the course date:

More than 30 days: You will be offered a full refund, or you may change to alternative course dates, or you may change the name on the booking.
21 to 30 days: You will be offered a 50% refund, or you may change to alternative course dates, or you may change the name on the booking.
14 to 20 days: You will be offered a 25% refund, or you may change the name on the booking.
0 to 13 days: No refund is offered, however you may change the name on the booking.