Ibnalkadi - Short Introduction to MS Office Excel (The Complete MBA CourseWork Series)

Short Introduction to MS Office Excel (The Complete MBA CourseWork Series) — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Short Introduction to MS Office Excel (The Complete MBA CourseWork Series)" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

1234

The Complete MBA Coursework Series

Introduction to Excel

MY LORD, INCREASE MY KNOWLEDGE Noble Quran

A Tale of Two Brothers

Hicham and Mohamed Ibnalkadi

Contents

How to contact us

Preface

Motivation

This book is designed as a part of The Complete MBA Coursework Series, established to equip the professionals and students with the eminent capabilities and hone their skillset. The motivation behind this series is the need to establish a thorough and complete MBA coursework, following the core and elective courses of prestigious institutions like Wharton and Harvards Business Schools. With this self-motivated study of the MBA curriculum, students and professionals can tailor their MBA according to their interests and need. Thus, embarking on this self-study MBA coursework rather than a traditional, costly, and lengthy MBA degree program is worth the time.

MBA degree programs are very costly, although the skill boost associated is worth acquiring. Thus, as a part of the MBA coursework series, the following book helps the students learn the basic terminologies and techniques associated with Microsoft Excel Office tool. This book does not attempt to provide a self-contained discussion of Microsoft Excel. Instead is a decent introduction to Excel office needed as a skill in top MBA programs. Further, the introductory is stemmed from our professional experience. Finally, we want to thank Hina Aslam and Sara Aslam for providing us with many suggestions and valuable feedback on this book.

Prerequisites

No prerequisite is warranted. The emphasis throughout the book is on the understanding of basic terminologies and valid application of techniques onto the real data and problems.

Final few words

Thank you for buying this book, and feedback is highly appreciated for enhancing future versions. I hope that all readers gain something useful from this book and boost their knowledge of the tool that the author aimed at while writing it.

Although this book has been thoroughly checked and proofread, typos, errors, inconsistencies in notation, and instances where I have got it wrong are bound to sneak in. Any readers spotting such errors or addressing certain questions or comments are kindly requested to contact our customer service through this email ( ) before writing any review online. Finally, feel free to return the book and ask for a refund if unsatisfied.

A Tale of Two Brothers

Hicham and Mohamed Ibnalkadi

1. INTRODUCTION

Microsoft Excel is part of the Microsoft office tools and mainly used to record and analyze numerical data. An excel file is a collection of columns and rows that form a table. Further, Alphabetical letters represent columns while numbers represent rows. Furthermore, a cell is a point where a column and a row meet. Word documents can include tables and columns, but Excel makes laying out information easier. Although Excel looks intimidating at first, its layout is similar to other Microsoft Office applications. Finally, Excel defines multiple functions for designing formulas that automate calculations.

Cells can contain formulas, which should always start with an equal sign. Excel depicts the result of an equation in a cell with formula but automatically keeps that result up-to-date as you change its components.

Excel can make your working life more manageable. Some of the practical uses of Excel is as follows:

1. Excel has provided many features for easy usage. In Excel, the most fundamental ability is organizing data . Excel can create a list and gives the user the freedom to write in whichever cells.
2. To visualize data in a graph format, simply enter a range of data into Excel, and the program can automatically depict it. Excel provides multiple " Recommended Charts " that scan through the data and display the most relevant charts.
3. Excel features include functions that automate math formulas for multiple purposes, including bookkeeping, accounting, and statistics. Excel function arsenal includes SUM, adds other cells together, and has a one-button shortcut: the user selects a group of cells and press "Alt-Equals" to fill in the sum . Some functions analyze cells' contents and can even work with text. Calculate With Complex Formulas
4. Complex calculations include the string of multi-part formulas . Almost any set of functions can work together. For example, the user can add a column of cells and then round it to the nearest hundred by combining SUM with ROUND: =ROUND(SUM(A1: A5), -2) turns the sum of cells A1 through A5 to two places left of the decimal, resulting in around hundreds place.

The succeeding chapters will discuss some of the most popular functions in Excel.

1. VLOOKUP

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table to return the value in the same row in the index number position. The VLOOKUP function is built-in in Microsoft Excel and classified as a Lookup/Reference Function.

Exact Match

The user searches for an exact match of the value.

1. The VLOOKUP function below searches the value 12045 (first argument) in the leftmost column of the red table (second argument).

1. The third argument (4) in the VLOOKUP requests the function to return the value in the same row from the fourth column (Grade) of the range B3:E7 (result is 90).

Note: in contrast, the Boolean FALSE (the fourth argument) requests the VLOOKUP function to return an exact match of the value . in case the VLOOKUP function cannot find the value 12045 in the first column, #N/A error is returned.

Vlookup Looks Right

The VLOOKUP function retrieves a value in the first column of a table starting from the left and returns the value from a column to the right.

1. The following VLOOKUP function cheks the First Name and returns the Last Name.

1. For instance, if the user changes the third argument to 3, the VLOOKUP function looks up the first name and returns the Grade.

In this example, the VLOOKUP function unable to search the first name and return the ID. The VLOOKUP function can not look to the left of the given range.

1. INDEX MATCH

INDEX MATCH is an older brother of the much-used VLOOKUP; it allows you to lookup values in a table based on other rows and columns. Moreover, unlike VLOOKUP, it can be used on rows, columns, or both simultaneously.

INDEX MATCH is a better substitute to VLOOKUP entirely, and it is one of Excel's most powerful features.

Match Function

The MATCH function retrieves the position of a value in a given range. For instance, the MATCH function below looks up the value 12045 in the range B3:B7.

The first argument, 12045, is found at position 3. For an exact match, the third argument is set to 0.

Next page

1234

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «Short Introduction to MS Office Excel (The Complete MBA CourseWork Series)»

Look at similar books to Short Introduction to MS Office Excel (The Complete MBA CourseWork Series). We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.

Bill Jelen

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Steven Jones

Excel: The Complete User’s Guide To Microsoft Excel; How To Become An Excel Expert In No Time! (Excel, Microsoft Office, Excel Shortcuts)

Ibnalkadi

The Complete MBA Coursework Bundle 1-3 : Short introduction to MS Excel & Tips you must know about Word & Automate the boring tasks using VBA

Hicham and Mohamed Ibnalkadi

Introduction to Enterprise & Model Risk Management (701 Non-Fiction Book 4)

Ibnalkadi

Automate The Boring Tasks Using Microsoft Office VBA (The Complete MBA CourseWork Series)

Ibnalkadi

Tips You Must Know About MS Word (The Complete MBA CourseWork Series)

Ibnalkadi

100 Business Math Questions and Answers

Barresse Zack

Excel tables: a complete guide for creating, using and automating lists and tables

Dwight Spivey

Office for Mac 2011 Portable Genius

Peter Weverka

Office 365 All-in-One for Dummies

Fischer

Excel: QuickStart Guide - From Beginner to Expert (Excel, Microsoft Office)

John Walkenbach

Excel 2013 Power Programming with VBA

Discussion, reviews of the book Short Introduction to MS Office Excel (The Complete MBA CourseWork Series) and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.