UrbanPro
true

Advance Excel Training Course

LIVE
Ongoing

Course offered by Nikul Patel

21 reviews

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
  • Formatting worksheets , Securing & Protecting spreadsheets

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
  • PIVOT Tables, NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation

MACROâ??S

  •  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

Gallery (21)

Intro Video

+14 more

About the Trainer

4.9 Avg Rating

21 Reviews

23 Students

9 Courses

Nikul Patel

DIT, DDM, PGDCA

Digital Media Marketing & Web Technology Consultants with 12+ years of experiences in IT Industries, be a part of 500+ multilingual webs projects delivered across the globe and successfully conducted 100+ corporate training & techno consultants. Over a 8 years of experience in leading digital marketing division in organizations with the team size of 30+ people and always mention satisfaction level among client and stakeholders.

Global sourcing and strategic account engagements for various international projects and progressively responsible for setting up of CoE (Center of Excellence) in IT Industries to support online marketing & web solutions, responsible for operation, presales support, technology consultant, knowledge sharing, training and corporate branding for Digital Marketing, Web Technology & BPO Services. (Social Media, Search, Display, Mobile, Analytic (Google & Omniture) Web & BPO Solutions)

Students also enrolled in these courses

LIVE
2 Hours

Course offered by Javrawala Simran

5 reviews
LIVE
40 Hours

Course offered by Himanshu Deoskar

0 review
LIVE
30 Hours

Course offered by Nirav Raval

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

Advance Excel Training Course by Nikul Patel

Nikul Patel 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

Advance Excel Training Course by Nikul Patel

Nikul Patel 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