You're reading from Hands-On Financial Modeling with Microsoft Excel 2019

Product typeBook

Published inJul 2019

PublisherPackt

ISBN-139781789534627

Edition1st Edition

Tools

Excel

Concepts

Financial Technology

Author (1)

Shmuel Oluwa

Section 2: The Use of Excel - Features and Functions for Financial Modeling

In this section, you will learn about the various tools and features of Excel that are regularly used in financial modeling. These will be explained in detail to allow you to start using them confidently.

This section comprises the following chapters:

Chapter 3, Formulas and Functions – Completing Modeling Tasks with a Single Formula
Chapter 4, Applying the Referencing Framework in Excel

The rest of the chapter is locked

You have been reading a chapter from

Hands-On Financial Modeling with Microsoft Excel 2019

Published in: Jul 2019Publisher: PacktISBN-13: 9781789534627

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

undefined

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime

Author (1)

Shmuel Oluwa

Shmuel Oluwa is a financial executive and seasoned instructor, of over 25 years, in a number of finance related fields, with a passion for imparting knowledge. He has developed considerable skill in the use of Microsoft Excel and has organised training courses in Business Excel, Financial Modeling with Excel, Forensics and Fraud Detection with Excel, Excel as an Investigative Tool, Accounting for Non-Accountants, Credit Analysis with Excel amongst others. He has given classes in Nigeria, Angola, Kenya and Tanzania but his online community of students covers several continents. Shmuel divides his time between London and Lagos with his pharmacist wife. He is fluent in 3 languages. English, Yoruba and Hebrew.
Read more about Shmuel Oluwa

Other recommended products

Related to this chapter

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

BookMay 2020794 pages

Building Dashboards with Microsoft Dynamics GP 2016

The book shows you in detail how to build great-looking dashboards with Microsoft Dynamics GP. It will take you from creating amazing dashboards using various tools such as Excel 2016, Power BI to Jet Express. We will also cover core topics such as Business Analyzer, Microsoft SQL Reporting services reports, BI360, and more.

BookMar 2017354 pages

Hands-On Artificial Intelligence for Banking

Hands-On Artificial Intelligence for Banking is a must-have guide for AI developers and machine learning experts looking to build intelligent finance-based applications. This guide will give its readers a complete overview of the global banking business with the help of interesting use-cases, and their implementation using popular Python libraries.

BookJul 2020240 pages

Microsoft Dynamics 365 Enterprise Edition - Financial Management

Microsoft Dynamics 365 for finance and operations is a rapidly growing application and is widely used in enterprise organizations. Because of its ability to maximize business productivity, it is a fast-growing business application package in the ERP market.

BookMar 2018562 pages

Odoo 10 Implementation Cookbook

Odoo is a Python-based ERP system and is completely open source. Odoo is a comprehensive suite of business applications offering a wealth of functionalities that can be deployed to meet your business needs.

BookOct 2017806 pages

Python for Finance

Python is a free and powerful tool used for quantitative finance and is a popular choice amongst many financial analysts. This book will teach you the basics of quantitative finance, and how they can be implemented by making use of the various Python libraries and modules.This book introduces you to the basic concepts and operations related to Python and teaches you how to work with the various Python libraries like NumPy, Scipy, Matplotlib, and Pandas for quantitative analysis. You will work with time-series data, and implement concepts like stochastics for Monte-Carlo simulation, hedging, derivatives, portfolio optimization and more.This book is a hands-on guide with easy-to-follow examples to help you learn about option theory, quantitative finance, financial modeling, and time series using Python.

BookJun 2017586 pages

Mastering QuickBooks 2020

QuickBooks is a bookkeeping software for finance professionals to manage business accounting demands and reports. This book will help you build the perfect budget, simplify tax return preparation, manage inventory, track job costs, generate income statements and financial reports, and every other accounting-related task crossing your desk at work.

BookDec 2019332 pages

Mastering QuickBooks 2021

QuickBooks is a bookkeeping software for managing business accounting demands and reports. With this book, you’ll be able to use QuickBooks Online to build the perfect budget, simplify tax return preparation, manage inventory, track job costs, generate income statements and financial reports, and perform all accounting-related tasks with ease.

BookJan 2021414 pages

Hands-On Machine Learning with Microsoft Excel 2019

Machine learning has become a core necessity for every business and organization. With this book, you will learn to analyze your Excel data to search for patterns and return a series of interesting facts or trends about the data. You will learn to perform machine learning tasks using Excel plugins and APIs without much code required.

BookApr 2019254 pages

Personalised recommendations for you

Based on your interests and search pattern

Et al.

Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.

BookAug 2023230 pages5

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages4

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages5

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages1

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages5

Mastering Tableau 2023

This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.

BookAug 2023684 pages

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

BookSep 2023258 pages5

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

BookSep 2023258 pages2

Data Engineering with AWS

Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.

BookOct 2023636 pages5

Modern Data Architecture on AWS

Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.

BookAug 2023420 pages5

Practical Guide to Applied Conformal Prediction in Python

Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.

BookDec 2023240 pages

TinyML Cookbook

With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.

BookNov 2023664 pages