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: 10

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

kate smith posted blog posts
2 hours ago
Adam Fleaming posted blog posts
4 hours ago
John Robinson posted a blog post

Training and Development is a highly developed and evolved, broad body of knowledge. Many employees place themselves at a disadvantage vis-à-vis their colleagues in the absence of the right professio…

Training and Development is a highly developed and evolved, broad body of knowledge. Many employees place themselves at a disadvantage vis-à-vis their colleagues in the absence of the right professional training and development. If employees have to consistently close gaps in their learning, they need to keep upgrading their knowledge and skills. They should also use training…See More
yesterday
Roger Steven posted a blog post

Ensuring compensation-focused compliance with Stark Law considerations

Stark Law compliance is now more than just a compliance issue. It has grown to become an Enterprise Risk Management matter, if the substantial awards and settlements in recent enforcement actions are anything to go by. For healthcare organizations that develop and implement provider contracts; managing their compliance and…See More
Tuesday

Forum

What is Class Structure in Pega?

Class contains the rule by way of which objects behave. outline rules such as houses, sports, flows, html paperwork, etc. to be had to different subordinate classes. lessons are organized into a…Continue

Started by Soujanya Naganuri on Monday.

How to Concatenate Two Tables in QlikView

Table combining and concatenationConcatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows of…Continue

Tags: datafields, developers, qlikview

Started by Soujanya Naganuri Jun 30.

SQL Server Windows Management Instrumentation Tasks

Hello,SSIS includes two special tasks that enable you to query system information and monitor system events: the WMI Data Reader Task and the WMI Event Watcher Task. These tasks are especially useful…Continue

Tags: Task, WMI, Server, SQL

Started by Madison Quinn Jun 20.

difference between NEBOSH and IOSH

NEBOSH “National Examination Board in Occupational Health and Safety”IOSH “Institution…Continue

Tags: kerala, IGC, NEBOSH

Started by mani May 31.

What's your favorite motivational/safety quote? 98 Replies

Favorite Motivational Quote: If you want something, you'll find a way - If not, you'll find an excuse.Favorite Safety Quote: Don't learn safety by accident!Continue

Started by Michelle Sears. Last reply by David R Snell Apr 26.

Badge

Loading…

© 2017   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service