Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Financial Data Management Reporting Using Microsoft Excel

By: Pavis Ventures (M) Sdn Bhd

Malaysia

22 - 27 Sep, 2014  6 days

Follow Event

  

Microsoft Excel is a popular tool in the world of business financial accounting. Many companies have been taking advantage of Excel’s financial management capabilities, and there are a number of examples of companies that have opted for Excel over other business tools. In this program, we’ll show you how to use Excel’s many tools, features, and functions to organize, manipulate, store, and present critical financial data. You will get familiar with the functions, formulas, commands, and keystrokes most useful in financial analysis and reporting. You’ll learn to perform complex calculations at the click of a mouse and use filters, queries, and searches to further refine your work. And that’s not the half of it — you’ll also learn to use Excel to prepare financial documents and reports that are professional-looking, colorful, and eye-catching and — best of all — simple for others to use and understand. Participants will gain the following:

  • Understand Excel’s tools and how they can help you: PivotTables®, PivotCharts®, DataTables, GoalSeek, Solver, and Scenario Manager — all demystified!
  • “Slice and Dice” your data with custom calculations
  • Take your PivotTables to the next level with calculated fields
  • Learn the difference between Query and
  • Lookup — which are you using, and which is better?
  • Understand conditional logic — how to make the most of complex functions
  • Use macros to automate tedious and repetitive tasks
  • Stop comparing data sets manually — learn to use Excel functions to easily compare two sets of information
  • Use the PivotTables and Chart wizards to save time — alone or together
  • Perform conditional formatting for at-a-glance analysis
  • Discover the benefits of templates pre-built into Excel!
Corus Hotel, Kuala Lumpur, Malaysia Sep 22 - 27 Sep, 2014
Please contact Pavis Ventures
(Convert Currency)

+603-91012669, +6014-6448590