## Microsoft Excel – Course outline

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