The course provider will give you all the information you need (with no obligation)
ShareEmbed on your website
Venues and dates
Close ↑Open ↓
1st Floor, 7-8 Winckley Street,
Where to eat
Duk - 18 Lancaster Road, Preston
Eastzeast - 19 Church Street, Town Centre, Preston
Stanley Arms - 24 Lancaster Road, Preston
Persian Palace - 134 Church Street, Lancashire, Preston
Asia Garden - 43 Church Street, Preston
Where to park
Bus Station Cafe - Central Bus Station, Tithebarn Street, Preston
Preston bus station - Central Bus Station, Tithebarn St, Preston
Car Park, Preston - 35 Avenham Street, Preston
Norwest Car Wash - 1 Oak Street, Preston
Euro Car Parks - Saint Wilfrid Street, Town Centre, Preston
Close ↑Open ↓
20 hours of class
Method / place Inhouse
Brief description Learn spreadsheet skills to a good business standard and have the ability to manipulate company and personal data to present tables, charts and calculations. Total mastery of this course will enable you to present information both internally and externally of the company and keep up with your own personal accounting. Successful completion of this course will enable you to work towards further qualifications. Suitable for: Those who wish to learn this popular spreadsheet program.
Requirements Familiar with Windows environment and basic keyboarding experience.
Consult with training provider
Close ↑Open ↓
Lesson 1: Including: The Excel screen, creating a worksheet, entering text and numeric data, navigation, saving, naming and closing, opening an existing spreadsheet, editing cell contents, accessing help.
Lesson 2: Including: Changing font type and size, text enhancement, selecting cells and ranges, text alignment, merging and splitting cells, modifying column width and row height, printing the active sheet, creating a folder, saving in a different format.
Lesson 3: Including: Inserting and deleting rows, switching between multiple workbooks, moving and copying cells, cut, copy and paste, AutoFill, Office clipboard.
Lesson 4: Including: AutoComplete, Hide and unhide columns and rows, freezing and unfreezing panes, inserting columns, change text orientation, page break preview, changing to landscape orientation, adjusting margins and scaling, centring between margins, displaying gridlines, inserting headers and footers, setting a print area, selecting non-adjacent data, naming and deleting a worksheet, saving a workbook as a template, creating a workbook from a template.
Lesson 5: Including: Applying borders, formatting numbers, defining and applying styles, Auto Calculate, complex formulas, absolute cell references.
Lesson 6: Including: Inserting a new worksheet, formatting a worksheet tab, grouping and ungrouping worksheets, 3-D references, applying wrap text formatting, indenting text, printing row and column headings, centring text horizontally and vertically in a range, adding, viewing and editing comments.
Lesson 7: Including: Using the SUM and COUNT functions, AVERAGE, MAX and MIN functions, sorting columns, using NOW and IF functions, PMT and FV functions, AutoFilter, find and replace.
Lesson 8: Including: Using the Chart Wizard, creating a two series line chart, formatting the plot area, creating a pie chart, saving selected data and a workbook as a web page, inserting a picture, resizing and repositioning, inserting and modifying an object, inserting and using a hyperlink, creating, modifying and positioning a diagram.