Are you want to learn MS Excel online? A free training session available for short time. What topic you want to learn? comments here
| Question | Y/N | Question | Y/N |
| Write basic formulas, eg = A1*A2 | Write formulas using brackets where required, eg =(A1+A2)/A3 | ||
| Write basic functions, eg SUM, AVERAGE,MAX, MIN | Selecting ranges with cells together and separate | ||
| Understand Absolute and Relative References in formulas, eg =B7 + $A$3 | Create simple charts | ||
| Create Logical functions, eg IF, AND, OR, NOT | Create a nested IF function (multiple IF statements in the same function) | ||
| Concatenate (join) text | Trap errors using IFERROR | ||
| Paste Values from formulas | Change Calculation method, eg Manual or Automatic | ||
| Create custom formats for numbers and dates | Use Conditional Formatting | ||
| Change the Page Layout, eg Margins, Headers, Footers, Background, Orientation, Paper Size | Use Scale to a Percentage or to Fit when Printing | ||
| Use different Views, eg Page Break Preview, Page Layout | Insert and delete columns, rows and worksheets | ||
| Hide and unhide worksheets | Move and copy worksheets to the same or a different workbook | ||
| Freeze row and/or column titles | Use Find and Replace to change formulas | ||
| Sort a list (including multiple sorts) | |||
| Use Filtering – Compound filters, Multiple value filters, Custom filters | Modify charts – adding titles, data tables, Trend lines, Error bars, text boxes | ||
| Create a VLOOKUP function in both it’s forms and know the difference between them | Create CHOOSE, INDEX, MATCH functions | ||
| Create reference functions, e.g. ROW, COLUMN, ADDRESS, INDIRECT, OFFSET | Modify charts – changing shape styles, colors, fills, shape effects, themes | ||
| Create, use, modify and delete range names | Create range names using text labels or a selection | ||
| Create worksheet specific range names | Using range names in formula | ||
| Protecting cells, ranges, worksheets and workbooks | Use automatic Subtotals (rather than manually creating them) | ||
| Create and use Relative Names for Subtotals Linking between Worksheets and Workbooks | Consolidate data from many workbooks into one workbook | ||
| Create Pivot Tables | Use Pivot Tables: Group, calculate, Slicer Create Pivot Charts | ||
| Use the data analysis tools Goal Seek and Solver | Use macro |
These are basic level MS Excel training outline, if you interested to learn advance level formula and formatting, also write us / comments here
3 thoughts on “Microsoft Excel – Course outline”