Micrsoft Excel Intermediate 1 DAY Training

From £125 per person - businesses only

Enquire today we have face to face and live online training available

What you will learn

  • You will learn beyond basic everyday Excel.
  • Absolute Reference.
  • Linking tables.
  • Function Libray.
  • Conditional formatting.
  • Pivot Tables.
  • Shareable Certificate Earn a Cerfiticate upon completion
  • Face to Face or Live Online Start instantly and learn at your own schedule
  • Flexible Schedule Set and maintain flexible deadlines
  • Intermediate For those with working experience or likely to have completed foundation level training
    Foundation Excel level attendance or experience.

This course consists of 11 lessons

Calculating with Absolute Reference. Understanding the difference between a Relative and Absolute referenced formula. Using a $ sign to lock formulas onto cells when copying.

Working with Groups of Worksheets.Grouping sheets together. Inputing data into multiple sheets. Writng formulas to sum between sheets.

Creating Linked Tables.Linking to a source table. Using Paste Link to link a table to another file. Using Link Manager to manage linked tables.

The Function Library. Using the Func3on Library to help you write. Formulas. Search formulas with Insert Func3on. Writing statistical func3ons: COUNTA, COUNTBLANK, COUNTIFS and more.

The Logical IFS Function. Writing Logical IFS func3ons to generate results from a test. Running multiple tests for multiple results.

Conditional Formatting. Automatically format data using rules. Enabling text and numbers to standout with automatic formatting. Copy formating with the Format Painter.

The Side by Side Feature. Viewing two tables in two different files together. Viewing two tables in two different sheets in the same file together.

Pivot Table Report. Analysing table data with PivotTable reports. Managing a PivotTable’s layout. Output statistics. Controlling number formats. Creating a PivotChart, and inserting Slicers for filtering.

Using Data Validation. Apply Data Validation to control and quicken the input of data.

Lookup Func&ons. The Lookup and Reference func3on. Best practices for writing a VLOOKUP function. Best practices for writing an HLOOKUP function. Achieving a professional finish to formulas by nesting within an IFERROR.

Printing Options. Printing page titles across pages. Scaling content for print.

Enquire today

Frequently asked questions

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.