Duration: 1 Day
We can deliver training onsite at your workplace or via virtual classrooms if preferred.
For individuals who have never used the Excel spreadsheet package before or have only used Excel for Limited tasks. At the end of the day you will be able to create professional looking spreadsheets.
What you will learn:
| Excel Introduction | Formulas |
| · Viewing Screen Layout – Ribbon Bar | · Introduction |
| · Entre, Move & Clear Data | · Order of Operations |
| · Selecting Excel Data Areas | · Add, Subtract, Multiply, Divide |
| · Saving Excel | · Auto Sum & Auto Average |
| · Creating New Workbooks | · Percentages |
| · Cut, Copy & Paste | · Absolute Call Referencing |
| · Naming, Deleting & Working with Sheets | |
| Printing | |
| Data Manipulation | · Print Preview |
| · Widen Rows & Columns | · Page Layout |
| · Inserting Rows & Columns | · Headers & Footers & Print Areas |
| · Moving Data | |
| · Deleting Information | Utilities |
| · Sorting Options | · Introduction to Charts |
| · Freeze Panes | |
| Formatting | · Intro to Conditional Formatting |
| · Formatting Numbers | · Auto Fill Options |
| · Formatting Text | |
| · Borders & Shading | |
| · Align Data |
Duration: 1 Day
We can deliver training onsite at your workplace or via virtual classrooms if preferred.