MS EXCEL [DTOUCH SILVER]
Introduction
Microsoft Excel is one of the most popular tools for managing, analyzing, and reporting data. Whether you\'re organizing simple lists or handling complex data sets, Excel provides powerful features to simplify your work. This course is tailored for beginners with little or no prior experience, focusing on the basic skills you need to get started with Excel.
In this course, you\'ll learn key concepts and techniques, including:
- What is MS Excel?
- Why is Excel important in the corporate world?
- How to easily learn and navigate Excel
- Understanding Workbooks, Worksheets, Cells, Ribbons, Rows, Columns, and Tabs
- Entering and formatting data (Font, Borders, Colors, Alignment)
- Using tools like Format Painter and essential keyboard shortcuts
- Sorting and filtering data
- Using functions like NOW, LEN, SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
- Working with CONCATENATE, VLOOKUP, and Pivot Tables
By the end of this course, you\'ll be able to create and manage basic spreadsheets with ease. Whether you're a student, professional, or simply looking to boost your productivity, this course will give you a solid foundation in Excel and prepare you for more advanced skills.
Course Description
Course Captain: Rashmi S.M - rashmi@desicrew.in
🕕Course Duration: 10 Hours
👍Learning Outcome
Basic Excel Formulas and Pivot Table
Course Curriculum
- Introduction to ExcelPreview
- Key Components of MS Excel 1
- Font
- Border
- Color and Shading
- Alignment
- Format Painter
- Keyboard Shortcuts
- Data Sorting
- Data Filtering
- NOW Fuction
- LEN Function
- MIN Function
- MAX Function
- COUNT Function
- COUNTA Function
- SUM Function
- AVERAGE Function
- CONCATENATE Function
- VLOOKUP Function
- Pivot Table