503 подписчиков
111 видео
3. DAY 3 UNDO AND REDO IN EXCEL
How to Remove Brackets in Excel
Text to Row with shortcut |
3. Day 3 BASIC DIVIDE FORMULAS
Insert blank Rows |
Add bullet point in Excel
3. Day 3 NUMBER FORMATTING
4 DAY 4 FLASH FILL
combine cells to single cell in Excel
Array Functions ||
2. Day 2 SUM and SUMIF formulas
5. DAY 5 FIND AND REPLACE IN EXCEL
Alternate row delete
Add Name Title in Excel
Apply Border ||
6. Day 6 FUNCTIONS SUM, AVERAGE, COUNT and COUNTA
Create calendar in excel ||
7. DAY 7 Import data from the web
Date & Time with shortcut |
% of total Value In Excel
make calendar with SEQUENCE formula |
7. DAY 7 USEFUL KEYBOARD SHORTCUTS
4. Day 4 CELL ALIGNMENT
Add check Box in Google sheets |
Autofit cells & column ||
Add data bars in Excel
Add check box in Excel
Change number to % ||
auto add borders ||
7. Day 7 ERROR checking and calculating FORMULAS
Checkbox in google sheet ||
Attendance Calculator ||
Auto formatting ||
Clear formatting in Excel ||
Add image in pie chart
