Microsoft excel for professionals
Essentials & Intermediate One
VOLUME 1, 2018
Published By:
RichardBlack Media
First published 2018
Abiola Abiola David asserts his moral right to be identified as the author of this book
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 author.
DEDICATION
To my darling wife, Abiola Olawunmi Ifeloju, who is the embodiment of love, encouragement and inspiration.
To all the professionals, decision makers and business owners who analyse, present and make decisions using data
ACKNOWLEDGEMENTS
First and foremost, I would like to bless the name of the Lord and return all the gory to Him for all the things He has done for me from childhood to adulthood. I appreciate Him, who is the source of life and giver of mind-blowing ideas who inspired me to take the long journey of writing this epoch-making book after His divine arrangement for my life.
Secondly, I appreciate by parent Late Mr Owolabi Awonuga and Mrs Oluwakemi Oremade. Words would fail me to describe the efforts of my lovely mum with the help from God, to single-handedly brought me up and educate me from primary to the university level. In addition, I sincerely appreciate my reliable elder sister, Mrs Remilekun Samuel for are sisterly love and care.
Thirdly, I sincerely appreciate by indefatigable and beautiful wife, Olawunmi, for being the source of my inspiration and encouragement that ultimately lead to the writing of this masterpiece. Her perseverance, in spite of the longs hours of writing and editing this book through many nights and days, is unique
Furthermore, I cannot but appreciates my spiritual parents-in-the-Lord, for their impact in my life Pastors Jacob Oluwaleke (RCCG, LP 30 APICP Admin), Mrs Arikawe Abimbola, Ausi Taiwo, Late Temile Francis, Anderson Airen, Funsho Adeyanju, and Alex Bekeowi.
Finally, I appreciate the following glorious folks Mr. & Mrs. E.O Emola (my father and mother-in-law), Mr & Mrs Olakunle Fella, Mr Adeola and Olamide Emola. Mr & Mrs Ewuola. Mr Taiwo Samuel, Teniola and Olamide Samuel.
Table of Contents
EXCEL JET ESSENTIALS
LECTURE ONE
INTRODUCTION TO SPREADSHEET
Microsoft Excel is a software program developed and produced by Microsoft Corporation. It allows users to organize, format and calculate data with formulas and built-in functions. In addition, it enables using of graphical tools, creating pivot tables, recording macros, performing accounting calculations, building data models and dashboards. Microsoft Excel is part of the Microsoft Office suite. The other software being Microsoft Access (database), Microsoft Word (word processing), PowerPoint (presentation), Outlook (emails), Publisher, Note, Skye for Business etc.
STARTING
To start with, type Excel on the computer search and click on Microsoft Excel. A new workbook opens for usage.
HOME TAB
The Ribbon contains all the tools needed to work in Excel. The Home tab contains Clipboard, Fonts, Alignment, Numbers, Styles, Cells and Editing.
INSERT TAB
In the Insert tab, there are Tables, Illustrations, Adds-in, Charts, Maps, Spark lines, Filters, Links, Text and Symbols. In the Layout tab, there are Themes, Page Set-up, Scale o Fit, Sheet Options and Arrange.
PAGE LAYOUT TAB
The page layout tab contains the tools needed for page setup and scaling of page layout view before printing. In addition, theme is located in the page layout tab. It allows users to choose from arrays of styles which automatically extends to other worksheets that have the same structure
FORMULAS TAB
The Formula tab contains Function Library, Defined Names, Formula Auditing, Calculations options
DATA TAB
Data tab contains Get & Transform, Connection, Sort & Filter, Data Tools, Forecast, Outline and Analyse tools. The Get & Transform is used to import data from different sources into the Power Query Editor for cleaning and transformation.
REVIEW TAB
Review tab contains Proofing, Comments and Changes.
VIEW TAB
View tab contains Workbook Views, Show, Zooms, Window and Macros.
HOME TAB FONT GROUP
In the Home tab, the Font Group contains all the tools needed for changing text. At the bottom right hand corner of some of the groups, there are small dialog launcher that provide additional options.
FILE TAB
File tab displays the backstage view of workbook and it contains all the tools needed for managing files such as opening, saving, exporting, printing, sharing and closing files.
COLLAPSE & UNCOLLASE RIBBON
The ribbon provides the option of collapsing it by double click on any of the tab. These enables viewing the worksheet more broadly. To bring back the ribbon, double click on any of the tab. Refer to the caption below for collapsed ribbon
QUICK ACCESS TOOLBAR
There are set of small toolbars above the ribbon quick access tool bar. It contains commands, save, undo and redo. In addition, the little dropdown on the right contains tools such as spelling, sorting, email, save, open etc. The Sorting command (ascending or descending) is very useful in sorting data.
