Who is this course for?
This course has been designed to introduce the basic features and useful tools of Microsoft Excel for new Spreadsheet users.
How long is this course?
What do I need to know before attending?
There are no pre-requisites for this course.
What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:
- Use Excel to structure your data.
- Perform automatic calculations.
- Improve the appearance of your work with basic formatting.
- Produce simple charts.
- Produce well presented printouts of data, text and graphs.
- Save your work and retrieve it for future reference or changes.
Introducing Excel 2013
An overview of the benefits of spreadsheets.
Basic spreadsheet structure.
Tour of the Excel screen, including Ribbon and toolbars.
Entering and editing your data using some quick techniques.
Using undo and redo.
Saving & Retrieving
Securing your work through Saving.
Understanding Excel 2010 file types.
Retrieving files, organising work directories with Windows Explorer.
Basic Excel functions including Sum and Average.
Using the Insert Function tool for more complex calculations.
Changing the Appearance
Changing typeface style and size.
Aligning, bordering and shading your data.
Using Excel Themes and cell Styles to alter the look of your data.
Setting row and column heights.
Working with Spreadsheet Data
Moving, copying and deleting sections of your spreadsheet.
Using Autofill to copy and enter information.
Checking your spelling and correcting mistakes & using the Find and Replace tools.
Absolute Cell References
Understand Absolute Cell references within formulas or functions.
Charts & Graphs
Use Excel's powerful charting capability including Sparklines to create and edit bar charts, pie charts and line graphs.
Previewing work & changing the page & print layout.
Rules for Creating Database Tables.
Sorting and filtering data.