Tel: 01423 534630 • Email: info@tts-uk.com
Designed for Excel 365, 2019, 2016, 2013, 2010
Our Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel.
A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Excel is required.
At the end of this course you will have a good working knowledge of Excel basics.
You will feel more confident using Excel and be able to create a spreadsheet from scratch.
Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments.
Spreadsheets that you create will be easier to use and look more presentable.
After completing this course you will be prepared to attend the Excel Intermediate training course.
What’s new in Excel
Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges
Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX
Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat
Preparing to print
Page Setup options
Printing worksheets
Chart basics
Modifying charts
Printing charts