Course programme
CHAPTER-01
1 lecture 15:46
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR, RIBBON, TAB, etc.
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,, RIBBON, TAB, NAME BOX, FORMULA BAR, COLUMN, ROW, SPREADSHEET, GRID AREA, CELL, SCROLLBAR, ZOOM SELECTION, RANGE, NAME A RANGE,
CHAPTER-01
1 lecture 15:46
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR, RIBBON, TAB, etc.
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,, RIBBON, TAB, NAME BOX, FORMULA BAR, COLUMN, ROW, SPREADSHEET, GRID AREA, CELL, SCROLLBAR, ZOOM SELECTION, RANGE, NAME A RANGE,
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR, RIBBON, TAB, etc.
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,, RIBBON, TAB, NAME BOX, FORMULA BAR, COLUMN, ROW, SPREADSHEET, GRID AREA, CELL, SCROLLBAR, ZOOM SELECTION, RANGE, NAME A RANGE,
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR, RIBBON, TAB, etc.
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,, RIBBON, TAB, NAME BOX, FORMULA BAR, COLUMN, ROW, SPREADSHEET, GRID AREA, CELL, SCROLLBAR, ZOOM SELECTION, RANGE, NAME A RANGE,
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR, RIBBON, TAB, etc.
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,, RIBBON, TAB, NAME BOX, FORMULA BAR, COLUMN, ROW, SPREADSHEET, GRID AREA, CELL, SCROLLBAR, ZOOM SELECTION, RANGE, NAME A RANGE,
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR, RIBBON, TAB, etc.
EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,, RIBBON, TAB, NAME BOX, FORMULA BAR, COLUMN, ROW, SPREADSHEET, GRID AREA, CELL, SCROLLBAR, ZOOM SELECTION, RANGE, NAME A RANGE,EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,, RIBBON, TAB, NAME BOX, FORMULA BAR, COLUMN, ROW, SPREADSHEET, GRID AREA, CELL, SCROLLBAR, ZOOM SELECTION, RANGE, NAME A RANGE,EXCEL INTRODUCTION, WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,, RIBBON, TAB, NAME BOX, FORMULA BAR, COLUMN, ROW, SPREADSHEET, GRID AREA, CELL, SCROLLBAR, ZOOM SELECTION, RANGE, NAME A RANGE,
CHAPTER-02
1 lecture 15:22
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, etc.
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS,
CHAPTER-02
1 lecture 15:22
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, etc.
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS,
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, etc.
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS,
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, etc.
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS,
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, etc.
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS,
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, etc.
FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS,FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS,FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS,
CHAPTER-03
1 lecture 10:35
CUT, COPY, PASTE, FORMAT PAINTER, FONT CHANGING, BOLD ITALIC, UNDERLINE,etc.
CUT, COPY, PASTE,, FORMAT PAINTER, FONT CHANGING,, BOLD ITALIC, UNDERLINE, BORDER, CELL COLOR, TEXT COLOR,
CHAPTER-03
1 lecture 10:35
CUT, COPY, PASTE, FORMAT PAINTER, FONT CHANGING, BOLD ITALIC, UNDERLINE,etc.
CUT, COPY, PASTE,, FORMAT PAINTER, FONT CHANGING,, BOLD ITALIC, UNDERLINE, BORDER, CELL COLOR, TEXT COLOR,
CUT, COPY, PASTE, FORMAT PAINTER, FONT CHANGING, BOLD ITALIC, UNDERLINE,etc.
CUT, COPY, PASTE,, FORMAT PAINTER, FONT CHANGING,, BOLD ITALIC, UNDERLINE, BORDER, CELL COLOR, TEXT COLOR,
CUT, COPY, PASTE, FORMAT PAINTER, FONT CHANGING, BOLD ITALIC, UNDERLINE,etc.
CUT, COPY, PASTE,, FORMAT PAINTER, FONT CHANGING,, BOLD ITALIC, UNDERLINE, BORDER, CELL COLOR, TEXT COLOR,
CUT, COPY, PASTE, FORMAT PAINTER, FONT CHANGING, BOLD ITALIC, UNDERLINE,etc.
CUT, COPY, PASTE,, FORMAT PAINTER, FONT CHANGING,, BOLD ITALIC, UNDERLINE, BORDER, CELL COLOR, TEXT COLOR,
CUT, COPY, PASTE, FORMAT PAINTER, FONT CHANGING, BOLD ITALIC, UNDERLINE,etc.
CUT, COPY, PASTE,, FORMAT PAINTER, FONT CHANGING,, BOLD ITALIC, UNDERLINE, BORDER, CELL COLOR, TEXT COLOR,CUT, COPY, PASTE,, FORMAT PAINTER, FONT CHANGING,, BOLD ITALIC, UNDERLINE, BORDER, CELL COLOR, TEXT COLOR,CUT, COPY, PASTE,, FORMAT PAINTER, FONT CHANGING,, BOLD ITALIC, UNDERLINE, BORDER, CELL COLOR, TEXT COLOR,
CHAPTER-04
1 lecture 11:09
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT WRAP TEXT, MERGE etc.
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,, MERGE ACROSS, MERGE CELLS, UNMERGE CELLS
CHAPTER-04
1 lecture 11:09
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT WRAP TEXT, MERGE etc.
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,, MERGE ACROSS, MERGE CELLS, UNMERGE CELLS
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT WRAP TEXT, MERGE etc.
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,, MERGE ACROSS, MERGE CELLS, UNMERGE CELLS
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT WRAP TEXT, MERGE etc.
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,, MERGE ACROSS, MERGE CELLS, UNMERGE CELLS
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT WRAP TEXT, MERGE etc.
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,, MERGE ACROSS, MERGE CELLS, UNMERGE CELLS
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT WRAP TEXT, MERGE etc.
ALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,, MERGE ACROSS, MERGE CELLS, UNMERGE CELLSALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,, MERGE ACROSS, MERGE CELLS, UNMERGE CELLSALIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,, MERGE ACROSS, MERGE CELLS, UNMERGE CELLS
CHAPTER-05
1 lecture 08:46
NUMBER FORMATTING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE etc.
NUMBER FORMATING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, SCIENTIFIC FUNCTION,
CHAPTER-05
1 lecture 08:46
NUMBER FORMATTING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE etc.
NUMBER FORMATING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, SCIENTIFIC FUNCTION,
NUMBER FORMATTING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE etc.
NUMBER FORMATING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, SCIENTIFIC FUNCTION,
NUMBER FORMATTING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE etc.
NUMBER FORMATING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, SCIENTIFIC FUNCTION,
NUMBER FORMATTING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE etc.
NUMBER FORMATING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, SCIENTIFIC FUNCTION,
NUMBER FORMATTING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE etc.
NUMBER FORMATING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, SCIENTIFIC FUNCTION,NUMBER FORMATING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, SCIENTIFIC FUNCTION,NUMBER FORMATING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, SCIENTIFIC FUNCTION,
CHAPTER-06
1 lecture 13:13
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS etc.
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS, COLOR SCALES, ICON SETS, NEW RULE, CLEAR RULES, MANAGE RULES, FORMAT AS TABLE, MORE STYLING TOOL,
CHAPTER-06
1 lecture 13:13
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS etc.
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS, COLOR SCALES, ICON SETS, NEW RULE, CLEAR RULES, MANAGE RULES, FORMAT AS TABLE, MORE STYLING TOOL,
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS etc.
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS, COLOR SCALES, ICON SETS, NEW RULE, CLEAR RULES, MANAGE RULES, FORMAT AS TABLE, MORE STYLING TOOL,
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS etc.
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS, COLOR SCALES, ICON SETS, NEW RULE, CLEAR RULES, MANAGE RULES, FORMAT AS TABLE, MORE STYLING TOOL,
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS etc.
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS, COLOR SCALES, ICON SETS, NEW RULE, CLEAR RULES, MANAGE RULES, FORMAT AS TABLE, MORE STYLING TOOL,
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS etc.
CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS, COLOR SCALES, ICON SETS, NEW RULE, CLEAR RULES, MANAGE RULES, FORMAT AS TABLE, MORE STYLING TOOL,CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS, COLOR SCALES, ICON SETS, NEW RULE, CLEAR RULES, MANAGE RULES, FORMAT AS TABLE, MORE STYLING TOOL,CONDITION FORMATTING-HIGHLIGHT CELLS RULES, TOP-BOTTOM RULES, DATA BARS, COLOR SCALES, ICON SETS, NEW RULE, CLEAR RULES, MANAGE RULES, FORMAT AS TABLE, MORE STYLING TOOL,
CHAPTER-07
1 lecture 14:47
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET,FORMAT ROW HEIGHT AND WIDTH etc.
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS, RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,
CHAPTER-07
1 lecture 14:47
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET,FORMAT ROW HEIGHT AND WIDTH etc.
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS, RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET,FORMAT ROW HEIGHT AND WIDTH etc.
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS, RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET,FORMAT ROW HEIGHT AND WIDTH etc.
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS, RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET,FORMAT ROW HEIGHT AND WIDTH etc.
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS, RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET,FORMAT ROW HEIGHT AND WIDTH etc.
INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS, RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS, RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,INSERT CELL, ROW, SHEET, DELETE CELL, ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS, RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,
CHAPTER-08
1 lecture 18:52
AUTOSUM, AVERAGE, COUNT NUMBERS, MAX, MIN, FILL DOWN, RIGHT, UP, LEFT, etc.
AUTOSUM, AVERAGE, COUNT NUMBERS, MAX, MIN, FILL DOWN, RIGHT, UP, LEFT, SERIES, JUSTIFY, CLEAR FORMAT, CONTENT, COMMENT, HYPERLINK, FIND COMMAND & REPLACE COMMAND, FIND COMMENT,FIND FORMULAS,FIND OBJECT, FIND CONDITION FORMATING,
CHAPTER-08.
1 lecture 18:52
AUTOSUM, AVERAGE, COUNT NUMBERS, MAX, MIN, FILL DOWN, RIGHT, UP, LEFT, etc p
SPELLING CHECKER FUNCTION, THESAURUS FUNCTION, TRANSLATE FUNCTION, etc.
SPELLING CHECKER FUNCTION, THESAURUS FUNCTION, TRANSLATE FUNCTION, SWITCHING WINDOWS, USE COMMENT FUNCTIONSPELLING CHECKER FUNCTION, THESAURUS FUNCTION, TRANSLATE FUNCTION, SWITCHING...
