Tutorials to Learn MS Excel 2007


Microsoft Excel 2007

      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

      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

      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

      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)
      07. Date & Time Functions (SECOND, MINUTE, HOUR, DAY, MONTH, YEAR, TODAY, NOW)
      08. Statistical Formulas (SMALL, LARGE, MAX, MIN, MEDIAN, AVERAGE, SUM)

      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)

      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


Anonymous said…
How to get active all the points?