, Contents
© Michael Olafusi 2014
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)
, Copyright © 2015 Michael Olafusi
Published by
www.urbizedge.com
All rights reserved. No part of this publication may be reproduced, distributed, or
transmitted in any form or by any means, including photocopying, recording, or other
electronic or mechanical methods, without the prior written permission of the publisher,
except in the case of brief quotations embodied in critical reviews and certain other
noncommercial uses permitted by copyright law.
eBook written and formatted by
, Preface
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.
This book is aimed at making you very good in Microsoft Excel for business data analysis,
teaching you with companion videos and practice files that can be access at
www.urbizedge.com/about (bottom of the page). It’s 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 trainings and while consulting for companies to
write this excellent guide for the busy professional who needs the improved work
productivity Microsoft Excel provides.
If you feel any part of this book can be better improved or expanded, please send an email
to
© Michael Olafusi 2014
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)
, Copyright © 2015 Michael Olafusi
Published by
www.urbizedge.com
All rights reserved. No part of this publication may be reproduced, distributed, or
transmitted in any form or by any means, including photocopying, recording, or other
electronic or mechanical methods, without the prior written permission of the publisher,
except in the case of brief quotations embodied in critical reviews and certain other
noncommercial uses permitted by copyright law.
eBook written and formatted by
, Preface
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.
This book is aimed at making you very good in Microsoft Excel for business data analysis,
teaching you with companion videos and practice files that can be access at
www.urbizedge.com/about (bottom of the page). It’s 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 trainings and while consulting for companies to
write this excellent guide for the busy professional who needs the improved work
productivity Microsoft Excel provides.
If you feel any part of this book can be better improved or expanded, please send an email
to
