Twenty19

Login or Create Your Twenty19 Account


New to Twenty19? No Worries. Register for free!

Advanced Excel

Rs 3499 Flash sale

90%

21 Reviews

The course on Advanced Excel is aimed to equip the users to understand and deploy Excel as a tool for productivity enhancement and value addition. Practical issues, faced by the users have been the main focus during the development of the courseware. The course has been designed logically with seven topics to handle the various functions in Excel.

  • Learn Anytime/Anywhere
  • Clear your doubts
  • Project Based
  • Get Certificate

Buy "Advanced Excel"

Rs 3499 Have a Coupon Code ? Click 'Pay Online' & login to apply coupon code

pay online

or

Pay by DD/Cheque

Call us on 09962033243 in case of any difficulties.

  • Step 1 Buy this course by making an online or an offline payment

  • Step 2 Access the course anytime, anywhere, learn, practice, evaluate, clear your doubts & track your progress

  • Step 3 Complete the course & get Twenty19 Certificate

Buy & Start Training or Free Demo

727 views
  1. Chapter 1

  2. Chapter 2

    • 2.1 - Formating and Editing Data
    • 2.2 - Format Rows & Columns
    • 2.3 - Format Worksheet & Workbook
    • 2.4 - Themes in Excel
    • 2.5 - Clipboard Functions
    • 2.6 - Paste Special Functions with Format Painter
    • 2.7 - Formatting Cell Values
    • 2.8 - More on Number Formats
    • 2.9 - Custom Formats
    • 2.10 - Window Functions
    • 2.11 - Freeze Panes
    • 2.12 - Split/Hide Windows
    • 2.13 - View Side by Side
    • 2.14 - Conditional Formatting
    • 2.15 - Conditional Formatting Example 1
    • 2.16 - Conditional Formatting Example 2
    • 2.17 - Graphic Objects
    • 2.18 - Rule Precedence
    • 2.19 - Use Formulas
    • 2.20 - Workbook Views
    • 2.21 - Page Setup
    • 2.22 - Adding Header/Footer
    • Quiz 2
  3. Chapter 3

    • 3.1 - Tables in Excel
    • 3.2 - Data Filters
    • 3.3 - Data Sort
    • 3.4 - Text to Columns
    • 3.5 - Removing Duplicates
    • 3.6 - Data Validation
    • 3.7 - What-If Analysis Data Table & Goal Seek
    • 3.8 - What-If Analysis Scenario Manager
    • 3.9 - Subtotal
    • Quiz 3
  4. Chapter 4

    • 4.1 - Introduction to Formulas
    • 4.2 - Introduction to Functions
    • 4.3 - Logical Functions
    • 4.4 - Text Functions
    • 4.5 - Data & Time Functions
    • 4.6 - Lookup & Reference Functions
    • 4.7 - Mathematical Functions
    • 4.8 - Statistical Functions
    • 4.9 - Array Formulas
    • 4.10 - Define Names
    • 4.11 - Formula Auditing
    • Quiz 4
  5. Chapter 5

    • 5.1 - Macros in Excel
    • 5.2 - Case Study - Macros with VBA Scripts
    • Quiz 5
  6. Chapter 6

    • 6.1 - Pivot Tables & Pivot Charts Introduction
    • 6.2 - Create a Pivot Table
    • 6.3 - Pivot Table Example 1
    • 6.4 - Pivot Table Example with Pivot chart
    • 6.5 - Pivot Table Example 3
    • 6.6 - Customize Pivot Table
    • 6.7 - Expand and Collapse Pivot Table Fields
    • 6.8 - Sorting Pivot Table
    • 6.9 - Grouping Fields in a Pivot Table with Pivot Chart
    • Quiz 6
  7. Chapter 7

    • 7.1 - Introduction to Excel Graphics
    • 7.2 - Chart Types in Excel
    • 7.3 - Modifying Charts
    • 7.4 - Chart Layouts & Chart Styles
    • 7.5 - Chart Elements & Formatting
    • 7.6 - Example - Design and Customizing a Chart
    • 7.7 - Combination Charts
    • 7.8 - Smart Art Graphics
    • Quiz 7
  8. Chapter 8

    • 8.1 - Project
  • About this Training

    The course will cover the topics Share & Protect Data, Formatting & Presentation, Data Analysis & Management. It will take you through advanced topics such as Macros, Pivot Tables and Graphics.

  • Project in this Training

    In the project of the course you will have to apply all the concepts learned through the course.

  • Clear your Doubts

    You can ask all the questions in Clear your Doubts forum anytime, course experts will answer all your questions.

  • Get Certificate

    Receive an E-certificate from us once you complete the course. You can Download the Certificate from your Twenty19 account and also showcase it to your friends and family.

what if analysis

asked by HarshitGupta

No Answers yet

How do you removed all the rows and columns from the sheet and only the contents were displayed?

asked by Ashutoshkumar

You can simply hide the Gridlines and you are done, Sorry for long delay i was back after a year

answered by satyagopalsalagrama, 10 months ago. [ 7th - Dec, 2018 ]

show ink

asked by shivanigehlot

No Answers yet

Why is there no exercise file included?

asked by Ashutoshkumar

No Answers yet

Which version of excel is being used?

asked by Ashutoshkumar

No Answers yet

Can I download the videos & learn?

You can re-watch the videos as many times you wish but we do not allow downloading on our platform as we keep track of your progress in regards to the course you learn.

What is special about Twenty19 courses?

Twenty19 Training are fun to learn and they are structured to be easily understood by anyone.The courses are developed with College students in mind.So courses will have a lot of real world examples and Twenty19 courses are easy to take up and earn a certificate.

If I have any doubt while learning, How can I clear my doubts?

You can raise your doubt in Clear your doubts forum anytime, training experts will answer all your questions. You can also reach us at +91 9962033243 (give us a missed call), send an SMS or drop an email to trainings@twenty19.com, one of our team member will call you to support.

Is it safe to use my debit/credit card for making the payment?

No doubt, Your transaction is always safe and secure with Twenty19.

Do I get a certificate of completion?

Yes!! you will receive an E-certificate from us once you complete the training. You can include this is in your Resume to get placed better.

How will I receive the certificate?

Twenty19 certificates will be emailed to your Twenty19 registered Email ID .The very next day of your training completion you will be receiving the certificate.You can download and print your certificate.

Have Questions? Get in touch with us

Call
+91 9962033243

Email
trainings@twenty19.com

This is a Free Demo for "Advanced Excel" Course

Experience this course with few video lessons rightaway!

Start Learning

Live Trainings Feed

Latest Questions in Forum

Suggest a new Training

Teach

Are you an expert in your industry & are passionate about teaching? Join us!

create a training


This feature is not available during Free Demo. Purchase the course to access

Purchase "Advanced Excel"


Buy & Start Learning

Send me amazing internships by email

Confirmation email has been sent to your email address. Please click on "Confirm to get Internship alerts" button in the email.
Please provide a valid email address.
There were some issues. Please try again later.

Close