What you will learn
-
Learn Excel from the ground up, starting with basic operations and progressing to advanced functions, data analysis, and automation.
-
Acquire skills in sorting, filtering, and organizing data efficiently, making you adept at handling complex datasets.
-
Gain practical experience through hands-on exercises and real-world examples that reinforce your understanding.
Module 1: Introduction to Microsoft Excel 1.1 Understanding the Excel Interface 1.2 Navigating Worksheets and Workbooks 1.3 Essential Excel Features and Functions Module 2: Basic Spreadsheet Operations 2.1 Entering and Formatting Data 2.2 Cell Referencing and Formulas 2.3 Basic Functions: SUM, AVERAGE, COUNT Module 3: Advanced Data Management 3.1 Sorting and Filtering Data 3.2 Data Validation and Error Checking 3.3 Using Tables for Efficient Data Organization Module 4: Advanced Formulas and Functions 4.1 Logical Functions (IF, AND, OR) 4.2 Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX) 4.3 Text and Date Functions Module 5: Data Visualization and Analysis 5.1 Creating Charts and Graphs 5.2 Conditional Formatting 5.3 PivotTables for Data Analysis Module 6: Collaboration and Data Sharing 6.1 Protecting Worksheets and Workbooks 6.2 Sharing and Collaborating on Excel Files 6.3 Importing and Exporting Data Module 7: Advanced Excel Tips and Tricks 7.1 Keyboard Shortcuts for Efficiency 7.2 Customizing Excel Settings 7.3 Troubleshooting Common Issues Module 8: Excel Macros and Automation 8.1 Introduction to Macros 8.2 Recording and Running Macros
Lesson 18 - Printing options in Excel
Lesson 19 - Sum if function
Lesson 20 - Financial functions
Lesson 21 - Whatif analysis
Lesson 22 - Index and Match function
Lesson 23 - Window hacks
Lesson 24 - Comments in Excel
Lesson 25 - Advance Filter
Lesson 26 - Subtotal in excel
Lesson 27 - Insert Spark Lines in Excel
Lesson 28 - Formula Auditing
Lesson 29 - Database functions in Excel
Lesson 30 - Define names Named ranges
Lesson 31 - Customizing Excel settings
Lesson 32 - Hyperlinks
Lesson 33 - Format numbers in Excel
Lesson 34 - Recording Macros in Excel
Lesson 35 - Introduction to VBA
Lesson 36 - Excel VBA Variables and Data type
Lesson 37 - If and select cases
Lesson 38 - Loops
Lesson 39 - Interact with rows columns and sheets
Lesson 40 - Message boxes and input boxes
Lesson 41 - Events
Lesson 42 - Procedures and functions
Lesson 43 - Excel VBA Arrays
Lesson 44 - VBA User forms
Lesson 51 - Keyboard Shortcuts Common
Lesson 52 - Keyboard shortcuts Navigation
Lesson 53 - Keyboard shortcut selection
Lesson 54 - Shortcuts in Excel Ribbon
Lesson 55 - Keyboard shortcuts Active cell
Lesson 56 - Shortcuts in Excel Entering data
Lesson 57 - Shortcuts in Excel Rows and Columns
Lesson 58 - Shortcuts in Excel Worksheet
Lesson 59 - Shortcuts in Excel Workbook
Lesson 60 - Shortcuts in Excel Formulas
No Discussion Found
5.0
3 Reviews
Manoj CA ( USN :2GB21CV012 )
5 months ago
Good teaching
Shreyas Tiwari
5 months ago
When we will recieve completion certificate?
VinayKumar Mahajan (USN 2GB22CV417)
5 months ago
Good Teaching
Meet Your Instructor
About Instructor
Why Edutainer is Best? Edutainer is one of the biggest online education portals which makes you industry ready by building skills for technological and professional challenges. It focuses on industrial expectation and result oriented approach by providing end-to-end practical knowledge program by providing the most affordable courses. Edutainer assures courses which provide the most demanded and highest paying jobs in the industry. Undoubtedly, Edutainer is a pioneer in the field of technological study that provides the students with guidance under industrial professionals making them well-informed with the real operational procedures. After the successful completion of the enrolled course, the students get certified from Edutainer with references of leading organizations to get placed in them. So today, “Make a pledge to color your career path with technical courses from Edutainer”. Our Mission At Edutainer India, our mission is to empower individuals with the knowledge and skills they need to achieve their personal and professional goals. We believe that education is a powerful tool that can transform lives and create positive change in society. We are committed to making quality education accessible to all, regardless of their background or location, by offering a wide range of online courses in various disciplines. Expert Instructors We take pride in our team of expert instructors who are experienced professionals in their respective fields. They bring their wealth of knowledge and real-world experience to create engaging and informative course content that is tailored to meet the learning needs of our students. Our instructors are passionate about teaching and are dedicated to helping our learners succeed in their educational journey. Wide Range of Courses Edutainer India offers a diverse range of courses in various disciplines, including but not limited to business and management, technology, healthcare, finance, arts and design, language, and personal development. Our courses are designed to cater to the needs of beginners, intermediate learners, and seasoned professionals, allowing learners to upskill, reskill, and stay ahead in their careers. Flexible Learning We understand the importance of flexibility in today's fast-paced world. Our online courses are designed to provide learners with the flexibility to learn at their own pace and convenience. Our learners have the freedom to access course materials, lectures, and assessments from anywhere, at any time, using their computer, tablet, or smartphone. This allows learners to balance their professional and personal commitments while pursuing their educational goals. Affordable Pricing We believe that quality education should be accessible to all, and we strive to keep our courses affordable without compromising on the quality of content. Our pricing is competitive, and we also offer various discounts, promotions, and flexible payment options to make learning affordable for learners from diverse backgrounds. Interactive Learning Experience At Edutainer India, we believe in providing an interactive and engaging learning experience to our students. Our courses are designed with multimedia elements, such as videos, quizzes, assignments, and discussion forums, to facilitate active learning and enhance retention. Learners also have the opportunity to interact with instructors and fellow learners, providing a collaborative learning environment that fosters knowledge exchange and networking opportunities. Certificate of Completion Upon successful completion of our courses, learners receive a certificate of completion, which can be a valuable addition to their resume and demonstrate their commitment to professional development.
₹ 1000.00
-
Course Duration15 h 5 m 34 s
-
Course LevelAdvanced
-
Student Enrolled10
-
LanguageEnglish
This Course Includes
- 15 h 5 m 34 s Video Lectures
- 2 Quizzes
- 0 Assignments
- 1 Downloadable Resources
- Full Lifetime Access
- Certificate of Completion