Online Safety Community

Mastering budget spreadsheets in MS Excel

Cash flow budgets, preserving key formulae and streamlining formula writing are just some of the varied functions of MS Excel. This wonder program helps the user to carry out a number of functions, all of which help in facilitating business decision-making. These apart; MS Excel offers users the opportunity to explore and carry out a vast range of activities, functions and calculations.

excel-ninja-course

An expert with a quarter of a century of working in the world of Microsoft products will be explaining these and related functions of MS Excel in a clear and easy to understand manner. Why not join David Ringstrom, author and nationally recognized instructor who teaches Microsoft-related topics at scores of webinars each year, for an enlightening webinar session on the multiple uses of MS Excel?

This webinar is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance. All that is needed to register for this highly educative and entertaining session is to visit http://www.compliance4all.com/control/w_product/~product_id=501299L...

Speaker’s rich experience at play

The major advantage that participants to this session will have is that they will learn from the honcho of Microsoft programs. David’s Excel courses are based on over 25 years of consulting and teaching experience. He believes in the mantra, “Either you work Excel, or it works you”. With this thinking in mind, he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower them to use Excel more effectively.

It is this outlook that will be of immense use to professionals such as Accountants, CPA’s, CFO’s, Controllers, Excel users, Income Tax Preparers, Enrolled Agents, Financial Consultants, IT Professionals, Auditors, Human Resource Personnel, Bookkeepers, Marketers and Government Personnel, professionals whom this webinar seeks to benefit.

331zya9

Ways of creating resilient and practical budget spreadsheets

The core of the learning of this webinar is how to create resilient and practical budget spreadsheets. David will familiarize participants with a wide range of helpful techniques, which include ways of separating inputs from calculations, streamlining formula writing, preserving key formulas, and creating both operating and cash flow budgets. An additional benefit is the explanation he will offer of the uses and benefits of a variety of Excel functions, including CHOOSE IFNA, IFERROR, and ISERROR ROUNDUP and ROUNDDOWN VLOOKUP and SUM and SUMIF.

This session is useful in more ways than one. David will demonstrate every technique at least twice first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. Both during the presentation and in his detailed handouts; David will draw participants’ attention to the many differences in Excel 2013, 2010, and 2007. David will also offer an Excel workbook that includes most of the examples he uses during the webcast.

The core of this learning session is to impart the following learning objectives:

  • Learn to create both operating and cash flow budgets
  • Learn how to streamline formula writing
  • Transform filtering tasks using the Table feature
  • Understand the benefits associated with a variety of Excel functions
  • Apply and isolate all user entries to an inputs worksheet
  • Protect all calculations and budget schedules on worksheets
  • Use range names and the Table feature to create resilient and easy-to-maintain spreadsheets
  • Calculate borrowings from, and repayments toward, a working capital line of credit

David will cover the following areas at this webinar:

  • Avoiding the complexity of nested IF statements with Excel’s CHOOSE function
  • Streamlining formula writing by using the Use in Formula command
  • Improving the integrity of spreadsheets with Excel’s VLOOKUP function
  • Comparing IFNA, IFERROR, and ISERROR functions and learning which versions of Excel support these worksheet functions
  • Going beyond simple rounding with the ROUNDUP and ROUNDDOWN worksheet functions
  • Learning a simple design technique that greatly improves the integrity of Excel’s SUM function
  • Using the SUMIF function to summarize data based on a single criterion
  • Learning how range names can minimize errors, save time in Excel, serve as navigation aids, and store information in hidden locations
  • Learning how the Table feature allows you to transform filtering tasks
  • Preserving key formulas using Excel’s hide and protect features.

Views: 14

Comment

You need to be a member of Online Safety Community to add comments!

Join Online Safety Community

Take our poll!

Take our poll!

Latest Activity

Training Doyens posted events
6 minutes ago
Denise McGinn, CAE posted a blog post

Michigan Safety Conference Wins Award

Dearborn, MI (September 14, 2017)- The Michigan Safety Conference SPARKLED like a DIAMOND at the 16th annual Michigan Society of Association Executive Diamond Award Banquet on September 14, 2017.  The Conference received a Diamond Award in the Meetings & Exposition category (Less than $1million), for its excellence at the 2017 Michigan Safety Conference (April 11-12, 2017). MSAE’s 16th Annual Diamond Awards recognized the best of the best in the association industry. As a star-studded and…See More
11 hours ago
rodriguezcecelia posted a blog post

How to Benefit from Six Sigma Training Chicago

The first step that you need to follow when it comes to benefiting from 6 Sigma Training Chicago is finding out exactly what your options are. The right website will help you in this matter by offering you information regarding the type of Six Sigma Training in Chicago that you can opt for, the belt certification system and the software that is all about statistical analysis. You should not make any decisions before you know which of these options matches your needs.For example, if you are not…See More
16 hours ago
John Robinson posted blog posts
20 hours ago

Forum

Differences between Sap devoloper and Sap technical consultant.?

What are the main Differences between Sap devoloper and Sap technical consultant.?Continue

Tags: training, differences, sap

Started by emmablisa Sep 6.

Black Belt Training Course in Reno

Welcome to MSys Training! We thank you for visiting MSys LSSBB training page. Attend our 4 days Lean Six Sigma Black Belt (LSSBB) training program with 100% pass rate, high quality course material,…Continue

Tags: sigma, six

Started by rodriguezcecelia Aug 25.

QlikView 12.10 Service Release 8 and QlikView Governance Dashboard 2.0.4 now available

Hello all,Qlik announced that QlikView 12.10 Service Release 8 [SR8] is now available on Qlik download site.   SR8 is a…Continue

Started by Madison Quinn Aug 22.

PMP Certification Boot Camp Los Angeles

Welcome to MSys Training, North America’s leading training provider. Read some of our reviews on www.trustpilot.com. MSys’ PMP® program…Continue

Tags: PMP

Started by rodriguezcecelia Aug 22.

Safety - A Prerequisite 11 Replies

Whether working at home or outside, to observe safety should be our pre-requisite. The employer before anything must be sure of the safety of its employees especially the ones working in mines or any…Continue

Tags: products, safety

Started by Enna Henry. Last reply by Tara safe Aug 16.

Badge

Loading…

© 2017   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service