UrbanPro
true

Advanced Excel Training

LIVE
1 review
40 Hours

Course offered by Respro Academy

5 reviews


COURSE CONTENT FOR ADV XL

 

  • Introduction
  • Overview: A hands-on introduction

DURATION:20 HOURS

  • Lesson 1: Whatâ??s changed, and why
  • Lesson 2: Get to work in Excel
  • Lesson 3: A new file format
  • Excel Options
  • Exercise & Test
  • Create your first workbook
  • Overview: Where to begin?
  • Lesson 1: Introduction to workbook
  • Lesson 2: Enter data
  • Lesson 3: Edit data and revise worksheets
  • Lesson 4: Paste Special commands
  • Lesson 5: Page layout commands
  • Lesson 5: Workbook views
  • Graphical Representation of Data
  • Overview: Charts make data visual
  • Lesson 1: Create a basic chart
  • Lesson 2: Customize / Formatting charts
  • Lesson 3: Inserting Word Art, Links, Picture Clip & Smart Arts
  • Smart Art Graphics
  • Design & Format
  • Sort & Filter Commands
  • Sorting & Filter
  • Advanced Sorting & Filter Options
  • Customization of Sorting & Filter


 

  • Visual Analysis : Conditional Formatting
  • Creating rules
  • Managing the rules
  • Working with pre-set conditions
  • Get started with PivotTable Reports
  • Overview: Make sense out of data
  • Lesson 1: Make your data work for you
  • Lesson 2: Generating report
  • Mathematical / Statistical Functions
  • Lesson 1: Get started
  • Lesson 2: Use cell references
  • Lesson 3: Formula Auditing
  • Lesson 3: Simplify formulas by using functions
  • Lesson 4: Logical Functions (only main commands will be discussed)
  • Lesson 5: Lookup & Reference Commands (only main commands will be discussed)
  • Working with Data Tools
  • Text to Columns
  • Consolidate
  • What if Analysis (Goal Seek, Scenario Manager & Data Table)
  • Data Validation
  • Mathematical Functions
  • Lesson 1: Get started
  • Lesson 2: Use cell references
  • Lesson 3: Simplify formulas by using functions
  • Work Book Protection
  • Lesson 1: Locking / unlocking data Cells
  • Lesson 2: Worksheet Protection
  • Introduction to Macros
  • What is Macro?
  • Recording a Macro
  • Viewing and Editing Macro

Case study: Covers the above topic

About the Trainer

4.6 Avg Rating

5 Reviews

27 Students

3 Courses

10 yrs of IT experience.

Students also enrolled in these courses

LIVE
9 reviews
25 Hours

Course offered by Bhavna Philipose

10 reviews
LIVE
2221 reviews
24 Hours

Course offered by Aadi P Swamy

1567 reviews
LIVE
4 reviews

Course offered by Rashmi Sachdeva

18 reviews
LIVE
16 reviews
1 Hours

Course offered by Rashmi Sachdeva

18 reviews

Reviews (1)

1 out of 5 1 review

Respro Academy https://www.urbanpro.com/assets/new-ui/institute-100X100.png Arekere, Banerghatta Road
1.0051
Respro Academy
M

Microsoft Excel Training

"Great place for learning,experienced faculty.I like their teaching style.They are dedicated to provide basic to advanced function.They give more attention to every student.I gained my knowledge in basic to advance Excel.Thanks to Respro. "

View All
Have you attended any class with Rashmi?

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

Different batches available for this Course

1 out of 5 1 review

Respro Academy https://www.urbanpro.com/assets/new-ui/institute-100X100.png Arekere, Banerghatta Road
1.0051
Respro Academy
M

Microsoft Excel Training

"Great place for learning,experienced faculty.I like their teaching style.They are dedicated to provide basic to advanced function.They give more attention to every student.I gained my knowledge in basic to advance Excel.Thanks to Respro. "

Have you attended any class with Rashmi?

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

Advanced Excel Training by Respro Academy

Aruna Dadhich picture
LIVE
(1 reviews)

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

Advanced Excel Training by Respro Academy

Aruna Dadhich picture
LIVE
(1 reviews)

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