Spreadsheet Methods

Information Technology

Spreadsheet Methods (5N1977)

The purpose of this award is to ensure that the learner is fully capable of using a broad range of advanced spreadsheets features to work effectively and produce clear printouts. On successful completion of this course the learner will be able to carry out advanced selection, formatting,charts, tables, formulae usage, macro production and design of dynamic spreadsheets.

"I was expecting spreadsheet methods to be somewhat difficult but to my surprise it was easy to understand and enjoyable to learn" - Ciara

[03k20252D052D025F043A54RTTLJTYN]
Access from unauthorized IP address detected.
You are connecting from an IP address linked to past fraud activity.
Please disable any VPN or other IP masquerading mechanism you may be using.
IP address: 18.117.77.136

Course content

modules

Investigate a range of common uses for spreadsheets
Explore key spreadsheet elements including cells, cell references, numeric, alpha, and alphanumeric data, formulae, functions, graphs and macros
Demonstrate common spreadsheet usability features to include use of toolbars, window management, sorting, and filtering
Use spreadsheet design features involving data and cell formatting techniques which enhance understanding and legibility
Automate routine multi-step tasks through the creation, execution, and management of simple macros
Print complete or partial sections of a spreadsheet, formatted fit for presentation
Use advanced spreadsheet features including absolute and relative cell references, conditional IF statements, statistical, financial, and date and time functions
Generate a variety of types of graphs, with appropriate titles and labels, from spreadsheet data
Produce a spreadsheet, with minimal supervision, that meets a simple design specification and is fit for purpose
Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to ensure they are fit for purpose.

Information Technology