Nesting Logical Functions. The principals of nesting formulas together.
Using the IF function with nested AND and OR functions to output results to multiple question.
Advanced Pivot Tables. Grouping dates and numerical values.
Running percentage analyse. Running an comparison analyses. Inserting Field calculations. Creating a user-friendly dashboard report including charts.
Advanced Conditional Formatting. Using conditional formatting to alert us of data variables.
Colour table rows based on criteria within it. Apply colour to approaching dates.
Summing by Criteria. Using a SUMIFS function to sum numbers by criteria within rows.
Lookup Functions. Using functions to retrieve data from the left or right of a column that’s being looked up by using the INDEX and MATCH functions.
Recording Macros. Macro security. Understanding a Relative References macro.
Recording, running and editing macros. Saving files as Macro Enabled Workbooks.
Introduction to VBA code. Add a macro button to the Quick Access toolbar.
“I came over especially for the training with Go Courses. It was tailored perfectly – lots of hands on training in a great London facility just off Leadenhall Court. Thank you.”
Qamar Rathore, Hoffman La Roche
“Great course, with some great content. Lots to take away and review, as well as some interesting insights from a very knowledgeable trainer. Will definitely look to attend further AWS training in the future.”
Mark Conabeare, Landmark Property
“We’ve purchased a range of cloud-based training courses from Go Courses – very accommodating in terms of price and scheduling classes.”
Graham Riddall, Home Office
You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.