Curriculum
Course:
Advance Excel - All in one
Login
Curriculum
Advance Excel - All in one
Excel Shortcut Keys
0/7
Excel Shortcut Key with Ctrl
Video lesson
Excel Shortcut Key With Alt
Video lesson
Excel shortcut key with shift
Video lesson
Excel shortcut key When "Inside The Cell"
Video lesson
Excel shortcut key with function key
Video lesson
Excel Shortcut key with function part 2
Video lesson
Excel shortcut key with formatting function
Video lesson
Start Excel
0/33
What is Excel
12:03
How to use Excel 365 Free
1:51
Day 3 - How to Excel Work
Video lesson
How to Excel work Part 2
Video lesson
Day 4- Absolute Refrence in Excel
10:55
Day 5 - How to Mearge Excel Sheet Data
Video lesson
Day 6 - How to write data to multiple fields at once in Excel
Video lesson
Day 7 - How to calculate discount in Excel
Video lesson
Day 8 - If there is data on more than one sheet in Excel, then how are all the sheets linked together
2:00
Day 9 - Home - ClipBord & Font Menu
Video lesson
Day 10- Home > Aligment Numner - Aligment - Font - Border - Fill - Protection
Video lesson
Day 11 - Condition formatting
Video lesson
Day 12 - Home &Cell
Video lesson
Day 13 - Editing All opiton Fill
Video lesson
Day 14 - Clear All option
Video lesson
How to lock data in excel
Video lesson
Day 15 - Pivot table | Pivot chart
Video lesson
Day 16 - Charts | Type of Charts
Video lesson
Day 17- Symbols
Video lesson
Day 18 - Page Layout all option
Video lesson
Day 19 - Define name | name manager | Create from selection
Video lesson
Day 20 - Formula auditing
Video lesson
Day 21- Get & Transform data
Video lesson
Day 22- Filter | Advance filter
Video lesson
Day 23 - Data Tools
Video lesson
Day 24 - What if analysis
Video lesson
Day 25- Gool Seek | Data Table
Video lesson
Day 26- Outline > Group data | unGroup data | Subtotal
Video lesson
Day 27 -Comment | Notes
Video lesson
Day 28- How to Lock Excel file
Video lesson
Day 29 -Workbook view
Video lesson
Day 30 - New Window | Arrange all | Freez Panes
Video lesson
Day 31 - Macros
Video lesson
Excel Formulas
0/5
Day 32 - Basic Function
Video lesson
Day 33 - Text Function
Video lesson
Day 34 - Logical Unction
Video lesson
Day 35 - Accounting Function
Video lesson
Day 36 - Lookup Function
Video lesson
Advance Excel
0/7
Advance Option in Conditional Formatting
Video lesson
Conditional Formatting Part 2
Video lesson
Conditional formatting - Part 3
Video lesson
Conditional formatting part 4
Video lesson
Important key point of custom symbol like Comma, Hash, at sign, Plus, Left parentheses, Right parentheses, Asterisk
Video lesson
Pivottable in excel
Video lesson
Advance Chart in Excel Part 1
Video lesson
Excel Practice File
0/1
Excel Practice File
Text lesson
Preview
Useful Excel Macro [VBA] Codes Examples
0/32
What is a Macro Code?
Text lesson
Basic Code - Add Serial Numbers
Basic Code - Add Serial Numbers
Basic Code - Insert Multiple Columns
Video lesson
Basic Code - Insert Multiple Rows
Video lesson
Auto Fit Columns
Video lesson
Auto Fit Rows
Video lesson
Remove Text Wrap
Video lesson
Unmerge Cells
Video lesson
Open Calculator
Video lesson
Add Header/Footer Date
Video lesson
Custom Header/Footer
Video lesson
Formatting Codes
Text lesson
Highlight Duplicates from Selection
Video lesson
Highlight the Active Row and Column
Video lesson
Highlight Top 10 Values
Video lesson
Highlight Named Ranges
Video lesson
Highlight Greater than Values
Video lesson
Highlight Lower Than Values
Video lesson
Highlight Negative Numbers
Video lesson
Highlight Specific Text
Video lesson
Highlight Cells with Comments
Video lesson
Highlight Alternate Rows in the Selection
Video lesson
Highlight Cells with Misspelled Words
Video lesson
Highlight Cells with Error in the Entire Worksheet
Video lesson
Highlight Cells with a Specific Text in Worksheet
Video lesson
Highlight all the Blank Cells Invisible Space
Video lesson
Highlight Max Value in the Range
Video lesson
Highlight Min Value in the Range
Video lesson
Highlight Unique Values
Video lesson
Highlight Difference in Columns
Video lesson
Highlight Difference in Rows
Video lesson
Printing Codes
Text lesson
Advance Formula in Excel
0/1
XLookup Full Details Video
Video lesson
0/0
Text lesson
Excel Practice File
Excel Practice File
Lesson materials
Excel Practice File.xlsx
12 kb
Download
large data 2.xlsx
761 kb
Download
2 items
Download all
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
No account?
Sign Up
Sign In
Lost Password?
This website uses cookies and asks your personal data to enhance your browsing experience. We are committed to protecting your privacy and ensuring your data is handled in compliance with the
General Data Protection Regulation (GDPR)
.
Ok, I agree
Privacy Policy
WhatsApp us