Microsoft Excel Basic to Advance, Learn A to Z, Office 365/2023, 2010, 2013, 2016, Excel 2019, Zero to Hero guide
Note: Course Free for limited time and limited users(500 limit) so Enroll ASAP. If not free it means you are late. Scroll Down and click Enroll Now button to get enrolled
What You will Learn
- Basic excel equations widely used in
- Email shooting by using VBA Directly from excel to specific users
- Hands on experience to the excel with understanding of shortcuts
- Analytical dashboard creation
- Data filtration, Border, Sr No., Format Painter
- Codes used in VBA
- Function today() and Equation additing
- Command Dollar {$} understanding
- Data Validation – Drop Down List creation
- IF, Nested if, if(And) command
- Use of Conditional Formatting with Example
- Remove Duplicates value in Excel
- Automate Boarder – Where data available
- Understanding of VLOOKUP
- Index – Match equation
- Data Filter – Analyse data
- Bar Chart, Pie Chart Creation – Dashboard
- VBA Form Creation
- Password Protected Mail shooting directly from excel
- Complete idea about Pivot Table & Pivot chart
- This course includes:
- 4.5 hours on-demand video
- Assignments
- 14 downloadable resources
- Access on mobile and TV
- Full lifetime access
- Closed captions
- Audio description in existing audio
- Certificate of completion
Scroll Down and click Enroll Now Button to get enrolled into the Free Course
Description
In this course you are going to learn, daily excel equations which are widely used in daily life with short cut. No prior knowledge is required. We have taken example to teach easily so one can learn from basic with example. Example here taken to send email to the specific person directly from excel by using one button and navigating to the outlook in easy way.
You are going to learn
1. Basic excel equations widely used in
2. Hands on experience to the excel with understanding of basic and widely use shortcuts
3. Analytical dashboard creation – Pie chart, Bar chart
4. Data filtration, Border, Sr No., Format Painter
5. Email shooting by using VBA from excel to specific users from outlook using single button
6. Codes used in VBA
7. Data Validation – Drop Down List creation
8. IF, Nested if, if(And) command as a equation
9. Use of Conditional Formatting with Example
10. Remove Duplicates value in Excel
11. Linking from excel to mail (You can shoot mail by clicking button from excel directly)
12. Bar Chart, Pie Chart Creation – Dashboard
13. Understanding of VLOOKUP
14. Index – Match equation for arranging and fetching right data
15. Data Filter – Analyze data
16. Password Protected Mail shooting directly from excel
17. And many more new things covered
Who this course is for:
Beginners to the excel
College students
To become expert in data analytics by using excel
Who wants to learn excel from basic, and want to become expert
Want to understand the real life corporate situation and solve from the basic
Requirements
No prior knowledge is required, You will learn everything you need to know from basic
Any Fresher to the Excel
Course Content
- 9 sections • 44 lectures • 4h 34m total length
- Data filtration, Border, Sr No., Format Painter
- Home Tab Overview
- Attachment format
- Quiz 1
- Function today() and Equation additing
- Command Dollar {$} understanding
- Data Validation – Drop Down List creation
- IF, Nested if, if(And) command
- Quiz 2
- Highlight cell which contains – by Conditional Formatting
- Conditional Formatting – Manage Rule
- Can you automate the boarder? (Wherever data is available – Auto border)
- if statement use for mail shooting – VBA lecture
- Remove Duplicates value in Excel
- Automate Boarder – Where data available
- Understanding of VLOOKUP
- Index – Match equation
- if – or equation
- Data Filter – Analyse data
- Briefing video – Download file
- Analytical Dashboard Layout
- Counta, CountIf, Sum, Freeze Row – Calculate the data for Dashboard
- Solution to the question – countif
- Bar Chart – Dashboard
- Pie Chart – Dashboard
- Quick Revision – Download attachment for reference
- Quiz 3
- Enable Developer Tab and Saving under Macro enabled file
- VBA Form Creation
- MACRO Coding to the Submit Button
- Coding to Close, Clear & Goto Main Page
- Code to Open up outlook and Send Mail
- Create Email Body by Code
- Easy Explanation of VBA MACRO code
- Shorting out issues and take trial
- Password Protected Mail shooting
- Download Final Excel Sheet
- All About Mid & Search
- All About Mid, Search, Trim & Len – Part 2
- Pivot Table – Basics – How to create a Pivot Table
- Data refining with Pivot table
- Convert data in to Table
- Everything you should know about Pivot Table
- Pivot Chart
Note: Course Free for limited time and limited users(500 limit) so Enroll ASAP. If not free it means you are late.
