Update and refresh with Microsoft Excel

This one day course is designed for users who wish to update and refresh their knowledge in the Excel application to become more confident and adept when selecting and applying commands. There will be an opportunity to create spreadsheets incorporating basic formulas, charts, applying editing and formatting techniques.

Pre-requisites

Delegates should be familiar with the keyboard, knowledge of working with Microsoft Office Excel and Microsoft Windows Operating System.

Course details

WorkbooksRefresh on structure of WorksheetWhat’s new? (Excel 2010 / 2013)Working with Workbook WindowInserting new WorksheetsLinking between WorksheetsRenaming and colouring Worksheets

Page Setup, Layout and PrintingDisplay and Page LayoutHeaders and FootersPage OrientationPrint OptionsOpen a New Window within a WorkbookCopying, Moving Data

Formatting and Editing techniquesFormatting OptionsDate and Time, CurrencyCut, Copy and Paste Special optionsWrap and Merge CellsFind and ReplaceSorting and Filtering DataWorking with HyperlinksApplying Conditional FormattingFreeze and Hide Columns and Rows