SERVICES

  • Reviews

  • Free Videos

  • Know Your Trainer

  • Sample Certificate

  • Download Brouchers

  • Course Content

  • 17 lectures

  • 20h Duration

  • Understanding & Customization of Quick Access Bar
  • Understanding & Customization of Ribbon
  • Row, Column, Cell & Cell Content
  • Formula bar & Function Library
  • Name Box / Address Bar
  • Understanding of File Extensions & It's usage

  • Saving & Sharing workbook
  • Protect Workbook
  • Inspect Workbook
  • Export workbook to another extension

  • Mathematical Operations
  • Basic Formulas (Min, Max, Average, Count, CountA, CountBlank etc.,)
  • Text Functions (Mainly used for data cleaning)
  • When to use MMC, LMC and RFS modifier in design (correct applications)
  • Date & Time Functions

  • What is Cell Reference
  • What is Range Reference
  • Cell Reference Style
  • Types of Cell Reference & It's uses

  • What is Sorting & purpose of using Sorting
  • Sorting & Advance Sorting Options (Vertical, Horizontal, Custom list & Multi Level Sorting)
  • What is Filtering & purpose of using Filtering
  • Filtering & Advanced Filtering Options
  • (Alphabetical, Numeric, Custom, Color)

  • Highlight Cell Rule
  • Top / Bottom Rule (www.statmodeller.com +91 98982 33268ceo@statmodeller.com
  • Data Bar, Color Scale, Icon Set
  • Custom Conditional Formatting

  • Text to Columns
  • Flash Fill (MS AI Tool)
  • Remove Duplicates
  • Data Validation
  • Data Consolidation

  • What-If Analysis
  • Goal-Seek
  • Scenario Manager
  • Data Table
  • Forecast Sheet

  • Aggregating values with condition(s). (SUMIF/ SUMIFS, COUNTIF/ COUNTIFS, AVERAGE/ AVERAGEIFS)
  • Nesting formulas for dynamic result
  • Large/Small (Indexing Values)
  • Row/Column (Support Functions for easy reporting)
  • Choose, Switch (Sometimes alternative to IF)
  • Transpose, Filter, Sort

  • Vlookup, Hlookup, 2 Way Lookup, Partial Lookup
  • Index, Match
  • XLookup, Xmatch

  • Excel Table (Creating, Modifying & exploring)
  • Adding, using & modifying Slicers & Time-line
  • Data Summarization through Pivot Table

  • Combo Box (Advanced Drop-down)
  • Spin Button (Switching between values)
  • Check Box (Show/Hide Data/Objects/chart series etc.,)
  • Scroll Bar (Display large data into small space)
  • Option Button (Switch between different option)
  • List Box (Select items to display data/objects/chart series etc.,)

  • Introduction to Excel Charts & Graphics
  • Different types of Excel Charts (Column Charts, Bar Charts, Line/ Area Chart, Pie Chart, Scatter Plot, Bubble Plot etc...) www.statmodeller.com +91 98982 33268 ceo@statmodeller.com

  • Advanced Stake Column Chart
  • Chart modification using Error Bar
  • Dynamic chart using naming series
  • Sunburst Chart, Treemap
  • Geo Map
  • Combo Charts
  • Statistical Charts (Histogram, Pareto Chart, Boxplot)

  • What is Dashboard
  • Overview on types of Dashboards
  • Benefits of using Dashboard
  • Things to consider before building Dashboard
  • How to create Dynamic Dashboard in Excel
  • Use Case #1 - Sales Dashboard
  • Use Case #2 - Financial Dashboard

  • ChatGPT Excel Formula Writing
  • ChatGPT Excel Formula Explanation
  • ChatGPT Excel Formula Examples with Data
  • ChatGPT Excel Formula Debugging

  • Project #1 - Manufacturing Dashboard
  • Project #2 - HR Dashboard
Static Equipment Design Training Combo By Express Engineering Solutions

This Course Includes:

  • 20 hours on-demand videos
  • Expret-Curated Content
  • Live Q&N Session
  • Certificate of completion
Loading similar courses...

TRAINING