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