Microsoft Excel | IT Training Course Content

INTRODUCTION

• Getting started
• Entering text and numbers
• Copy, Cut and Paste
• Simple calculations
• Formatting Cells and Ranges
• Printing Spreadsheets
• Working with Worksheets
• Saving and opening files
• More formulae
• Absolute Cell referencing
• Sorting data
• Creating Graphs and Charts

INTERMEDIATE

• Working with text and numbers
• Copy, Cut and Paste
• Using formulae
• Formatting text and numbers
• Aligning text and numbers
• Conditional Formatting
• Working with Worksheets
• Date and time calculations
• Working with Rows and Columns
• Using Headers and Footers
• Using Comments
• Printing options
• Using Excel as a Database
• Using If statements
• Using Graphs and Charts
• Saving Worksheets

ADVANCED

• Review and refresh exercise
• Manipulating text
• Useful formulae and functions
• Linking Worksheets and Workbooks
• Lookup tables
• Absolute Cell referencing
• Goal Seeking
• Formatting options
• Date and Time calculations
• Data manipulation
• Data Validation
• Scenarios
• Protection and passwords
• Macros
• Auditing a Spreadsheet

 All IT Training Courses can be tailored to your specific needs or requirements.

If you have any queries in regards to the Microsoft Excel Training Courses or your IT Training requirements then please do not hesitate to contact Blue256 on training@blue256.co.uk and we will contact you as soon as possible to discuss your queries and requirements.