logo small

Spreadsheets

Microsoft Excel is the world’s leading commercial spreadsheet software application. It has several features including calculation, graphical display tools, pivot tables and a macro programming language called Visual Basic for Applications.

Beginner Beginner Beginner Biginner Intermediate Advanced
Skills Covered • Use Excel to create, save & open spreadsheets • Enter & edit information in worksheets • Use formulas & simple functions to add, subtract, multiply & divide numbers • Enhance worksheets with fonts and borders • Format numbers & resize cells • Preview & print spreadsheets • Create & format Charts • Use relative, mixed and absolute cell references • Manage and navigate worksheets in a workbook • Sort & filter information held in tables • Create & use custom cell formats • Use conditional formatting to highlight results • Use logical, mathematical, statistical, date/time & text functions • Use Named cell ranges in formulas • Customise charts & control chart options • Use drawing tools & fill effects for pictures & illustrations • Record Macros to automate tasks • Create & modify macros • Create & use Custom Excel functions • Use Auditing Tools to check for errors in formulas • Combine functions in formulas & create Nested IFs • Use Protection to prevent accidental changes to formulas • Use formulas to link data in separate worksheets & workbooks • Use Goal Seek & PivotTables to analyse data • Import & export Excel data with other programs
Price £30 per hour £35 per hour £40 per hour

You are viewing the text version of this site.

To view the full version please install the Adobe Flash Player and ensure your web browser has JavaScript enabled.

Need help? check the requirements page.


Get Flash Player