Microsoft Excel And Business Analysis For Professionals

Microsoft Excel is the world’s most-used business intelligence tool. Its knowledge is even
compulsory for an MBA degree and the business world depends greatly on it. Microsoft excel and business analysis for professionals is intended for Sales Managers, Financial Analysts, Business Analysts, Data Analysts, MIS Analysts, HR Executives and frequent Excel users.

It is written by Michael Olafusi a two-time Microsoft Excel MVP (most valuable professional) and a full-time Microsoft Excel consultant. He is the founder of UrBizEdge, a business data analysis and Microsoft Excel consulting firm.

He has trained hundreds of business professionals on Microsoft Excel and has used the experience gained from interacting with them both during such training and while consulting for companies to write this excellent guide for the busy professional who needs the improved work productivity Microsoft Excel provides.

Microsoft Excel And Business Analysis For Professional
Microsoft Excel And Business Analysis For Professionals

Contents
Preface
Microsoft Excel: It’s more powerful and easier to…
How Excel Handles What You Type
Data Consistency, starting with the end in view
Building Datasheets that can easily scale
Sorting
Filtering
Data Cleaning
Data Formatting
Charts
PivotTable and PivotChart
Business Data Analysis
Power Excel Formulas
Named Range, Goal Seek and Scenario Manager
Introduction To Excel VBA (macros)