Smadi M - Microsoft Excel Trining: Make Excel work for you

Microsoft Excel Trining: Make Excel work for you — 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 "Microsoft Excel Trining: Make Excel work for you" 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

1234567...22

Table of contents

Excel Shortcuts for PC and Mac
Editing Shortcuts
Formatting Shortcuts
Navigation Shortcuts
File Shortcuts
Ribbon Shortcuts
Paste Special Shortcuts
Clear Shortcuts
Selection Shortcuts
Data Editing Shortcuts
Data editing (inside cell) Shortcuts
Other Shortcuts
Reasons to use Excel Shortcuts
Free Excel Course

Basic Excel Formulas
Basic Terms in Excel
Five Time-saving Ways to Insert Data in Excel
SevenBasic Excel FormulasForYour Workflow

Advanced Excel Formulas
INDEX MATCH
IF combined with AND / OR
OFFSET combined with SUM or AVERAGE
CHOOSE
XNPV and XIRR
SUMIF and COUNTIF
PMT and IPMT
LEN and TRIM
CONCATENATE
CELL, LEFT, MID and RIGHT functions

Most Useful Excel function For Financial Modeling
Date and Time
40 DATE
EOMONTH
TODAY
YEAR
YEARFRAC
Financial
60 DURATION
NPV
PMT
PPMT
XIRR
XNPV
YIELD
Information
88 ERROR.TYPE
ISBLANK
Logical
94 AND
IF
IFERROR
IFS
OR
CHOOSE
HLOOKUP
INDEX
MATCH
OFFSET
VLOOKUP
Math
157 ABS
SUMIF
Statistical
166 AVERAGE
CORREL
COUNT
COUNTA
COUNTIF
RANK
SMALL

MsmadiInstitute Excel PART 01

Excel Shortcutsfor PC and Mac

List of Excel Shortcuts

PC shortcuts & Mac shortcuts

Editing shortcuts Formatting shortcuts Navigation shortcuts File Shortcuts
Ribbon Shortcuts
Paste Special Shortcuts
Clear Shortcuts
Selection Shortcuts
Data Editing Shortcuts
Data Editing (inside cell) Shortcuts
Other Shortcuts
Reasons to use Excel Shortcuts

Tobemoreproductive,faster,and moreefficient whenbuildingfinancial models or performing financial analysisits important to know the main keyboard shortcuts in Excel. These are critical for careers in investment banking, equity research, FP&A, finance, accounting, and more.

The first thingyoull do ifyoure hired as an investment banking analyst is take a series of intense Excel training . Your mouse willbe taken awayand youll be expected to learn financial modeling with only keyboard shortcuts. If you follow our tips and tricks below youll be able to master these shortcuts on Windows or Mac operating systems.

MsmadiInstitute Financial Service Excel PART 02

Basic Excel Formulas

Basic Excel Formulas Guide

Mastering the basic Excel formulasis critical for beginners to become highly proficient in financial analysis. Microsoft Excel is considered the industry standard piece of software in data analysis. Microsofts spreadsheet program also happens to be one of the most preferred software by investment bankers and financial analyst in data processing, financial modeling , and presentation. This guide will provide an overview and list of basic Excel functions. Once youve mastered this list, move on to advanced Excel formulas guide !

Basic Terms in Excel

1. Formulas

In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to Cell A3.

2. Functions

Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names. For example: =SUM(A1:A3). The function sums all the values from A1 to A3.

Five Time-saving Ways to Insert Data into Excel

When analyzing data, there are five common ways of inserting basic Excel formulas. Each strategy, however, comes with an advantage over the other. Therefore, before diving further into the main formulas,well clarify those methods, so you can create your preferred workflow earlier on.

1. Simple insertion: Typing a formula inside the cell

Typing a formula in a cell or the formula bar is the most straightforward method of inserting basic Excel formulas. The process usually starts by typing an equal sign, followed by the name of the function.

Excel isquite intelligentin thatwhen you start typing the nameofthe function, apop-up functionhintwill show.Itsfromthislistyoullselect yourpreference. However,dont press the Enter key. Instead, press the Tab key so that you can continuetoinsertotheroptions.Otherwise,youmayfindyourselfwithan invalid name error, often as#NAME?. To fix it, justre-select the cell, and go to the formula bar to complete your function.

Note that pressing F2 while hovered over a cell allows you to edit the cells formula.
2. Using Insert Function Option from FormulasTab

Ifyouwantfullcontrolofyourfunctionsinsertion, usingthe ExcelInsert Function dialogue box is all you everneed. To achieve this,go to the Formulas tab and select the first menu labeled Insert Function. The dialogue box will contain all functions you need to complete your analysis.

The Excel shortcut to insert a function is ALT + M + F.
3. Selecting a Formula from One of the Groups in Formula Tab

The option is for those who want to delve into their favorite functions quickly. Tofindthis menu,navigatetothe Formulastabandselect your preferred group. Click to show sub-menu filled with a list of functions. From there, you can select your preference. However, if you find your preferred group is not on the tab, click on the More Functions option probablyits just hidden there.

Next page

1234567...22

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «Microsoft Excel Trining: Make Excel work for you»

Look at similar books to Microsoft Excel Trining: Make Excel work for you. 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.

24 Excel MVPs

Excel Insights: A Microsoft MVP guide to the best parts of Excel

Abbey

MY EXCEL GUIDE; Beginners, Intermediate, Advanced : Microsoft Excel

Daniel Reyes

Excel 2021: The Step-by-Step Guide To Make You An Excel Master

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)

Noreen Brown

Beginning Excel 2019

Sheikh

Microsoft Excel Advanced Functions and Formulas

Baddey

EXCEL 2020 EXPLAINED: A Well-Explained Guide to Master Microsoft Excel Functions and Formulas from Beginner to Expert Level

Korol

Microsoft Excel 2016: programming by example: with VBA, XML and ASP

Jelen

Learn Excel 2007 from Mr Excel: 377 Excel mysteries solved

Melnyk

Excel VBA: Step by Step Guide to Learn Excel VBA Programming with Screenshots and Example Code

Griffiths

Microsoft Excel Essential Hints and Tips: Fundamental hints and tips to kick start your Excel skills

Discussion, reviews of the book Microsoft Excel Trining: Make Excel work for you 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.