-76%

Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE

Rated 4.00 out of 5 based on 1 customer rating

$12.00

Product Include:
File size:

Category: Forex Trading Courses Tag: Academy - EXCEL FOR FINANCE BEGINNER COURSE BUNDLE

Description
Reviews (1)

Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE

**More information:

Get Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE at Salaedu.com

Description

This product will available in 2-3 weeks later after you pay.

EXCEL FOR FINANCE BEGINNER COURSE BUNDLE

COURSE DESCRIPTIONTHIS ONLINE COURSE IS FOR BEGINNERS TO GET STARTED USING EXCEL TO FORMAT, CALCULATE AND MODEL DATA LIKE FINANCIAL PROFESSIONALS. YOU’LL

Benefit from expert advice, in simple language, from an accomplished financial analyst
Save hours every week by mastering keyboard shortcuts for formatting and navigation
Learn formatting best practices to share quality, easy-to-follow work with colleagues
Discover which Excel functions financial experts use daily (and which ones they don’t)
Create charts and dashboards to make financial info easily understood

COURSE CURRICULUM

WELCOME

Mac Shortcuts
Goal Setting
Welcome

NAVIGATION & DATA

Navigation and Data Workbook
Introduction to NAvigation & Data
A Glimpse into Your Life as an Excel Pro
Navigation, Arrow Keys, SHIFT & CTRL
Inserting & Editing Cells, Rows and Columns
Deleting Cells & Commenting
Freezing Rows & Splitting the Screen
Special Paste: Your New Best Friend
Sorting
Filtering
Conclusion to Navigation & Data

FORMATTING & STYLE

Formatting and Style Workbook
Introduction to Formatting & Style
Formatting Walkthrough
The Five Rules for Financial Modeling
Cell Dimensions
Styling Fundamentals
Styling Practice
Special Paste Review
Applying Special Paste to the Model
Best Practices for Number Formatting
Forward Multiples
Negative Numbers & Percentages
Go To Special
Grouping Data
Conclusion to Formatting & Style
Formatting and Styling Workbook (Answers)

FORMULAS & CONDITIONALS

Formulas and Conditionals Workbook
Introduction to Formulas & Conditionals
Best Practices for Formulas and Conditionals
Relative and Absolute Values Part 1
Relative and Absolute Values Part 2
Sum, Max, Min, Average
Median, Rank, Percentile, Bonus
Concatenation Part 1
Concatenation Part 2
IF
Asking IF Twice
Formula Error
AND
OR
SMALL
SUMIF
SUMPRODUCT
COUNT, COUNTA, COUNTIF
COUNTIFS
INDIRECT
INDEX
MATCH
INDEX and MATCH
Cell Color
Custom Formulas
Hidden Values
Test
Formulas and Conditionals Exercises
Conclusion to Formulas & Conditionals
Formulas and Conditionals (Answers)

CHARTS

Charts Workbook
Introduction to Charts
Best Practices for Charts
The Basics
Selecting Data In Column Cahrts
Customize Your Chart Part 1
Customize Your Chart Part 2
Line
Columns
Football Field Part 1
Football Field Part 2
Charts Exercises
Conclusion to Charts
Charts (Answers)

FOLLOW UP SURVEY

Follow up Survey

ABOUT THE INSTRUCTOR

DANIEL JASSY

CFADaniel Jassy, CFA, worked on idea generation, due diligence and modeling as a portfolio manager for a long-only equity fund. He attended the Charles W. Lamden School of Accountancy at San Diego State University. Daniel was awarded the Chartered Financial Analyst® designation in August of 2016 after passing levels I, II and III of the CFA ® exam. He currently designs and develops trading-analysis software, which provides an edge to portfolio managers by lowering execution costs.

1 review for Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE

Rated 4 out of 5

king – August 12, 2020

We encourage you to check Content Proof carefully before paying.“Excepted” these contents: “Online coaching, Software, Facebook group, Skype and Email support from Author.”If you have enough money and feel good. We encourage you to buy this product from the original Author to get full other “Excepted” contents from them.Thank you!