Basic Excel – Introduction for Entry-Level Users
|CPD Hours:||Attendance at this seminar will secure 2 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)|
Are you new to Excel? Have you just joined the work force? Is there a new recruit who will need to use Excel to fulfil daily work duties? If you’ve answered yes to any other above questions, then join us for a two-hour webinar where we introduce you to Microsoft Excel.
Enabling delegates to: o Open and create Excel workbook files o Use the 2016 interface o Format worksheets and data o Become comfortable with Excel’s interface
• Introduction: o Terminology o Layout and interface o Move or copy sheets o Status Bar o Print Preview and set print area • Completing / Filling in a Spreadsheet • Working with Data: o Formatting data (changing appearance, font, size, colour and upper-case / lowercase) and Format Painter o Inserting Line Breaks o Various ways to Paste data • Recovering Lost Documents: Auto-save function. • Built in Templates: Exploring pre-created templates eg. budgets, expense tracker, invoices • Creating and Editing a Spreadsheet: o Insert, delete and adjust rows and columns o Executing sum formula o How to do spell-checks • Navigating Seamlessly: o Freeze panes o How to navigate without a mouse o How to search for text o Quick access toolbar
• Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. • Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. • Delegates that prepare reports and need to be able to edit text and numbers.