• LOGIN
  • No products in the cart.

Course Curriculum

Complete Lectures
How to go to a specific sheet in excel Details 00:01:00
Understanding Excel Interface – 1 Details 00:14:00
Format sheet, cut copy paste and paste special, selection techniques – 2 Details 00:05:00
Format painter, clipboard, boarder, gridlines, cell formatting – 3 Details 00:17:00
Number group, general, number, currency, accounting, date format – 4 Details 00:12:00
Conditional formatting with different criteria’s – 5 Details 00:12:00
Conditional formatting with different criteria’s, data bars etc – 6 Details 00:06:00
Conditional formatting managing rules, above and below average etc – 7 Details 00:08:00
Cell group, inset rows columns and sheets – 8 Details 00:05:00
Cell group, insert cell, insert rows and sheet – 9 Details 00:03:00
Move sheet, protect sheet and workbook, tab color – 10 Details 00:10:00
Inset function, sum average max min counta countblank today now and power functions – 11 Details 00:13:00
Days 360 days sumif and if functions – 12 Details 00:14:00
Countif Function – 13 Details 00:05:00
Relative and absolute cell reference – 14 Details 00:07:00
Define names, name manager – 15 Details 00:11:00
Formula auditing, trace dependents, show formula, error checking,trace error, watch window – 16 Details 00:13:00
Charts and its sub options – 17 Details 00:14:00
Filter Options – 18 Details 00:13:00
Tools group, data tools, convert text to column, remove duplicate, consolidate data – 19 Details 00:07:00
What if analysis, data tables, profit loss analysis, sales analysis – 20 Details 00:12:00
Data validation, scenario manager – 21 Details 00:20:00
Goal Seek – 22 Details 00:09:00
Sub Total – 23 Details 00:06:00
View Tab, worksheet views, show and hide, zoom, freeze panes, arrange windows – 24 Details 00:11:00
View group or panel, Synchronous scrolling, Synchronous scrolling, Switch windows – 25 Details 00:05:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

mmuop.com. All rights reserved.