What you’ll learn
- Introduction to Excel
- Logical statesmen’s in excel ( if, sumif, countif, if and or not etc. )
- Functions in Excel ( conditional formatting, color, protection, flash, text to column etc.)
- Lookup ( V and H look up)
- Pivot tables, slicers, pivot charts
- Date and Time function
- Data handling Dsum, dmax, dmin, dcount
- Advance component in excel
- Excel Macros and VBA
This course includes:
- 10 hours on-demand video
- 20 downloadable resources
- Access on mobile and TV
- Full lifetime access
- Certificate of completion
Description
(माइक्रोसॉफ्ट एक्सेल को प्रभुत्व के लिए व्यापक कोर्स, जिसमें तार्किक कथन, उन्नत फंक्शन, डेटा स्वरूपण, VBA मैक्रो, और अन्य शामिल हैं।)
Welcome to the “Mastering Microsoft Excel” course! This comprehensive guide is designed to take you from a beginner level to an advanced user of Microsoft Excel. Throughout this course, you will learn a wide range of functions and features to enhance your data analysis, reporting, and presentation skills using Excel, including macros and VBA (Visual Basic for Applications) programming.
Module 1: Introduction to Excel
- Understanding the Excel interface
- Navigating workbooks and worksheets
- Entering and formatting data
- Basic formula writing and cell references
- Managing workbooks and sheets
Module 2: Logical Statements and Basic Functions
- Introduction to logical statements (IF, IF-ELSE, nested IF)
- Utilizing logical functions for data analysis
- The SUMIF function for conditional summing
- The COUNTIF function for conditional counting
Module 3: Advanced Functions
- Introduction to the “THEN” function
- Utilizing advanced functions (e.g., SUMIFS, COUNTIFS)
- Using the “IF” function in conjunction with other functions
- Working with date and time functions (e.g., TODAY, NOW, DATE, TIME)
Module 4: Data Formatting and Protection
- Conditional formatting to highlight data
- Custom formatting for cells and data
- Protecting files with passwords and permissions
- Data protection techniques to prevent unwanted changes
Module 5: Data Organization and Management
- Hiding and unhiding rows and columns
- Sorting and filtering data for analysis
- Organizing data using tables and named ranges
Module 6: Lookup and Reference Functions
- Vertical Lookup (VLOOKUP) for finding data in tables
- Horizontal Lookup (HLOOKUP) for finding data in tables
- Utilizing INDEX and MATCH functions for dynamic lookups
Module 7: Macros and VBA Programming
- Understanding macros and their benefits
- Recording simple macros to automate tasks
- Writing and editing macros using VBA code
- Customizing macros to suit specific needs
Who this course is for:
- Desire to Learn Excel
How to Get this course FREE?
Get a 100% Discount On Udemy courses by clicking on the Apply Here Button. This Course coupon code is automatically added to the Apply Here Button.
Apply this Coupon: 0CB5C6DD36D66A84057D is applied (For 100% Discount)
For Latest Udemy Courses Coupon, Join Our Official Free Telegram Group :https://t.me/freecourseforall
Note: The udemy Courses Will be free for a Maximum of 1000 Learners can use the promo code AND Get this course for 100% Free. After that, you will get this course at a discounted price.
Important Notice and Disclaimer:- CareerBoostZone platform is a free Job Sharing platform for all the Job seekers. We don’t charge any cost and service fee for any job which is posted on our website, neither we have authorized anyone to do the same. Most of the jobs posted over Seekajob are taken from the career pages of the organizations. Jobseekers/Applicants are advised to check all the details when they apply for the job to avoid any inconvenience.
