Excel Formulas and Functions

ELECTUS
Adelaide, SA, Australia

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

Course Description:

'' This workshop provides the necessary skills to utilise formulas and functions within an Excel worksheet. It also looks at some of the more advanced logical, date and many other in-built functions available within Excel.



The in-built functions are special pre-written formulas that perform an operation or calculation on values in your worksheet, placing the result of the calculation into a cell in the worksheet. You can use these functions to simplify and shorten formulas in your worksheets, especially those that perform lengthy or complex calculations, thus helping to reduce errors and save time.

Course Content
Creating Simple Formulas

· Entering Formulas

· Using the AutoSum Button

· Using Basic Functions

· Using AutoCalculate

· Using Range Borders to modify Formulas

· Checking for Errors

Copying and Moving Data

· Copying/Cutting/Pasting Data

· Using Paste Options Button

· Creating an Absolute Reference

· Filling Cells

· Using Drag-and-Drop

Using Other Functions

· Using Financial, Logical and Date Functions

· Formatting Dates

· Revising Formulas

Using Advanced Functions

· Using the LOOKUP Functions

· Using the IF Function

· Using the ISERROR Function

· Using an AND Condition with IF

· Using an OR Condition with IF

· Using the ROUND Function

· Limiting the Precision of Numbers

· Using DATABASE Functions

· Using STATISTICAL Functions

· Using MATHEMATICAL Functions

...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Flash MX 2004 Advanced
Flash MX 2004
HTML
HTML/CSS Advanced
Programming in VBA using Access
Programming in VBA using Excel
Programming in VBA Using Word
Visual Basic
Certificate III in Business Administration
Certificate IV in Business Administration
Excel Pivot Tables & Filtering
Access Query and Reports

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: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.