Course description
Who is this course for?
As a new user, with little or no experience of Microsoft Excel 2016 or other spreadsheets, the topics covered on this course will gently introduce you to spreadsheet concepts and empower you to create basic spreadsheets.
Content
Introducing Excel 2016
An overview of the benefits of spreadsheets.
Basic spreadsheet structure.
Tour of the Excel screen, including the ribbon and toolbars.
The Insights Panel and Smart Lookup
Spreadsheet Basics
Entering and editing your data using some quick techniques.
Using undo and redo.
Saving & Retrieving
Securing your work through Saving.
Understanding Excel 2016 file types.
Retrieving files.
Organising work directories.
Calculations
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.
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
Charts & Graphs
Use Excel's powerful charting capability including Sparklines to create and edit bar charts, pie charts and line graphs.
Printing
Previewing and changing the page layout.
Printing all or part of your work.
Database Functionality
Rules for Creating Database Tables.
Sorting and filtering data.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.