This one-day course is designed to help a delegate to develop skills in using Microsoft Excel as a spreadsheet tool. A delegate will learn to manage and link together multiple worksheets, create charts (graphs), apply more advanced formatting & work with databases.
| This course consists of 5 modules | |
|---|---|
| Module 1 | Databases Creating a Database Naming a Database Working with Table Advantages of using Tables Sorting a Database Multiple Sorts Sort in a Special Order Sort by Custom Lists |
| Module 2 | Using Filters Types of Filters Using Custom Filters Understanding the And/Or Turning the Filter Off Advanced Filter Filter Unique Records Remove Duplicates Highlight Duplicates |
| Module 3 | Relative & Absolute References Text Functions Concatenate Function Date & Time Functions Linking – Copy & Paste Link Create Links to Different Worksheets Create Links to Different Workbooks Using the Edit Links to Open Source Files, Change Source Files, Breaking Links to Source Files Create Picture Links Create Links between Excel & Word Consolidate Reports & Subtotals Nested Subtotals Outlining a Worksheet |
| Module 4 | Controlling Worksheet Display Splitting of Panes Freezing Panes Validating Data Separate Text into Columns Transpose a Range Copy a Sheet to the same Workbook Copy a sheet between Workbooks Moving Sheets Working with Comments Sheet Protection with a password Workbook Protection with a password |
| Module 5 | Charting: Creating Charts, Sizing & Moving Charts, Modifying Charts, Changing Chart Types Adding & Deleting Data Inserting Chart Titles Data Labels Change the Legend Line Charts Creating Charts with a Secondary Axis Creating Picture Charts |
| Module 6 | Create a Shape Modify & Align Shapes Insert a Picture Format Pictures |
Any delegate wanting to develop their skills in using Microsoft Excel to design spreadsheets to solve accounting and data analysis tasks.
1 Day
R1 270,00 (excl. VAT)
View the available course dates
