Attendance at this seminar will secure 6.5 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)
Tristan White
0118861395
nerissa@probetatraining.co.za
Perhaps you are lacking in confidence when it comes to using Excel yet now face the daunting prospect of needing to use Excel everyday as part of your day job.
Maybe you’re already using Excel every day and want to know if there are quicker / easier ways to get things done, to improve productivity.
Let us help you and your new intake, interns, scholars, receptionists, office clerks, professionals, as well as, administrative workers.
Excel is a powerful tool to analyse numbers, keep track of and arrange data, and graphically represent your information, so join us as we help you make the most of Excel, in order to make a positive contribution to your business.
• Introduction: Terminology / layout and interface / move or copy sheets /
Status Bar / View options
• Recovering Lost Documents: Save options / Attaching to emails / Finding
lost documents
• Built in Templates: Invoices / Loan amortisation schedule / Budgets /
Time sheets / Calendar
• Formatting: Change size, colour and appearance of text and numbers /
Alignment of text and numbers / Line breaks / Changing text from upper
to lower case / Format painter / Change appearance of numbers /
Formatting
issues, corrections and Windows Region Settings / Various ways to Paste
data
(e.g. hard pasting) / Have conversation within spreadsheet (using notes /
comments) / Continuing sequences
• Creating Worksheets: Adjusting rows and columns / Clearing data /
Running spell-checks / Setting up shortcuts through Quick Access
Toolbar / Inserting rows and columns
• Navigating Seamlessly: Navigating without a mouse / Freeze panes /
Multiple Windows ‘Views’ / ‘Split views’ to work in multiple parts of the
same spreadsheet / Searching for data
• Building Formulae: Exploring available library of formulae within Excel /
Building formulae / Performing mathematical calculations in Excel / Cell
referencing within formulae i.e. relative and absolute references /
Mathematical operators within Excel / Duplicating (dragging formulae)
without retyping / Reviewing formulae and using Status Bar
• Data Editing: Sorting / Filtering / Conditional formatting.
• Data Searching: Search and Replace text / Searching within filter
• Data Extraction: Flash fill / Text-to-Columns / Concatenate
• Tables / Graphs: Quick analysis / Charts
• Printing: Print preview / Set print area / Scale text to fit / Adjust margins /
Page break / Print Titles
First year SAICA Trainees
Second year SAICA trainees
Third year SAICA trainees
Bookkeepers
