This is a repeating eventaugust 12, 2022
One Day Course This course is intended to allow people with an existing knowledge of working with basic spreadsheets within Excel to move on to
One Day Course
This course is intended to allow people with an existing knowledge of working with basic spreadsheets within Excel to move on to the next level of ability including working with more complex spreadsheets, analysing and presenting data.
Course Aims to enable delegates to:
Produce more professional spreadsheets and charts using Microsoft Excel and build on existing knowledge to manipulate and analyse data. The training is designed for existing Excel users wanting to increase their skills.
|Working with Large Spreadsheet View options Hiding/displaying data Freeze Panes Grouping & Outlining Printing From Excel Page Layouts Printing Large Data Sets Working with Multiple Worksheets Using multiple worksheets Linking worksheets Managing workbooks Advanced Formatting Borders and shading Special number formats Dates Pre-set Styles Custom Styles Conditional formatting Data Bars, Colour Scales & Icons Custom Conditional Format Rules||Advanced Formulae Relative Cell References Absolute Cell References Logical Statements (IF) Simple Lookups Useful Functions List Management Creating lists Sorting and filtering AutoFilter Advanced filtering Documenting and Auditing Comments and Text Boxes Useful Auditing features Charts & Graphs Creating auto-charts Creating customized charts Chart Locations Working with Chart Elements Formatting chart options Adding graphic elements|
Microsoft Excel Advanced
Requirements before booking this course:
This course is for people who wish to expand on their current knowledge of Microsoft Excel. Anyone attending the course should either have attended Excel Foundation level, or have an equivalent knowledge.