advance excel-01

Description About

Advance Excel

Microsoft Excel is a helpful and powerful program for data analysis and documentation.

What this Program offers

Get the freedom to choose what, where and when to start your learning journey

You will now be able to finish your targets on your own learning pace

Now its time to get equip yourself with the lessons, mentored, by The Tech Destiny Mentors

Your hard work and dedication will be awarded by certificates that will be recognized by The Tech Destiny

Topics will be Covered In this Course

Topics to be Covered

  • Introduction
  • Interface
  • Tabs and Ribbons
  • Document Windows
  • Navigation Tips
  • Office Button and Save
  • Introduction
  • Entering Data
  • Fonts, Fills, and Alignment
  • Cut, Copy, and Paste
  • Paste Special
  • Undo and Redo
  • Moving, Finding, and Replacing a Value
  • Cell Styles
  • Comments
  • Introduction
  • Currency Format
  • Format Painter
  • Formatting Dates
  • Custom and Special Formats
  • Introduction
  • Naming and Moving Worksheets
  • Copying Worksheets
  • Adding, Deleting and Hiding Worksheets
  • Grouping Worksheets 
  • Moving, Copying, Deleting and Hiding Grouped Worksheets
  • Introduction
  • Inserting and Deleting Columns and Rows
  • Inserting & Deleting Cells
  • Inserting Multiple Columns & Rows 
  • Modifying Cell Width and Height
  • Hiding and Unhiding Rows and Columns
  • Introduction
  • Using Operations
  • Creating Formulas
  • AutoSum
  • Common Formulas
  • Searching for Formulas
  • Copying Formulas
  • Using Relative and Absolute References
  • Introduction
  • Workbook Views
  • Show/Hide
  • Zoom Features
  • Freeze Panes
  • Split Windows
  • Viewing Multiple Windows
  • Minimize The Ribbon
  • Worksheet Backgrounds
  • Watermarks
  • Introduction 
  • AutoFill a Series
  • AutoFill Non-Adjacent Cells
  • AutoFill on Multiple Sheets
  • Creating Custom Lists
  • Series Formating


  • Introduction
  • Highlight Cells Rules
  • Top/Bottom Rules
  • Data Bars
  • Color Scales
  • Custom Formatting Rule
  • Introduction
  • Insert a Table and Style Options
  • Add Rows and Columns
  • Perform a Function in a Table
  • Summarise With Pivot Table
  • Introduction
  • Data Validation
  • Drop-Down Lists
  • Removing Duplicates
  • Text To Columns
  • Goal Seek
  • Scenario Manager
  • Introduction
  • Multiple Sheet References
  • Consolidating Data – With or Without Links
  • Trace the Precedents and Dependents
  • Using the Watch Window
  • Introduction
  • Cell Names
  • Named Ranges
  • Formulas with Cell Names
  • Date Formulas
  • Introduction
  • VLOOKUP Exact Match
  • HLOOKUP Exact Match
  • Introduction
  • IF Statement
  • Nested IF
  • AND
  • OR
  • NOT
  • SUM IF
  • Introduction
  • Case Formulas
  • Fix Number Fields
  • Trim Spaces
  • Substitute Text
  • Introduction 
  • Chart Types
  • Instant Chart
  • Update Chart
  • Picture Fill
  • Adjust Chart Size
  • Line Chart
  • Scatter Chart
  • Introduction
  • Chart Styles
  • Chart Layouts
  • Add Labels
  • Axis Options
  • Chart Title
  • Legends
  • Data Labels
  • Introduction
  • Insert Pictures
  • Modifying pictures
  • Insert Shapes
  • Insert SmartArt
  • Apply Themes
  • Arrange
  • Introduction
  • Group and Ungroup
  • Sort Data
  • Sort Multiple Levels
  • Filter Data
  • Advanced Filter
  • Conditional Sorting and Filtering
  • Sorting with Custom Lists
  • Subtotal
  • Introduction
  • Creating PivotTables
  • Choosing Fields
  • Pivot Table Layout 
  • Filtering Pivot Tables
  • Modifying Pivot Table Data
  • Pivot Charts
  • Introduction 
  • Workbook Passwords
  • Protecting Workbooks
  • Unlocking Cells
  • Introduction
  • Document Properties
  • Inserting Hyperlinks
  • Sharing a Workbook
  • Track Changes
  • Accept/ Reject Changes
  • Mark as Final
  • Introduction 
  • Page Orientation
  • Page Breaks 
  • Print Area
  • Margins
  • Print Titles
  • Headers and Footers
  • Scaling 
  • Sheet Options
  • Introduction
  • Save As Previous Version
  • Auto Recover Save Options
  • Templates
  • Save As PDF
  • Save As Web Page
  • Macro-Enabled Workbook
  • Introduction and Macro Security
  • Recording a Macro
  • Assign a Macro to a Button or Shape
  • Run a Macro upon Opening a Workbook
  • How to Inspect and Modify a Macro

Choose Your Plan

Industry Expert

Redirect Your Destiny

₹ 11,999

Live Class

Problem Solving Assessments

Doubt Session


Letter of Recommendation

LMS access

Capstone Projects 2

Placement Assistance

Resume Building

Personality Development

Self Expert

Redirect Your Destiny

₹ 7,999

45+ Recorded Session

Problem Solving Assessments

Doubt Session


Letter of Recommendation

LMS access

Capstone Projects 2

Certified Courses

Industry Verified Certificates


Upgrade your Resume


Performance-Based Recognition


Achieve Domain Excellence


Advance Excel

    Our Hiring Partners


    What Students Say About us 


    Common Questions Asked

    The Tech Destiny is a new-age e-learning platform that focuses on benefitting the students with not only theoretical but practical knowledge as well. We offer online boot camps that can provide undergraduates and graduates, looking to advance their careers, with hands-on experience in the current industry requirements. Our students work on real-time projects with their mentors and gain insights into the current demand of recruiters’ needs, additionally, this helps them add weight to their resumes. But only working on projects is not enough, so we push them a step ahead.

    Our training programs are curated and led by industry experts with more than 1O years of experience in their field. Working with professionals with a load of experience on their backs allows the aspirants to have an in-depth knowledge of the industry. This Bootcamp focuses on imparting not only key technical skills and knowledge, but also gaining an understanding of the work environment through internships. So when you step foot into the industry, you are already packed with all the required skills and enough experience.

    Would you like to take part in our program, but aren’t sure that it would be a good fit for you? Our program is tailored in such a way that the Aspirants interested in any domain irrespective of their backgrounds, such as recent graduates, freshers, students, technology professionals, and non-technical professionals, are welcome to enroll in this program. We begin with strengthening your fundamentals and gradually take you through the Necessary modules and provide you with 24/7 help to finally turn you into a Master of your field.

    This Bootcamp is a life-changing experience in itself as we can make you job-ready within 2 months of taking up the program, and not only that, we ensure our students land their dream job with our connection with 4O+ MNCs and placement assistance. So no matter where are you in your life, we will help you reach your destiny and make a fortune out of it.

    Apart from Industrial training and Internationally valid certification, you get the opportunity to try your hands in a real-time work environment with an internship provided in the third month with placement assistance so you are ready to set your foot into the industry and land your dream job. You get trained by top mentors from the industry with a decade of experience on their back and our soft skills professionals help you ace any interview by leaving the nervousness outside the door and bringing out your best self.

    There is an alarming 48% unemployment rate among engineers, a 93% unemployment rate for MBAs, and a 35% unemployment rate for graduates (with multiple degrees). This is not due to a lack of knowledge, but rather to a lack of exposure and experience. In addition to being outdated, Indian curriculums do not provide much practical information. Instead of teaching students, Tech Destiny aims to prepare them to be job-ready, with all the prerequisites for employment. We ensure that after our program, our students meet the professional standards required by top recruiters across the globe. We start with the fundamentals of the subject matter, so aspirants can gain a solid grounding in their field of choice regardless of their background.

    You can find us here

    No 108, 27th Main Road, Sector 2 HSR Layout, Bengaluru, Karnataka 560102

    contact us
    +91 9606943790