Useful functions: Includes applicability of important functions such as AND IF OR (logical functions), Paste Special, COUNT functions, MIN MAX ABS (arithmetic functions).MS Excel 2007 vs 2010: This segment covers the key differences between the two versions of Excel.Shortcuts: Coverage of various interesting shortcuts one may use.Excel functions: Important functions such as IF, SUMIF, COUNTIF, Sort and Filter, Graphs and Charts, Split and Freeze will be explained.Pivot tables: Explanation about the pivot tables and their usage in different scenarios.Percentage absolute references: Insight about percentage calculations, absolute referencing and normal referencing.The application of various aspects of conditional formatting will be covered. Conditional formatting: It means formatting based on conditions provided by the user.Basic formulas: Application of basic formulas such as sum, average, minimum, maximum.Data population: Explanation as to how the data involved in the case study can be inputted in an Excel spreadsheet.Excel case study: Basic functions of Excel will be taught by way of an interesting case study.Further, the program is divided into two sub-parts namely Basic Excel and Advanced Excel.The program will make an effort to explain the usage of pivot tables and pivot charts in different situations. It is a summarized table or a chart of a detailed data table. Pivot tables and pivot charts: A pivot table or a pivot chart is drawn from the data that is contained in an existing spreadsheet.The learner will learn about various such features regarding data tables. Excel data table feature: There are several features available in Excel that enables a user to efficiently work in the data table.The program will provide a learner insight concerning formatting options as well as printing procedures. Formatting and printing worksheets: Excel contains various formatting options.The program will cover the development of powerful graphs and charts. Graphs and Charts: Data is better understood when expressed through graphs and charts as the same is easier to interpret and draw meaningful conclusions.Formulas: Basic as well as advanced formulas will help the learner to apply such formulas for calculations in their practical lives.New features: A learner will gain knowledge about new features offered by Excel.The course will enable a learner to have a better understanding of the following areas of Excel. There are 15 courses available on “Excel for Finance Training” with more than 7 projects, divided into a time frame of about 78 hours. These link can be included in your resume/Linkedin profile to showcase your enhanced skills Yes, you get verifiable certificates for each course with a unique link. Microsoft Excel, Charts & Graphs, Power Excel, Financial Functions In Excel, Microsoft Excel for Financial Analysis, Power Pivot, Excel Simulations, Excel ReportsĪnyone serious about learning Excel for financeĬertificate of Completion for each of the 17 courses, 7 Projects You do not need to purchase each course separately. You get access to all the 17 courses, 7 Projects. Project on VBA - Financial Modeling using VBA Project - Building Dynamic Heat Map in Microsoft Excel 2016 Pivot Table Case Study - Performance Ratings of Employees Pivot Table Project - Problem Handling and Automation Project - Microsoft Excel Simulations Trainingįinancial Functions In Excel - Microsoft Excel 2013 Course Microsoft Excel Charts and SmartArt GraphicsĪdvanced Excel 2016 - Some Important Featuresĭate and Time Functions Microsoft Excel Training