Micrsoft Excel Intermediate 1 DAY Training

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.