Course Outline for Bespoke Excel

Familiarisation – Screen and Navigation
=CONCATENATE, &
=COUNT
=COUNTA
=COUNTIFs
=DATEDIF
=FIND
=IF, Nested IF’s, IF’s AND, IF’s OR
=IFERROR
=LEFT
=LEN
=LOWER
=MID
=NETWORKDAYS
=PROPER
=RIGHT
=SUBTOTAL
=SUMIF
=TRIM
=UPPER
=VLOOKUP

Array Formulas, Super Array Formulas
Avanced Filters
Brief Introduction to Macros
Charts, Advanced Charting
Comments
Conditional Formatting
Data Validation
Excel Options
Format Painter
Freeze Panes
Gridlines On Off
Hide Columns and Rows
How to show Formulas
Hyperlinks
Linking
Named Range
Paste Special – Skip Blanks, Transpose, Operation
Pivot Charts
Pivot Tables
Protection – Workbook, Worksheet
Split View
Tables and Filters
Tables and Sorting
Template Files
Text to Columns
Time and Dates

Contact Us For More Details

For more details please contact us on +44 (0)1865 515255 or email enquiries@oxfordpeg.com

Find Your Nearest Study Centre

Cyberessentials Certification