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?

Introduction to Excel

NextSecurity

Last updated 6 years ago

Was this helpful?

Excel History

Excel was released in 1987. During this period, data management was a huge challenge in industry. We know companies, banks, govt. offices used to maintain data either in big registers or files. Major problems related to data handling were:  Data Storage  Data Transfer  Calculations  Reports

To overcome this problem Excel became a very good solution in industry. Excel is similar to register or notebook. We have to look it very differently.

 Like in register, We used to prepare index like tabular form structure (rows & column). Similarly excel has rows & columns structure. Register can have Max Rows – 100 Max Col- 100 Excel can have Max Rows – 1048576 (As shown Below) Max Col - 16384 (XFD is the 16384th column in excel)

Like in Register we have multiple page (100, 200, 300) Similarly Excel we can have unlimited worksheet depending upon memory .  What is Workbook? Ans:- Workbook is a collection of one or more spreadsheets, also called worksheets, in a single file.  What is Worksheet? Ans:- A Worksheet is a collection of cells organized in rows and columns. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.