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

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

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.