• Home group tools such as (Format Painter, Find/Replace, Paste Special, Number, Insert – delete cells(rows/columns), Autosum, Fill/Flash fill, Borders&Formatting).
  • Printing and its settings.
  • Data tools – database filtering/sorting, Conditional formatting, Remove duplicates).
  • Text formulas (Find, Left, Right, Len, Concatenate, Trim, relative and absolute cell references). Go to special.
  • Mathematical functions (Sumif, Countif, Sumifs, Counitfs, Averageif, Averageifs, Round, Roundup, Rounddown, Sumproduct, Subtotal (disrupt).
  • Logical functions (And, Or, Not, If, Iferror, Nested IF).
  • Lookup & Reference functions (Hlookup, Vlookup, index, match). Data validation.
  • Pivot tables, charts, financial functions: FV, PMT, PV, Rate, Nper, Pmt, IPMT, PPMT, CUMIPMT, CUMPRINC.
  • Writing a summative test.

Excel – intermediate

Registration Closed