Sale!
Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE
Original price was: $23.$11Current price is: $11.
Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE
Product Delivery : You will receive a receipt with download link through email
Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE
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
Be the first to review “Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE”
Related products
Sale!
Business & Marketing
Original price was: $197.$25Current price is: $25.
Sale!
Business & Marketing
Original price was: $297.$49Current price is: $49.
Sale!
Business & Marketing
Original price was: $997.$68Current price is: $68.
Sale!
Business & Marketing
Original price was: $997.$75Current price is: $75.
Sale!
Business & Marketing
Matt Schmitt – Million Dollar Shopify Store Coaching Program
Original price was: $997.$85Current price is: $85.
Sale!
Business & Marketing
Original price was: $499.$50Current price is: $50.
Sale!
Business & Marketing
Bradley Chestnut – Ultimate Marketing Consultant Training Course
Original price was: $997.$85Current price is: $85.
Sale!
Business & Marketing
Original price was: $197.$20Current price is: $20.
20 reviews for Academy – EXCEL FOR FINANCE BEGINNER COURSE BUNDLE
There are no reviews yet.