(08) 9383 8000
Excel - Essentials
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.
1 Day
Overview
This course introduces you to the most important features of Microsoft Excel. You will learn how to design, format and print spreadsheets, how to create charts and how to develop formulas and functions.
If you use computers but are new to Excel, or don't have much experience with Excel, then this course is for you.
Content
- Enter and edit data
- Move around the Excel screen
- Copy and move data
- Write and apply formulas
- Insert commonly used functions
- SUM and AVERAGE
- MAX and MIN
- COUNT
- Format the spreadsheet
- Print the spreadsheet
- Create and print charts.
Learning Outcomes
Participants should be able to:
- Use the most important Excel commands
- Design and construct spreadsheets
- Use simple functions and formulas
- Format and print spreadsheets
- Create and print charts.
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.
A vast majority of projects that suffer cost and time overruns do so because they lack professional scheduling. This course focuses on key tools of Microsoft Project needed by schedulers and planners; the Work Breakdown Structure (WBS) and the Critical Path Method (CPM).