MS Excel Introduction

Service Description

This course will introduce new and existing users of Microsoft Excel to the fundamental features of spreadsheets and their use. Delegates are guided through its use from setting up a simple spreadsheet with values, labels and formulae to displaying information in graphical format. The course will also be of great benefit to those who have been using Excel for some time but who feel that they are not making best use of its facilities. The course will undoubtedly introduce these users to many shortcuts which they may not have discovered for themselves. Format • Classroom / virtual based; • Trainer led. Interactive with opportunity for questions and discussion. Audience • People who wish to understand what MS Excel can do for them • Those who suspect they are not getting the most out of MS Excel or who feel that they are not using it in the most efficient way. Pre-requisites • No prior knowledge of MS Excel is required; • Basic computer usage gained using email, internet etc. Course Content Navigation and Introduction • Good practice in spreadsheet design • Understanding spreadsheet terminology • Workbooks and worksheets • Rows, columns, cells, ranges • Entering values, labels, formulas Manipulating Data • Cut, Copy & Paste • Move & Copy Data between sheets • Autofill for Dates/Values/Text • Find & Replace • Clearing and deleting cell contents and formats Formatting Data • Formatting Cells • Font & Border Formatting • Shading and Colour Formats • Alignment Tools • Text Wrap • Number formatting • Decimals/Currency/Dates/Percentages Introduction to Formula & Functions • Create a mathematical formula • Add/Subtract/Multiply/Divide • Common Functions • Sum/Average/Max/Min/Count • Absolute References Worksheet & Data management • Sorts & Filters • Inserting and deleting Sheets • Moving and copying • Renaming Page Setup And Printing • Print preview • Adjusting margins • Applying headers and footers • Changing orientation Tips and tricks for most efficient use of Excel • Keyboard Shortcuts • Making use of the Right Click

Contact Details