facebook


Professional Excel Bootcamp

Content

1+ Lessons

Duration

8 Hours

Resources

pdf book,materials

Quiz

Each module

Facilities

Problem solving,Certificate,Internship

Course Modules

INroduction of MS Excel's Environment, WHich includes RIbbon,TAB,GROUP, FOrmating, CUstomization of Toolbar e.t.c

 

  • Relative  Cell Referencing in Excel
  • Absolute Cell Referencing in Excel

​​​​​​​Their definition & use with example.

  • Mathmatical function
  • Common function
  • Logical 
  • Conditional
  • String
  • Date TIme
  • Data Visualization with Chart
  • Vllokup
  • Pivot table
  • e.t.c
  1. Sorting & Filtering in Excel
  1. Data Validation & VLOOKUP
  1. Pivot Table & Pivot Chart