Your First Steps to Excel 2016
Course Code: VTLOKFSE6
Duration: 2 Days (14 Hours)
New to Excel? Looking to pick up this skill but worried it might be too difficult or too much to handle? If the answer is yes then this is the course designed just for you!
Your First Steps to Excel 2016 is like no other Excel courses out there, including our existing Excel Basic to Intermediate courses. Your First Steps to Excel 2016 covers only the necessary features and functions to get you started on Excel. Not as tech savvy as everyone else or require more time to absorb information? This is the course for you. Conducted over a period of 2 days at a slow and relaxed pace, more time for practice is available.
This course promises to equip you with the basic and essential functions of Excel. Having a strong foundation on Excel helps to enhance your productivity in handling basic data and calculations at work.
Excel Basic to Intermediate courses are better suited for learners wishing to learn a wider variety of topics or at a quicker pace.
This course is for
Learners with zero to little knowledge on Microsoft Excel 2016.
Public Sector – Division 1, 2 & 3
Private Sector – Applicable to All
- Excel Interface
- Working with Workbooks
Save. Save As, Open, Close, New
Open Two Workbooks, View Workbooks Side By Side
Freeze Column/ Row Worksheets (Move, Copy, Insert, Delete, Tab Color, Rename)
- Working with cells
Data Entry (Number, Text, Date, Time)
Copy (Range) and Move
Insert Column, Row, Delete, Hide, Unhide, Move Column or Row
- Formatting Cells
Ribbon, Font, Alignment, Border Formatting Merge, Wrap Text, Number format (Percent, Accounting, Currency)
Apply Conditional Formatting
Clear Format, Clear Comment
Calculation using number, date, time
Simple Functions SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, TODAY, NOW
Absolute Cell (F4 Key)
- Page Layout
Print Layout View
Insert Page Break / Remove Page Break
Page Orientation, Paper Size
For Your DelightRefreshments are provided for morning and afternoon tea breaks.
A Certificate of Attendance will be given subject to 90% attendance.
We can tailor this course to suit your needs in terms of course dates, times and location. If you are an organisation, we can further customise the course to meet your training needs and requirements.