Advanced Excel
  • Introduction to Excel
  • Security
  • Short Keys
  • Practice Data Sheets
  • Data Formats
  • Conditional Formatting
  • Format as Table
  • Data Sorting
  • Data Filtering
  • Remove Duplicates
  • Data Validation
  • Text-To-Columns
  • Data Consolidation
  • What-if-Analysis
  • Grouping
  • Absolute & Relative Referencing
  • Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average
  • Task1 - Mathematical Formulas
  • Logical Functions - IF, IFERROR, AND, OR
  • Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
  • Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace
  • Vlookup Formula
  • Task2 - Vlookup Problems
  • Vlookup with Match Formula - Dynamic Duo
  • Vlookup using (*) example
  • Vlookup with Running Countif
  • Task3 - Vlookup, Running Countif Problem
  • Lookup Functions - Hlookup, Index Match
  • Lookup Functions - Indirect, Offset
  • Vlookup-Indirect Example
  • Sumif, Indirect, Offset, Match Example
  • Array Functions
  • Task4 - Array Problem
  • Advanced Conditional Formatting using Formula
  • Data Validation using Indirect Function
  • Charts, Waterfall Graph
  • Pivot Table, Dashboards
Powered by GitBook
On this page

Was this helpful?

Grouping

PreviousWhat-if-AnalysisNextAbsolute & Relative Referencing

Last updated 6 years ago

Was this helpful?

Grouping

Worksheets with a lot of content can sometimes feel overwhelming and even become difficult to read. Fortunately, Excel can organize data in groups, allowing you to easily show and hide different sections of your worksheet. You can also summarize different groups using the Subtotal command and create an outline for your worksheet

Short Keys --> Alt + A + G

15KB
Grouping.xlsx
Examples of Grouping, Ungrouping