1 / 5

Advanced Data Modelling and Analytics Using Excel Training

The Advanced Data Modelling and Analytics Using Excel training offered by Multisoft Systems is designed to equip professionals with the skills to perform complex data analysis and build robust data models directly in Microsoft Excel.

multisoftsystem
Download Presentation

Advanced Data Modelling and Analytics Using Excel Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced Data Modelling and Analytics Using Excel Training info@multisoftsystems.comwww.multisoftsystems.com (+91) 9810-306-956

  2. About Multisoft Train yourself with the best and develop valuable in-demand skills with Multisoft Systems. A leading certification training provider, Multisoft collaborates with top technologies to bring world-class one-on-one and certification trainings. With the goal to empower professionals and business across the globe, we offer more than 1500 training courses, which are delivered by Multisoft’s global subject matter experts. We offer tailored corporate training; project Based Training, comprehensive learning solution with lifetime e-learning access, after training support and globally recognized training certificates. About Course The Advanced Data Modelling and Analytics Using Excel training offered by Multisoft Systems is designed to equip professionals with the skills to perform complex data analysis and build robust data models directly in Microsoft Excel. info@multisoftsystems.comwww.multisoftsystems.com (+91) 9810-306-956

  3. Module 1: Introduction to Excel Environment ✓Cell referencing, cell formatting and entering formula ✓Variables in Excel ✓Introduction to Excel Tables ✓Filtering data ✓Sorting data ✓Use of conditional formatting Module 2: Integrating Excel with Other Data Sources, Software and Platforms ✓Link with Google Sheets, ✓Link with SharePoint Lists ✓Link with Mobile Data Collection Tools ✓Link with Databases (Postgres, Oracle, SQL) ✓Link with CRMs Module 3: Data Cleaning and Transformation Using Power Query ✓Use first Row as Columns ✓Rename Columns ✓Replace Cell Data & Missing Values ✓Remove Rows & Columns ✓Data Types ✓Auto IDs ✓Find Duplicates ✓Combine & Split Multiple Fields ✓Custom Formatting (Currency, Phone numbers) ✓Group Data with Merge & Append Queries info@multisoftsystems.comwww.multisoftsystems.com (+91) 9810-306-956

  4. Module 4: Advanced Excel Formula and Functions ✓Conditional Functions ✓Lookup Functions ✓Text Functions ✓Date Time Functions Module 5: Data Modelling Using Excel Power Pivot ✓Activate Excel Power Pivot ✓Add Data to the Data Model ✓Create Relationships Between Tables ✓Create Pivot Tables Using Data Models Module 6: Advanced Pivot Tables ✓Data Refresh-Configure self-updating dynamic Pivot tables and Pivot charts ✓Rank in pivot table ✓Pivot Table Calculated Field ✓Link multiple Pivot tables to one slicer ✓Running Total in pivot table ✓Create Many Pivot Tables from one ✓Export Pivot Table to PowerPoint & Word Module 7: Build Interactive Dashboards Tools/instruments on excel ✓Interactive Dynamic Dashboards, ✓MIS tools ✓Custom Page Navigation using Links ✓Custom filters using Slicers and timeline ✓Configure Advanced Custom Charts & KPIs ✓Configure Custom Pictographs in excel info@multisoftsystems.comwww.multisoftsystems.com (+91) 9810-306-956

  5. ✓Configure Dynamic thermometer with dynamic colors ✓Dynamic Chart Titles in Excel ✓Share Excel Data and Reports to Power point, Share point, Power BI ✓Case Study info@multisoftsystems.comwww.multisoftsystems.com (+91) 9810-306-956

More Related