Do you or the staff in your office spend at least 4 hours a day, 3-5 days per week using Microsoft Excel? Have you counted the cost of you / your office using Microsoft Excel in a less-than-efficient way? When have you last actively invested in improving your own or your office’s Microsoft Excel skill level?
Well, ProBeta Training is here to help you improve the skill set of your office when it comes to utilising Excel as a daily tool.
This 2-HOUR course is aimed at those with a basic understanding of Excel functionality and want to be assured that they are carrying out their activities using the most efficient methods within Excel.
Join us as we look to refresh you on your Microsoft Excel knowledge and techniques, and help you take advantage of the advancements in this powerful spreadsheet technology.
Enabling delegates to:
o Open and create Excel workbook files
o Use the 2016 interface
o Enter and edit data in a variety of ways
o Understand basic formulas and functions
o Use the Quick Analysis features new to the 2016 version
o Format worksheets and data
o Print and share workbooks
o Introduction to intermediate functionality including Pivot Tables, VLookUps and Financial formulae
• Recovering Lost Documents: Auto-save function.
• Built in Templates: Budgets / expense tracker / invoices.
• Introduction: Terminology / layout and interface / move or copy sheets / Status Bar / Print Preview / Format Painter / various ways to Paste data / How Windows Regional Settings may affect your Excel.
• Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks.
• Data Editing: Sorting / filtering / conditional formatting / data validation / Subtotal formula.
• Data Searching: VLookUps / CountIf formula / If statements.
• Data Extraction (basic): Flash fill / Text-to-Columns / Concatenate.
• Building Formulae: Available library of formulae within Excel / Cell referencing within formulae ie relative and absolute references “F4-key” / Mathematical operators within Excel / Reviewing formulae with “F2-key” and CTRL+~ / Spell-check with “F7-key”.
• Financial Functions: PMT, IPMT, NPV, FV and PV
• Tables / Graphs: Quick analysis / charts / pivot tables.
• Printing: Set print area.
• 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.
