Go back
- Course Details
- Certificate
About Course
Excel is like a digital spreadsheet that helps organize data, calculate numbers, and create charts, making it a bit like a super-powered calculator! Learning Excel is valuable for managing information and is used in finance, analytics, and many professions. It's like learning the language of numbers, setting a strong foundation for careers in various fields. Plus, it's a skill that's universally valuable, offering advantages in both academics and future careers!
Who made this course?
Santhu Excel Anywhere is a Tamil youtube channel that provides effective videos in Excel, Power BI, Word, PowerPoint.
Course Syllabus
Excel in Tamil
Overview of Ms Excel
Open Workbook
Create Worksheet
Save Workbook
Save As Workbook
Copy, Cut and Paste Folder/file
Hide and Unhide Worksheet
Colum and Row Hide-Unhide
Custom Tab
Custom List
Protect and Unprotect Sheet
Table to Range
Convert Excel to PDF
Send excel file as PDT
Remove Duplicate
Convert Text to Number
Convert to Percentage
File Path
Sort Data
Conditional Formatting
Drop-Down List
Dependent Drop-down List
Offset Dynamic Drop-down
Exact & If Exact
Case Sensitive Lookup
How to Freeze Pan
Sum with Indirect Function
Index with Match
Advanced Two-Way Lookup INDEX+MATCH
Pivot Table
Calculated Field in Pivot Table
Pivot Table Tricks
Advanced Networkdays
FIND TAT Status
Conditional formatting to Highlight Weekends
Have doubts?
This course has been taken from the youtube. If you have any doubts regarding the course contact the owner or contact us through the following mode
[email protected]
