Tutorials
Microsoft Excel 2007
----Beginner
01. Introduction to Microsoft Excel 2007 and its components
02. 10 ways to move in a worksheet in MS Excel 2007
03. View more data in a worksheet
04. Move between worksheets and Open workbooks
05. Go to Cells quickly in Excel 2007
06. Select Cells Using Keyboard and Mouse
07. How to enter and delete data in MS Excel 2007
08. How to edit or modify a cell in Excel 2007
09. Wrapping or Merging the Text
10. Select Special Cells(Blanks, Visible Cells, Error Cells, Formula Cells, Commented Cells etc.)
11. Format Painter and "Paste Special"
12. Replace minus sign with parenthesis() and 0 with dash
13. Formatting Numbers with Criteria (Using Custom Formats)
14. Formatting Numbers with Criteria (Using Conditional Formatting)
15. How excel understands or treats date and time?
16. Entering and customizing Date & Time
----Intermediate
01. Entering Formulas
02. Absolute and Relative References
03. Preserving Relative References during Copy Formula
04. Using Name (What? Why? & How?)
05. Save formula for re use in name box
06. Dynamically define names
07. Sorting Horizontally and Vertically
08. Insert a line between groups of data after sorting
09. Repeating rows and columns at the top of each page (Sheet tab)
10. Hiding errors in formulas before printing
11. Printing the page numbers and running page number
12. Removing Duplicates in Excel 2007
13. Divide Text to Columns (Delimited or Fixed Width)
14. Apply color to MAX/MIN Values
15. Using Auto Filter
16. Using Advanced Filter
----Advanced
01. Share Workbook (Track Changes in History)
02. Importing and Refreshing Information from the Internet
03. Protecting Worksheets & Workbooks
04. Consolidating Data (with Formulas and Copy-Paste)
05. Consolidating Data Tables by Using a Pivot Table
06. Grouping and Outlining
07. Combining Automatic and Manual Outlining
08. Using "Excel Options" Dialog Box
09. "What-If Analysis" - Finding solutions using Goal Seek
10. Calculating the sales required to achieve desired profits
11. Scenarios
12. Add a first field with ascending consecutive row numbers
13. Creating reports with Solver
14. Advantages of working with names in a combo box
15. Customizing Toolbars
16. "Edit Links" Dialog Box
Excel Formulas & Functions
----Beginner
01. Using F4 in Formulas (Toggle Absolute & Relative References)
02. Using Nested Formulas
03. Basic Text Functions (CHAR, CLEAN, TRIM, LEFT, RIGHT, REPLACE & REPT)
04. Using Arithmetic Operators(+ , - , / , *)
05. Mathematical Functions (ABS, FLOOR, CEILING, ROUND, INT, SIGN, ODD, EVEN, PI & TRUNC)
06. Information Functions (ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISREF, ISTEXT)
07. Date & Time Functions (SECOND, MINUTE, HOUR, DAY, MONTH, YEAR, TODAY, NOW)
08. Statistical Formulas (SMALL, LARGE, MAX, MIN, MEDIAN, AVERAGE, SUM)
----Intermediate
01. Difference between SUMIF and SUMIFS
02. Auditing Formulas (Stepping into Formulas & Tracing Precedents and Dependents)
03. Trace Errors, Show Formulas & Smart Tag
04. Formula for updating Names Reference
05. Statistical Formulas (MODE, RANK, QUARTILE, PERCENTILE)
06. Text Functions (MID, SUBSTITUTE, LEN, FIND, VALUE)
07. Mathematical Functions (QUOTIENT, MOD, ROUNDDOWN, ROUNDUP, POWER, MROUND)
08. Logical Functions(SUMIF, COUNTIF, AVERAGEIF, IF, AND, NOT, OR)
09. IFERROR Function
10. CELL Function
11. Information Functions (COUNT, COUNTA, COUNTBLANK, ERROR.TYPE, N, NA, TYPE)
12. Date & Time Functions (TIMEVALUE, DATEVALUE, DATEDIF, WORKDAY, WEEKNUM)
----Advanced
01. Technical Description of Array Formulas
02. Using Array Formulas to create Links
03. User Defined Functions (UDF)
04. Using VLOOKUP
05. Other Lookup Functions (HLOOKUP, MATCH, INDEX & CHOOSE)
06. Mathematical Functions (FACT, PERMUT, COMBIN, MINVERSE, MMULT, RANDBETWEEN)
07. OFFSET Function
08. INDIRECT Function
09. FORECAST, GROWTH & TREND Function
10. Logical Functions (SUMIF, COUNTIF, IF, AND, NOT, OR)
11. Database Functions (DAVERAGE, DCOUNT, DSUM, DGET, DMAX, DMIN)
12. Date & Time Functions (EOMONTH & NETWORKDAYS)
13. FREQUENCY Function
Comments