UrbanPro
true

Basic and Advance Excel Training

LIVE
Ongoing

Course offered by Minal Jaiswal

0 review

The course will be 1 hour daily course. The course will include following content. The content may be added or removed based on requirement.

 

BASIC Microsoft Excel :

  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphs
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Working with functions & formulae Formatting worksheets , Securing & Protecting spreadsheets


ADVANCED Excel Course Contents :

Formulas & Macros Formulas:

  • Use the Function Wizard, Common functions
  • (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references : >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function , Date and time functions , Annotating formulas


DATA Analysis :

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt


Functions : LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF

  • What-if-analysis
  • GOAL SEEK
  • NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation


PIVOT TABLES :

  • Enter the Pivot Table Data
  • Create the Pivot Table
  • Adding Data to the Pivot Table
  • Filtering the Pivot Table Data
  • Change the Pivot Table Data
  • Analyze Data Columns in Pivot Tables
  • Adjust Data to Analyze


MACROâ??S ( Int ) :

  • Macros
  • Definition and use, Record a macro
  • Assign a macro, Run a macro
  • Store a macro, Introduction to VBA Prog.


Develop the Worksheet :

  • Plan a worksheet , Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars , Enhance worksheet Appearance


Special Operations :

  • Use multiple windows : Copy/ paste between Worksheets
  • Link worksheets , Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat : Create, use and modify styles and templates
  • Print features : Create /edit an outline
  • Graphic Operations:
  • Create charts , Enhance charts, Drawing toolbar features

About the Trainer

Minal Jayswal picture

Avg Rating

0 Reviews

0 Students

1 Courses

Minal Jaiswal

M.C.M

3 Years of Experience

ï?· Trainer has live project working experience on C#

Students also enrolled in these courses

LIVE
30 Hours

Course offered by Sujata Salunkhe

0 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Basic and Advance Excel Training by Minal Jaiswal

Minal Jayswal picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Basic and Advance Excel Training by Minal Jaiswal

Minal Jayswal picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more