Excel for Data Analysis & Financial Analysis
- Description
- Curriculum
- FAQ
- Reviews
Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. Analysing Financial Data with Excel shows you how to solve real-world business problems by taking Excel’s financial analysis features to the maximum, rather than focusing on individual Excel functions and features. Learn all the tips, tricks, shortcuts, functions and formulas you need to perform professional financial analysis and financial modeling. We cover all levels – from basic to advanced users. This training is ideally suited for students, home-makers and professionals – essentially anybody with a need for spreadsheet skills.
Microsoft estimates that a staggering 5 million users utilize at least one Office product, with Word and Excel being the most popular of their products. You can build a strong foundation in Excel for careers in Financial Modeling, Equity research, Investment banking, Private equity, Financial Planning & Analysis, Corporate development. Also, this course is beneficial to a large spectrum of people, including Administrative staff, Secretaries and Personal Assistants, Retail Professionals, Store Supervisors, Business Analysts, Data-mining experts, Accountants, Project Managers, Marketing and Sales professionals and Investment Bankers.
This course helps you develop a thorough understanding of Excel’s extensive Chart/Graph features. With this, you’re exposed to the best ways to capitalize on your data, and illustrate their value for maximum effect.
-
1Accessing MS ExcelVideo lesson
-
2MS Excel Startup ScreenVideo lesson
-
3Understanding the RibbonVideo lesson
-
4Cells in ExcelVideo lesson
-
5Worksheet EssentialsVideo lesson
-
6Saving the FileVideo lesson
-
7Formatting CellsVideo lesson
-
8Custom Cell StylesVideo lesson
-
9Custom Number Formatting in ExcelVideo lesson
-
10More on Custom Number FormattingVideo lesson
-
11Custom Formats of DataVideo lesson
-
12The BEDMAS Order of Mathematical OperationsVideo lesson
-
13Mathematical Operations without FunctionsVideo lesson
-
14Mathematical Operations without Functions ContinuedVideo lesson
-
15IF FunctionVideo lesson
-
16More on IF FunctionVideo lesson
-
17Importing Data and CalculationsVideo lesson
-
18Working with the Count FunctionVideo lesson
-
19Conditional Counts - CountIF FunctionVideo lesson
-
20Working with the Sum FunctionVideo lesson
-
21Finding the AverageVideo lesson
-
22Conditional Average - Average IFS FunctionVideo lesson
-
23Finding the Maximum Value Using the MAX FunctionVideo lesson
-
24Finding the Minimum Value Using the MINFS FunctionVideo lesson
-
25Determining Proportions and Updating a CalculationVideo lesson
-
26Conditional FormattingVideo lesson
-
27More on Conditional FormattingVideo lesson
-
28Working with TablesVideo lesson
-
29Formatting TableVideo lesson
-
30Filtering and Sorting of DataVideo lesson
-
31Freeze and SplitVideo lesson
-
32Printing and Layouts in ExcelVideo lesson
-
43Logical Function - IFVideo lesson
-
44AND OR and XOR FunctionsVideo lesson
-
45IFS Function - Example 1Video lesson
-
46IFS Function - Example 2Video lesson
-
47SWITCH FunctionVideo lesson
-
48Other Logical FunctionsVideo lesson
-
49Information Functions - ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXTVideo lesson
-
50Date Functions - TODAY DAYVideo lesson
-
51MONTH YEAR WEEKDAY WEEKNUM FunctionsVideo lesson
-
52EDATE and EOMONTH FunctionsVideo lesson
-
53YEARFRAC FunctionVideo lesson
-
54Joining Data using CONCAT and TEXTJOINVideo lesson
-
55LEN FIND LEFT RIGHT TRIMVideo lesson
-
56Using UNIQUE and TRANSPOSEVideo lesson
-
57TEXT FunctionVideo lesson
-
58CHOOSE FunctionVideo lesson
-
59More on CHOOSE FunctionVideo lesson
External Links May Contain Affiliate Links read more