Eventbrite, and certain approved third parties, use functional, analytical and tracking cookies (or similar technologies) to understand your event preferences and provide you with a customised experience. By closing this banner or by continuing to use Eventbrite, you agree. For more information please review our cookie policy.

Invalid quantity. Please enter a quantity of 1 or more.

The quantity you chose exceeds the quantity available.

Please enter your name.

Please enter an email address.

Please enter a valid email address.

Please enter your message or comments.

Please enter the code as shown on the image.

Please select the date you would like to attend.

Please enter an email address.

Please enter a valid email address in the To: field.

Please enter a subject for your message.

Please enter a message.

You can only send this invitations to 10 email addresses at a time.

$$$$ is not a properly formatted colour. Please use the format #RRGGBB for all colours.

Please limit your message to $$$$ characters. There are currently ££££.

$$$$ is not a valid email address.

Please enter a promotional code.

N/A

Sold Out

Unavailable

Please enter a password with at least 8 characters.

You have exceeded the time limit and your reservation has been released.

The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologise for the inconvenience.

This option is not available anymore. Please choose a different option.

Ticket Information

Event Details

Understanding Excel formulas is essential if you plan to create sophisticated and reliable spreadsheet solutions.

If you feel less than confident about how Excel formulas work, and how to create your own formulas from scratch, then this is the course your need! Essential Excel Formulas and Functions by G Com Solutions examines all of the key elements which go together to make up an Excel formula. The course uses real-world examples to illustrate how to build formulas that solve problems and give meaning to your data.

Here are just some of the techniques you will master:

You will learn how to create robust formulas which can safely be copied into thousands of rows.

You will gain an understanding of relative, mixed and absolute references; and when to use, and when not use, those pesky dollar signs.

You will learn how to use Excel’s text functions to clean up and modify data, prior to creating reports.

You will become familiar with the use of conditional functions to add power and flexibility to your Excel models.

And you will learn how to use lookup functions to pull in key information from other worksheets.

Lookup functions

Date and time functions

How Excel handles dates and times, Construction dates with the DATE() function, Extracting date elements with DAY(), MONTH(), and YEAR() , Isolating the day, month and year , Determining the day of the week, Calculating the tme between two dates using DATEDIF(), Calculating elapsed time , Creating time sheets

Maths functions

ROUND() and MROUND() , ROUNDDOWN() and ROUNDUP() , CEILING() and FLOOR() , EVEN() and ODD() , INT() and TRUNC() , Using RANDBETWEEN() to generate data, Using RANDBETWEEN() to generate date and time values

Database functions

How database functions work, Defining the Excel database, Defining the criteria area, Using AND and OR with your criteria, The DSUM() function, The DAVERAGE() function, The DCOUNT() function, DMIN() and DMAX(), The DGET() function

Friday, 4 August 2017 from 09:30 to 16:30 (BST)

Organiser

G Com Solutions Limited

G Com Solutions specialise in providing Microsoft Power BI training, as well as IT training on a variety of web technologies and computer software packages, especially those by Microsoft and Adobe. These software environments have become the standard for business, web and multimedia development since they empower companies to develop web solutions more quickly than ever.

Whether you need IT training as an IT specialist or as one of the many people who need computer training to improve their skills for career advancement, G Com Solutions courses can help you.