Course Overview
Managing Sheets-Hide Unhide,Insert, Delete, Color
Sheet Move or Copy
Customizing Quick Access Toolbar
Managing Columns And Rows
Change Workbook Views
Course Overview:
This course has been designed with the most common excel features. The students who are seeking a job and the newly joined professionals must have this level of excel knowledge to work at their workplace independently.
The participants will learn to excel from the very beginning level to the professional level step by step with the practical business case study.
Course Duration: 07 Hours
Total Sections: 18
Supported Versions for Practice:
Excel 2010, 2013, 2016, 2019, office 365 and most will work in 2007
What You’ll Learn:
- Master Microsoft Excel from Beginner to Professional level with practical business data.
- Build a solid understanding of the Basics of Microsoft Excel.
- Learn the most common Excel features & functions used in daily official working.
- Automate the daily official works in a shortcut way.
- Create dynamic reports by most popular master commands, tools, PivotTables.
- Present your summary report in a tabular way.
- Stop typing invalid data and protect unauthorized access.
- Organize your unorganized scattered data in a logical format.
- Wow, your boss with the most popular dynamic functions IF, VLOOKUP, INDEX, MATCH, and many more.
- Analyze your data using conditional formatting.
- Access to 13+ years experienced Professional Trainer who has conducted 150+ professional training programs and educated 4000+ participants through live classroom training.
Training Methodology:
- Professional best quality video tutorial with workings.
- Bite-sized project-based business examples.
- Student can download the same excel data for practice.
- After each session, you can take quiz participation.
- Bengali language with a clear easy description
Pre-Requirements:
- You should have basic computer operation skills (Opening Excel, Data entry in Excel, Copy-paste, Closing Excel …..).
- You should have an internet-connected PC, mobile or TV.
The audience of This Course:
- Designed for beginners who are brand new to Excel.
- Also suitable for intermediate Excel users who want to improve).
- Students who are preparing for the job market.
- Just joined but having fear to work independently.
- Regular excel users and want to enhance their productivity.
- Anyone who wants to improve their job or career prospects in an office environment.
Course Content:
- Section-1: Course Overview
- Section-2: Start Working with Excel
- Section-3: Different Cell Formatting Techniques
- Section-4: Page Setup and Print Professionally
- Section-5: Insert data in cells and ranges
- Section-6: Viewing Data on Excel Sheet
- Section-7: Create and manage tables
- Section-8: Cell Reference (Relative Vs Absolute)
- Section-9: Most Common Functions for Text Handling
- Section-10: Most Common Functions for Number Handling
- Section-11: Logical Functions
- Section-12: Data Sorting
- Section-13: Data Filtering
- Section-14: Conditional Formatting
- Section-15: Lookup and References Functions
- Section-16: PivotTable
- Section-17: Data Validation
- Section-18: Secure Your Sheet and File with Password Protected