All India Scholarship Helpline : 8050067687

Microsoft Excel

Last Update On

Staff 2

Learn Microsoft Excel – Beginner to Advance with Example (Free Udemy Course)

Free Udemy Courses

CIGMA Pedia Whatsapp Community

Learn Microsoft Excel – Beginner to Advance with Example (Free Udemy Course) : Microsoft Excel Basic to Advance, Learn A to Z, Office 365/2023, 2010, 2013, 2016, Excel 2019, Zero to Hero guide

Also Check : Learn Mastering ChatGPT and PowerPoint presentation (Free Udemy Course)

What you will learn in Microsoft Excel Course

  • 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

Also Check : CIGMA’s Free eBook Gem 2023 : Productivity Boosted

Learn Microsoft Excel 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

Requirement of Learn Microsoft Excel Course

  • No prior knowledge is required, You will learn everything you need to know from basic
  • Any Fresher to the Excel

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

Also Check : John Thompson Scholarship 2024 for PG Students | Foreign Scholarship | Last Date, Benefits, Advantage

How to Get this course FREE?

Price & Validity

Actual Price : Rs.1999/-
After 100% Discount : Rs.0/-

Valid for First 1000 Users or till the last date. Hurry up before it closes

Apply this Coupon : APRTHREE24 (For 100% Discount)

Also Check : Formula Bot : Your AI Powered Companion for Effortless Equation Solving

Note : Udemy Courses listed here are offered FREE only for first 1000 users or are limited by a date. If the 1000 users limit or last date is completed, the course becomes paid.