Basic Excel @ Rs. 2000 in One Week

Excel Basic is not actually the basic. Basic is the first step to learn someting advance. This course will teach you the most fundanmental features of excel. This course is best for the people who want to start their carrier in Data Science.

Have a look at the course content below.

Excel Introduction

  • A brief tour to Excel Options
  • Introduction to Excel Ribbon
  • Understanding of Excel Windows and Bars

Excel Range

  • Absolute Reference
  • Relative Reference
  • Mix Reference
  • Intersecting Reference

Excel Copy and Paste

  • Cut, Copy and Paste
  • Paste Special
  • Copy As Picture
  • Copy as Link

Formatting

  • Excel Formats
  • Custom Formatting
  • Condtional Formatting
  • Custom Style

Working on Cells

  • Inserting Comments
  • Insert/Delete Rows/Columns
  • Fill Range
  • Find and Replace

Basic Formulas

  • Sum,, SumIf
  • Count, Counta, Conutif
  • Average, AverageIf
  • Vlookup, Hookup, Match, Index
  • Find, Replace, Subtitute.

Excel Charts

  • Bar Chart, Column Chart, Area Chart
  • Line Chart, Scatter Chart
  • Radar Chart, Doughnut Chart, Pie Chart

Tables

  • Excel XML tables
  • Pivot Tables
  • Pivot Chart

Page Setup

  • Print Area
  • Page Breaks
  • Print Titles
  • Other print settings

Excel Formulas @ Rs. 3000 in 2 Weeks

Welcome and Look at the Excel Formula showing below –

=IFERROR(SMALL(IFERROR(VALUE(IFERROR(IF(MATCH(row_array,IFERROR(SMALL(IF(MID(A1,row_array,1)=”-“,row_array,””),row_array),””)-row_array+1,0),”-“,””),””)&MID(SUBSTITUTE(A1,”-“,””),ROW(INDIRECT(“1:”&LEN(SUBSTITUTE(A1,”-“,””)))),1)),””),ROW()),””)

Excel formulas are amazing, But are they hard to learn? There is a rule applied to everything in the world. “Hard is what we dont understand”, Same goes with formulas.

When you understand the very basic of “How Excel Works?”,  You will automatically understand the concept of formulas. Most importantly, the more you practice, the more you get.

I learned vlookup() 10 years back and there was almost no things i was doing without using vlookup(). But, Vlookup() was just the starting to get dive into deep in excel formula. Most exciting part was to learn string manipulation, lookup formulas and  array formulas, they really fascinate me.

I love to share these technique with you by using the Excel Formulas showing here. have a look a contact me, Believe Me, it is not that hard as it looks.

Bottom Line –

Join my Excel Power User whatsApp group to get an instant solution of your excel queries


Formula Basic

  1. Relative and Absolute Reference
  2. R1C1 and A1 Notation
  3. How to Refer other sheets in formulas.
  4. Range Address / Name Range.
  5. Define Name / Apply Range.
  6. Create name ranges in just one click.

String Manipulation

Left, Right, Mid, Substitute, Replace
Find, Search, Exact, Code, Char, Text
Concatenate, Mid, Lower, Upper, Replace
Clean, Rept.

Date and Time

How dates and times works?
Date, Year, Month, Day, Date
Hours, Minute, Second, Time
Edate, EOMOnth, NetWorkday
Workday,Timevalue, DateValue

Logical Function

Comparison Operator
AND, OR, NOT
IF Statement

Lookup and Reference

Vlookup, Hlookup, Indirect, Index, Match
Row, Column, Offset, choose, address, Lookup
Transpose.

Other formulas

Sumproduct, Sumif, Sumifs, Countif, Countifs
Averageif, Averageifs, Count, Counta, Round,
Mround, RoundUp, RoundDown, MMULT, Mod, Small
Large, Max, Min

Formulas Auditing

How to calculation all formulas at once.
how to troubleshoot formula and fix it.
What is Circular reference and how to fix it.

Array Formulas

10 complex examples of array formulas
Creating Mega formulas
Using N and — in formulas
Using Wild Card in formulas

Like Challanges?