Ms-Excel (Beginners)

Begin your Excel journey with confidence! Our beginner's course teaches you the basics of Microsoft Excel, from creating spreadsheets to simple data analysis. Excel at Excel, step by step !

Beginner 0 Students enrolled
Created by Pranav Dedhia Updated course English
Want to Connect with Live Sessions Click Here and Join
What will i learn?
  • Excel Proficiency
  • Data Entry and Organization
  • Formulas and Functions
  • Data Visualization
  • Data Analysis
  • Productivity Enhancement
  • Data Validation and Error Handling
  • PivotTables and PivotCharts
  • Conditional Formatting
  • Basic Automation
  • Practical Projects
  • Certification

Curriculum for this course
33 Lessons 03:05:57 Hours
Building Block : Kickstart EXCELLING in EXCEL since Day 0
6 Lessons 00:31:20 Hours
  • The MOUSE needs to STOP GNAWING ! 00:08:51 Preview
  • You're Invited to the Marriage of Rows and Columns 00:04:00
  • You've FILTERED it WRONG so far 00:05:07
  • CONTROL Uday CONTROL 00:08:43
  • Fill Down, Freeze Panes, Growth Calculation 00:02:18
  • Negatives in Bracket & Dealing with Gridlines 00:02:21
Mathematical Functions: Because who else will find your 'X' ?
7 Lessons 00:40:25 Hours
  • SUM Function 00:06:30
  • AVERAGE Function 00:05:24
  • MAX MIN 00:03:37
  • COUNT & COUNTA 00:06:44
  • SUMIF, SUMIFS 00:07:08
  • AVERAGEIF, AVERAGEIFS 00:04:38
  • COUNTIF, COUNTIFS 00:06:24
REFERENCING: Because in the world of spreadsheets, even cells need GPS !
3 Lessons 00:09:51 Hours
  • ABSOLUTE REFERENCING 00:06:45
  • RELATIVE REFERENCING 00:00:00
  • MIXED REFERENCING 00:03:06
FORMATTING: Even numbers need a makeover now and then!
5 Lessons 00:38:29 Hours
  • Currency Format 00:04:14
  • Formatting Dates 00:05:54
  • Custom Formats 00:06:03
  • Formatting Fonts, Alignment 00:09:09
  • Conditional Formatting 00:13:09
Date Functions: Even Spreadsheets deserve a little romance with numbers
4 Lessons 00:15:44 Hours
  • DATE, TODAY and NOW Functions 00:04:44
  • DAY, MONTH and YEAR Functions 00:01:44
  • EDATE & DATEDIF Functions 00:06:10
  • EOMONTH, WEEKDAY 00:03:06
Standardization Functions: To make data behave better than a classroom of giggling students
5 Lessons 00:28:06 Hours
  • UPPER, LOWER & PROPER Functions 00:04:08
  • LEFT, MID & RIGHT Functions 00:05:40
  • TRIM & LEN Functions 00:03:28
  • IFERROR Function 00:04:55
  • AND, OR & NOT Functions 00:09:55
TIPS to Impress Your Bosses
3 Lessons 00:22:02 Hours
  • Single Cell Vlookup & Hlookup (You didn't know it THIS WAY) 00:11:00
  • Basic Pivots, Quick Analysis & Borders 00:05:21
  • Tackling Changing Needs of Boss & Clients 00:05:41
Requirements
  • Basic Computer Skills
  • Microsoft Office Installation
  • Computer and Internet Access
  • Operating System:
  • Mathematical Aptitude
+ View more
Description

Welcome to our Excel Essentials for Beginners course!

Are you tired of the slow and tedious way of working in Microsoft Excel? Do you want to become an Excel pro and impress your bosses right from Day 1? Look no further!

In this short course, we've curated the essential Excel skills and loaded it with an arsenal of time-saving shortcuts. Say goodbye to the mundane and embrace a faster, more efficient way of handling Excel tasks.

Whether you're a complete novice or have some basic knowledge, our course will equip you with the skills you need to boost your productivity and become a spreadsheet wizard. Join us on this journey to Excel excellence! 

+ View more
Other related courses
03:37:23 Hours
Google Sheets Mastery
Updated Fri, 21-Apr-2023
0 ₹599 ₹299
About the instructor
  • 0 Reviews
  • 0 Students
  • 1 Courses
+ View more
Pranav Dedhia

A Chartered Accountant by profession and a Passionate Educator, Pranav has trained 20000+ students and working professionals in buildings skillsets giving them an edge over their competition in the Corporate World.

Pranav has over 8 years of experience in dealing with Private Equity / Venture Capital Funds as part of his corporate exposure. His forte lies in Advanced Financial Modelling and Advanced Excel.

With a Cohesive mix of Corporate Experience and a Trainer mindset, Pranav looks forward to partaking his experience with you.

LinkedIn Connect –

https://www.linkedin.com/in/dedhiapranav/

Instagram Connect –

https://instagram.com/capranavdedhia

Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
Preview this course
₹299 ₹699
Buy now
Includes:
  • 03:05:57 Hours On demand videos
  • 33 Lessons
  • Access on mobile and tv
  • Full lifetime access
  • Live sessions with instructor
  • Completion certificate
  • Practice sessions

  • Compare this course with other

"