Course overview
By the end of this module you will be able to investigate and use formulas in spreadsheets, review and edit existing formulas, and format data - and apply these skills within the context of your job.

Who should attend
Delegates should feel confident in the topics covered in the Microsoft Excel Creating and Editing module.

Learning outcomes
At the end of the module, you will be able to:
• Investigate and use formulas in spreadsheets to perform core business calculations by selecting the most effective method
• Review and edit existing formulas using time-saving features to ensure accuracy and consistency of results
• Format data to present information in a clear and appropriate manner

Course contents
Creating formulas
What is a formula?
Rules of entering a formula
Entering calculations
Entering basic calculations, e.g. add, subtract, multiple and divide
Calculation order
Entering functions
Entering basic functions, e.g. SUM, AutoSum
Entering Statistical functions; e.g. AVERAGE, MIN, MAX, COUNT
Entering Logical functions; e.g. IF
Entering Date and Time functions; e.g. TODAY, NOW
Function Wizard
Using Insert Function to list functions and get help on them
Editing formulas
Editing a formula
Copying a formula, e.g. AutoFill
Entering all formulas in one step
Correcting errors in formulas
Using relative and absolute references
Understanding relative and absolute references
Creating formulas with absolute references
Formatting numbers
Understanding how to format numbers, e.g. $, £, 0.00
Using the Formatting toolbar and Format Cells dialog box
Clearing formatting

Related courses

Creating and Editing
Worksheets and Workbooks
Charts
Linking Spreadsheets and Formulas
Advanced Formulas
Sorting and Filtering Data Lists
Summarising Data Lists
Templates and Macros
PivotTable and PivotChart Reports

Home

© Alpha Training | Telephone 020 8658 6994 | Email admin@alphatraining.com