We will provide you dummy data for your practise Assignments through which you can judge to yourself, Interview preparation question, platform where you can discuss you excel related queries/Job openings.Android Application to learn VBA - Macro through Videos.Creating multiple sheets in a single click using Pivot.Consolidating multiple sheets in less than a minute.Creating dynamic Dashboards using Slicer.Prevent wrong Decisions using Excel Tables.Complex calculation based Data Validation.Calculation based conditional formatting.

Highlight single colour with multiple conditions.Highlight above average, max, min, errors etc.Highlighting top records, bottom records.Highlighting duplicates in various ways.Conditional formatting using formulas and cell values.Connection between Tables (Referential Integrity).Backstage information regarding to files.Reporting with Power pivot: Creating powerful reports with Power Pivot ◉ Hierarchies, Perspectives and Sets Power pivot: The Excel 20 Power Pivot add-in ◉ Power Pivot data tools Working with External Data: Getting at your data using the Get External Data tools ◉ Understand relational database◉ Excel 2013 Data Model create relationships within ExcelĪdvanced Uses of Pivot tables: Use advanced pivot table techniques to do more with your data ◉ Calculated Fields and Calculated items ◉ Using pivot tables as the calculation engine behind management Excel 20 Slicers and Timelines - make your pivot tables more interactive ◉ Working with Pivot Charts ◉ Building and interactive dashboard using pivot tables and Slicers Sparkline: In-cell charts - showing 12 times as much information in the same amount of space ◉ Careful with that Axis ◉ The different types of Sparkline: lines, columns and win loss ◉ Sparkline based on a dynamic data range WHAT IF? :Using Excel to help you make decisions ◉ Use Goal Seek to find where you need to start to get where you need to go ◉ Use an Excel Data Table to calculate dozens of possible outcomes ◉ Create and manage alternative scenarios ◉ Make more profit or incur less expense by using Excel Solver to identify the best solution With this Programme you will able to learn various important aspects of Excel like Conditional Formatting, Validation, Pivot Table, Chart, Advance Filtering, Smart Art, Themes, Formula Auditing, Extraction data from Different Sources, Web Queries, Goal Seek, Solver, Table, Connections, Protection on different level and lots more.ĭetailed Contents: Conditional Formatting: Beyond Simple Conditional Formatsĭata Validation: Extended Uses of Data Validation ◉ working with Validation Formulae ◉ Lists and Lists That Depend on Other List Selections ◉ Other Methods of Tracking down Invalid Entries Shortcuts and tips will able to help you in your day to day routine work. With the help of this programme you would be able to manage data in your respective company.

Excel solver function in vba 2013