Duncan McKeen – CFI Education – Excel Fundamentals – Quick Start Guide

1,500

Description

Duncan McKeen – CFI Education – Excel Fundamentals – Quick Start Guide download, Duncan McKeen – CFI Education – Excel Fundamentals – Quick Start Guide review,Duncan McKeen – CFI Education – Excel Fundamentals – Quick Start Guide free
Duncan McKeen – CFI Education – Excel Fundamentals – Quick Start Guide
Excel Fundamentals – Quick Start Guide
In CFI’s “Excel Fundamentals – Quick Start Guide” course, you will learn all the basics of Excel 365, including set-up, layout, shortcuts, and the functions you need to be more productive and efficient in your finance role.
Overview
Excel Fundamentals – Quick Start Guide Course Overview
Having strong Excel skills is critical for any job involving financial analysis or financial modeling. CFI’s “Excel Fundamentals – Quick Start Guide” course is designed specifically for Excel users who are looking to prepare for a career in finance or are already performing professional financial analysis and financial modeling. This course will review the basics of Excel 365, such as the layout and tools and functions. You will also learn how to effectively use keyboard shortcuts to increase your overall productivity.
Excel Fundamentals – Quick Start Guide  Learning Objectives
Upon completing this course, you will be able to:

Identify the main parts of the Excel 365 interface and their purpose.
Explain the advantage of using the keyboard and memorize basic shortcuts.
Recommend Excel settings which are helpful for finance professionals.
Setup the Quick Access Toolbar to improve speed and efficiency.
Explain the most common Excel features used for financial analysis.
Recommend more advanced Excel features used in the finance industry.

Who Should Take This Course?
This course is perfect for beginners, intermediate, and even advanced financial professional Excel users.  The course starts off with the basics, but quickly advances so even more proficient users will learn something new and have a great refresher.
What you’ll learn
Course Introduction

Introduction

Downloadable File

Learning Objectives

Instructor Biography

Keyboard Over the Mouse
Excel Layout

Downloadable Files

Layout Overview

Creating Formulas

Ribbon Home Section

Ribbon Insert Section

Other Sections

Keyboard Shortcuts

Interactive Exercise 1
Excel Settings

Settings Overview

General Settings

Formula Settings

Other Settings

Advanced Settings

Customize Ribbon

Quick Access Toolbar

Add Ins

Interactive Exercise 2
Basic Financial Setup

Objectives

Template Tour

Global Units

Border Control

Headings and Widths

Number Formats

AutoSum and Font Color

Adding Indents

Actual Calculations

Estimate Assumptions

Future Formulas

Interactive Exercise 3
Advanced Financial Setup

Freezing Panes

Create Section

Naming Cells

EBITDA Limit

Conditional Formatting

Dynamic Labels

Common Size

Percent Setup

Interactive Exercise 4

Percent Change

Navigational Column

Formula Auditing

Row Grouping

Print Settings

Print Preview

Interactive Exercise 5
Course Summary

Downloadable File

Summary

Qualified Assessment

63
    63
    Your Cart
    Matt Furey – The Zero Resistance Living System Remove
    Michele Bogliardi – Solo Spread Remove
    Michele Bogliardi – Solo Spread
    1 X 5,810 = 5,810
    The Ultimate Guide to Ecom Mastery (2023) Remove
    Emily Gowor – Publishing Success Program Remove
    I3t3 price action Course Paid-Premium Remove
    Get 1000+ Ai Avatar Readymade Reel Videos Remove
    Jacob Caris – Dream Car Profits Remove
    Landing Page Copywriting Mastery By Jeremy Moser Remove
    Benjamin Fairbourne – Done For You System Remove
    Brian Moran – 1-Page Funnel Master Class Remove
    Hindustan Stock Market Academy Remove
    Hindustan Stock Market Academy
    3 X 199 = 597
    ChatGPT Mastery Course (2023) Remove
    ChatGPT Mastery Course (2023)
    5 X 350 = 1,750
    George Hutton – Frame Control Remove
    The Online Only Agency Advanced by Ben Adkins Remove
    Oliver Velez – Core Trading Tactics Remove
    Ivan Mana – Conversion Tracking Mastery Remove
    Smart Google Traffic (2023) Remove
    Smart Google Traffic (2023)
    2 X 150 = 300
    A to Z SL Hunting Course Remove
    A to Z SL Hunting Course
    1 X 400 = 400
    Big Bar Strategy by Stock Burner Remove
    Big Bar Strategy by Stock Burner
    1 X 400 = 400
    Chad Kimball – Advanced YouTube Blackhat Course Remove
    Alex Becker – Hero Tower Remove
    Alex Becker – Hero Tower
    1 X 4,000 = 4,000
    Jon Sinn – Automatic Approching Remove
    Matan Feldman – Excel Crash Course Remove
    Brooke Lee – 7 Day Good Morning Yoga Remove
    Brooke Lee – 7 Day Good Morning Yoga
    1 X 4,000 = 4,000
    Boomerang Day Trader (Sep 2014) Remove
    Boomerang Day Trader (Sep 2014)
    1 X 4,000 = 4,000
    Alexander Leonidas – Naturally Enhanced Remove
    Youtube Seo Secrets 2023 (2023) Remove
    Youtube Seo Secrets 2023 (2023)
    1 X 350 = 350
    Heal Your Gut Summit 2016 Remove
    Heal Your Gut Summit 2016
    1 X 4,000 = 4,000
    JeaFX : SMC PREMIUM COURSE Remove
    JeaFX : SMC PREMIUM COURSE
    1 X 149 = 149
    Buried Treasure Trading System (Audio 168 MB) Remove
    Mobile Marketing Masterclass 2023 Remove
    Mobile Marketing Masterclass 2023
    1 X 297 = 297
    Adam Payne – The Affiliate Oracle Remove
    Adam Payne – The Affiliate Oracle
    1 X 4,000 = 4,000