Available Course

Excel Beginners and Intermediate

>> Click here to book this training as an In-House course <<

Duration: 1 Day
CPD Hours: Attendance at this seminar will secure 6.5 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)
Course Facilitator: Tristan White
T:  011-886-1395
E:  nerissa@probetatraining.co.za
Back

Excel - Beginner Have you hired new staff since going back to the office and need them to sharpen their Excel skills? Or are you required to work remotely, but finding the going a bit slow because you are new to Excel? Start your Excel journey well -- by joining ProBeta Training as we help give new Excel users a back to basics foundation in using Microsoft Excel. NOTE: This is a practical session whereby the presenter will demonstrate various Excel functions and features. Excel - Intermediate If you or your firm use Excel for multiple hours each day, imagine what the wasteful labour cost must be from using it inefficiently? ProBeta Training has designed a course for those individuals and offices that are heavily reliant on Microsoft Excel as part of their day-to-day work duties, be it in audit, accounting or office administration. The goal of this course is to Build up on your Basic Excel knowledge, Improve your efficiency and Show you alternative ways to get the same things done. This session focuses on the value-add elements like VLookUps, Pivot Tables, Concatenating text, and Conditional formatting, formula referencing, amongst others -- for those with an already established basic-level of Excel knowledge.

Excel Beginners Enabling delegates to: Open and create Excel workbook files Use the Excel interface Enter and edit data in a variety of ways Understand basic formulas and functions Use the new Quick Analysis feature Format worksheets and data Print and share workbooks Excel Intermediate Enabling delegates to: Enter and edit data in a variety of ways Understand complexities of formula referencing Introduction to intermediate functionality including Pivot Tables, VLookUps and Formulae referencing

Excel Beginners  Introduction: Terminology / layout and interface / move or copy sheets / Status Bar / Print Preview / Formatting / Format Painter / various ways to Paste data  Recovering Lost Documents: Saving documents / Attaching to emails / Auto-save function / Finding lost documents.  Built in Templates: Budgets / expense tracker / invoices.  Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks.  Data Editing: Adding filters and sorting  Building Formulae: Useful everyday formulae / functions, Mathematical operators within Excel.  Tables / Graphs: Quick analysis / charts.  Printing: Set print area. Excel Intermediate If you or your firm use Excel for multiple hours each day, imagine what the wasteful labour cost must be from using it inefficiently? ProBeta Training has designed a course for those individuals and offices that are heavily reliant on Microsoft Excel as part of their day-to-day work duties, be it in audit, accounting or office administration. The goal of this course is to  Build up on your Basic Excel knowledge,  Improve your efficiency and  Show you alternative ways to get the same things done.

None

None

None