Excel Introduction

Our Introduction to Excel assumes no prior knowledge of the program and allows users to grasp key spreadsheet concepts as well as getting to grips with the powerful time-saving features unique to Excel.

Scheduled courses in London: 

Basics

Standard toolbar overview, Formatting toolbar overview, Data entry , Block selection , Copying data, Moving data, Inserting cells, rows and columns, Deleting cells, rows and columns, Resizing rows and columns, Using the AutoFit facility, Undoing and redoing operations, Spell checking, Printing a spreadsheet

Formatting

Setting alignment, Using cell shading, Adding borders to cells, Using Autoformat, Number and date Formats, Creating styles , Applying styles, Modifying Styles , Using conditional formatting

Formulas

Formulas , How formulas work, About cell references, About Excel ranges, Overview of functions , Using the AutoSum facility, Using the formula palette, Using conditionals, Statistical functions, Financial functions, Creating external references

Charts

Creating a chart, Setting chart options, Editing chart elements , Editing chart data, Adding logos and graphics, Printing charts

Productivity

Creating reports, Setting print options, Creating custom lists, AutoCorrect , Password protecting documents, Protecting worksheets, Using hyperlinks, Save As Web Page, Web Page Preview

Back to top