Excel For Accounting and Finance
MICROSOFT EXCEL FEATURES CAN FAST TRACK BUSINESS PROCESSING
January 31, 2024
9:00AM - 12:00NN
*LIVE VIA ZOOM*
|
Program overview Accounting and finance management is immensely important in navigating a business. If you are in accounting or finance profession, you know how much analysis you need to do to understand each element or aspect of it. Excel for Accounting and Finance masterclass will not only let the participants master MS Excel, but also learn to use the material in improving their career.
Objective
- Develop a “toolkit” of Excel tips and techniques
- Sensitize and stress test Excel outputs from models
- Problem solve within an Excel environment
- Analyze large volumes of data
- Rank data and analyze large data volumes
- Data mine large data volumes and analyze
- Confidently use Excel’s keyboard shortcuts to improve their speed and efficiency
- Confidently develop Excel formulae in order to build robust solutions
- Quickly and consistently format presentation-quality spreadsheets
Who Should Participate Running the show in accounting or finance for a long time (or maybe for a few years), Accounting and Finance professionals know what role MS Excel plays in getting things right. Participating in this workshop may act as a refresher and participants may also learn a thing or two about the spreadsheet management.
Key Topics / Topic Outline Icebreaker/Energizer
Expectation Setting: Course, Trainer/Facilitator, Co-Participants, Self
Pre-Assessment Setting The Goal
Organizational Situationer
- Vision, Mission, Goals
- Values
- Needs Assessment
Internal Mission Statement
- Evaluation
- Idealization (Where do we want to go?)
Module 1: Get Quicker, Faster
- Setting up your profile
- Building your own quick access toolbar
- Calculation options
- Keyboard shortcuts (to make you 8 times faster)
- Navigation
- Highlight and moving data
- Spreadsheet manipulation
- Print set up for perfect printing
- Exercise: a keyboard shortcut exercise fixing errors on a spreadsheet without use of a mouse
Module 2: Efficient Presentation Protocols
- Inputs vs. formulae
- PDF document tricks for efficient data extraction into Excel
- Customizing numbers (percentages, multiples, dates, thousands, millions, etc)
- Styles – the quick way to format and create formats that can be used again and again and again
- Building and developing a style template
- Merger styles between models
- Exercise: a format exercise with data
Module 3: Building Flexible Formulas in Excel
- Relative vs. Absolute referencing
- Using names to increase formula efficiency
- Creating cell and range names
- Applying and redefining names
- Naming conventions
- Exercise: code a revenue matrix using relative and absolute formulae
- Logical statements
- IF, AND, OR functions
- Advanced logicals with flags
- Formula layout to simplify
- Snapping formulae (Alt-Enter)
- Data management and analysis within Excel
- Data sorting and filtering
- MAX, MIN, AVERAGE
- SUMIF, COUNTIF
- “Wild-card” SUMIF, COUNTIF
- Data mining in Excel
- HLOOKUP
- VLOOKUP
- CHOOSE
- INDEX
- INDEX (MATCH)
- OFFSET
- Exercise: Excel skills will be developed that will allow attendees to analyze, rank and disaggregate large volumes of data
- Working with text and dates in Excel
- Text strings (dynamic text)
- TEXT functions
- RIGHT
- LEFT
- LEN
- EDATE
- EOMONTH
- Building diagnostics into your model to monitor and sanity checks outputs
- Working with circularity in Excel
- Conditional formatting – uses and dangers
- Auditing tools
Module 4: Building Flexible Charts in Excel
- Chart set ups
- Chart formatting
- Dynamic labels
- Building bridge charts
Module 5: Spreadsheet Debugging Skills
- Building diagnostics into models
- Auditing skills
- Watch windows
- Using the camera
- Link elimination
- Circularity issues
- Unnecessary macro creation
- F5 functionality
- Exercise: using Excel skills attendees will fix and eliminate Excel errors and present the spreadsheet in a professional format
Module 6: Analyzing the Output
- Sensitivity analysis in Excel
- Techniques to minimize memory usage
- Self centering data tables
- Exercise: building data tables that sensitizes outputs and includes built in diagnostics to ensure that the data remains up-to-date
- Pivot tables
- Paste linking to Power Point
- Illustration case study: formatting, analyzing and evaluating large data sets, bringing together all of the skills covered over the two days
Setting The Goal
- Organizational Situationer
- Idealization (Where do we want to go?)
Post-Assessment Interactive Session/Workshop
CLOSING
Open Forum | Question & Answer
Evaluation Instructional Methods / Methodology: The course will be delivered through lecture and discussion using Microsoft Powerpoint and whiteboard. Spot recitations and group activities will be made throughout the duration of the seminar
|
|
|
|
Featured Speaker:
JEFF-MIKE SMITH SULE CPA, CIA
Principal Auditor American Data Exchange Company
|
Jeff-Mike Smith Sule is a national speaker on topics that involve external and internal audit, IT audit, real estate, and environmental planning, accounting and taxation, bookkeeping, business process management, and organizational transformation.
He graduated First Honorable Mention in secondary school and Magna Cum Laude in PUP-Manila with a bachelor’s degree in accountancy.
He worked as an IT and later on Financial Auditor at SGV and Co. Concurrent and after his stint at SGV, he has held various management position and become faculty member of various educational institutions such as Ateneo de Manila University, De La Salle University, Mapua, Far Eastern University, PCU and Polytechnic University of the Philippines. He was also an accreditor of the Association of Local Colleges and Universities
He also worked for ÆON Credit Service, under various management capacities: Internal Control Manager, Portfolio Manager and Internal Audit Manager. He is currently connected with American Data Exchange Company as a principal auditor while doing freelance consultancy engagements.
He is a Fellow of the Royal Institute of Accountants based in Singapore, a Certified Internal Auditor, a Scrum Fundamentals Certified, a Certified Bookkeeper under The Institute of Certified Bookkeepers based in the United Kingdom, holder of NCIII (National Certification in bookkeeping) under TESDA, and an Accredited Accounting Teacher and Accredited CPA in Commerce and Industry Practice. He has four active professional licenses under PRC, to wit, Certified Public Accountant, Real Estate Appraiser, Real Estate Broker, and Environmental Planner. He placed Top 7 and Top 2 in the 2010 CPA Licensure Examination and 2014 Real Estate Appraiser Licensure Examination, respectively.
|
|
|
|
REGISTRATION PER PAX
Excel For Accounting and Finance
MICROSOFT EXCEL FEATURES CAN FAST TRACK BUSINESS PROCESSING
January 31, 2024
9:00AM - 12:00NN
*LIVE VIA ZOOM*
REGISTRATION LINK:
ONLINE PER PAX
Regular Rate Php 1,699.00 + VAT starting JAN 25, 2024
Early Bird Rate Php 1,399.00 + VAT until JAN 24, 2024
Group Rate Php 1,299.00 + VAT per pax for 5 – 14 pax
Super Group Rate Php 1,099.00 + VAT per pax for 15 or more pax
Inclusive of the Webinar Sessions and the Digital Certificate
ATTENTION TO MS. JHIE
For More Details, Inquiry or
Reservation Please Call Us On:
Ms. Jhie
Marketing Officer
Tele Fax: 8470-1057
or Call/Text: 0906-4798186
Visit my FB PAGE @jhie.training
|
|
|
|
|
|