Excel - Formulae and Functions

Oak Tree Management & Training Ltd.
Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This course will provide a thorough grounding in the use of calculations in Excel. In order to do this effectively, delegates will learn the fundamentals of calculations: creating simple formulae & the use of Excel’s in-built function formulae. This will lead onto the use of statistical and date functions and ultimately the use of logical “IF�statements that deal with multiple answers within formulae.

Calculations will be used in single worksheets, across multiple worksheets (3-d) and ultimately across multiple workbooks. The delegate will also gain a greater understanding of how spreadsheets can and are being used in businesses today.

Focus on the calculation (formulae & function) capabilities of Excel.
Speed up your productivity and become familiar with the Excel function library.
Using named ranges to make it easier to refer to cell references.
Follow calculations others have created and subsequently track and resolve errors.
Introducing conditional statements in formulae.
Course Objectives
By the end of the course the delegate will be able to:

Use Excel to create their own spreadsheets from scratch
Create mathematical calculations using simple formulae
Understand the purpose of functions within calculations
Use names to assist in referencing cells
Add reminders to cells through the use of comments
Course Contents
(Course Topics may vary at the Trainer’s Discretion)

Foundation Formulas (recap)
BODMAS
Enter formulas in a cell and use the formula bar
Revise formulas
Use AutoSum
Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX)
Use the Paste Function to insert a function
Autofill
Copying cells
Create a Custom List
Copying Formats
Number Formats
Apply predefined number formats incl. Decimal Places
Create custom number formats
Date Formats
Cell Referencing
Relative, Absolute and partial Absolute cell references
Worksheet management
Inserting, moving, naming, hiding, deleting worksheets
Linking Formulae
Link worksheets
Using 3-D references
Linking Workbooks
Link workbooks
Edit Links
Working with windows
Working with & arranging multiple windows
Freezing panes
Splitting windows
Working with Named Ranges
What are named ranges
Create, Define & Delete Named Ranges
Use a named range in a formula
Paste & Apply named ranges
Auditing a Worksheet
Trace precedents (find cells referred to in a specific formula)
Trace dependents (find formulas that refer to a specific cell)
Creating a Template
Protecting cells
Protecting sheets & workbooks
Saving a template
Beyond Basic Functions - Date
TODAY(), NOW()
Beyond Basic Functions - Logical
Use logical functions (IF)
Using Nested IF statements
Applying AND / OR
Annotating your work with Comments
Create, edit, and remove a comment
Display and Print Comments
Printing
Print Titles
Page Breaks
Headers & Footers ...''

Elements of this syllabus are subject to change.

Phone:(01284) 763040

School Address/Venue(s):

Park Farm Business Centre
Fornham St Genevieve
Bury St Edmunds
Suffolk
United Kingdom
IP28 6TS

Jobs & Resumes: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Houses & Roommates: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Travel Agencies: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Nottingham

Search other schools for Excel - Formulae and Functions training resources.

Access Working with Queries
Acrobat
Illustrator CS
InDesign CS
PageMaker 7
Photoshop CS2
Crystal Reports - Advanced
Crystal Reports
Excel Advanced
Excel Intermediate
Excel Foundation
Excel VBA
FrontPage Advanced
FrontPage
MapPoint
Outlook
Powerpoint - Advanced

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.