Course Includes:
- Price: FREE
- Enrolled: 161305 students
- Language: English
- Certificate: Yes
- Difficulty: Beginner
Coupon verified 04:07 PM (updated every 10 min)
Course Folder
What You'll 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
Requirements
- No prior knowledge is required
- You will learn everything you need to know from basic
- Any Fresher to the Excel
- You will learn everything at one place
- whatever you need
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
- working professional
- businessman
- 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
Recommended Courses
Mastering ChatGPT (AI) and PowerPoint presentation
FREE
Combined Artificial intelligence to create presentation
Enrolled
Diversity & Inclusion Mastery: Build an Inclusive Culture
FREE
DEI Strategy | Inclusive Workplace | Bias Training | Diversity Programs | Employee Engagement | HR Best Practices
Enrolled
Scaling Innovation, Digital Transformation in Businesses
FREE
Business Innovation, Digital Transformation, Operations Management, Process Optimization, Emerging Technologies
Enrolled
Competency-Based Interview: Structured Behavioral Questions
FREE
Hiring Techniques | Recruitment | STAR | Talent Assessment | PARLA | CARE | Predictive Hiring | Checking references
Enrolled
Unlock Fluent English: Master Idioms for Rapid Communication
FREE
Learn essential idioms to boost your English fluency, improve business communication, and sound like a native speaker
Enrolled
Strategy Planning and Strategic Session Business Framework
FREE
Revenue Growth | Goal Setting | Decision Making | OKR | Competitive Advantage | SWOT | Vision | Execution | KPIs | SMART
Enrolled
The Complete Manager: Management Skills Guide for Beginners
FREE
Acquire time management, leadership, and communication skills, ideal for both new and experienced managers.
Enrolled
Low-Level Computing for Computer Science & Engineering 2025
FREE
Master core computer science with electronics, C++, logic circuits & data structures—taught by real university professor
Enrolled
Certificado Profissional em Gestão de Projetos
FREE
Compreender a Gestão de Projetos, Funções Principais, Papel de um Gestor de Projeto, Project Lifecycle, Metodologia
EnrolledPrevious Courses
PHRi Professional in Human Resources International HRCI 2025
FREE
PHRi HRCI Exam Preparation course and Practice test | PHR • SPHR • aPHRi • SHRM • CIPD • GPHR • CPHR • aPHR • SPHRi
Enrolled
Talent Acquisition Director: Recruitment Management System
FREE
VP | Leadership | Hiring Audit & Strategy | Executive Recruiting | Workforce Planning | Employer Branding | TA Metrics
Enrolled
Build and Scale with AWS Cloud - A Hands-on Beginners Guide
FREE
Accelerate your AWS Cloud skills with hands-on labs, guided demos, and real-world exercises
Enrolled
Certificado Profissional em Liderança e Gestão
FREE
Certificado Profissional em Liderança e Gestão, Planeamento e Tomada de Decisão, Gestão nas Organizações
Enrolled
HR Analytics for Data-Driven Decisions and Forecasting 2025
FREE
People | Workforce | Predictive Metrics | Talent KPIs | Dashboard | Data Insights | Reporting | AI | Scorecard | Excel
Enrolled
Job Offering: Selling to Candidates & Recruiter Sales Skills
FREE
Recruitment Persuasion | Closing Candidates | Employer Branding | Headhunting | Negotiation | Counteroffers | Talent
Enrolled
Crisis-Proof HR: No-Budget Strategies for Human Resources
FREE
Zero HR | Cost-Effective | Resilient Leadership | Talent Management During Uncertainty | VUCA | Downsizing | Layoffs
Enrolled
SHRM-SCP ⭑ SHRM Senior Certified Professional, 2025 exam
FREE
SHRM-SCP Exam Preparation course and Practice test | PHR • SPHR • PHRi • SPHRi • CIPD • GPHR • CPHR • aPHR • aPHRi
Enrolled
HR Trends 2025-2030: Future Strategies & Innovations
FREE
Work | Strategy | AI | Remote Work | DEI | Digital HR | Workforce Planning | Tech | Deloitte | Josh Bersin | Automation
Enrolled