~Get Your Files Here !

  1. Filter and sort

   1. Filter and sort text, amount, date.srt

  10. Countifs

   1. Countifs.srt

  11. Nesting functions

   1. Nesting functions.srt

  12. Macro

   1. Macro.srt

  13. Counta function

   1. Counta.srt

  14. Iferror function

   1. Iferror.srt

  2. Row and column blocking using $

   1. Multiplication table.srt

   2. Change currency.mp4

   2.1 Change currency.xlsx

  3. Conditional formatting

   1. Conditional formatting amounts.srt

   2. Conditional formatting colors.mp4

   2.1 Conditional formatting - color.xlsx

  4. If function

   1. If - commission checking.srt

   2. If - invoices.mp4

   2.1 If invoices.xlsx

  5. Text functions

   1. Left, right.srt

   2. MID.mp4

   2.1 Part of text.xlsx

  6. Pivot table

   1. Pivot table.srt

   2. Pivot table - chart.mp4

   2.1 Pivot table - chart.xlsx

  7. Creating a basic chart

   1. Creating a chart.srt

  8. Vlookup function

   1. Vlookup.srt

  9. Countif function

   1. Countif.srt