Best offline computer training courses in jaipur. Learn advance excel and advance excel formula

Advance Excel

Duration : 1 Month


Interest recruiters by adding Advance Excel in your Resume! Master Advance Excel


TIFA Education is the leading and most Prolific TIFA Education Pvt Ltd Jaipur providing an affordable in-person Advance Excel Course and guidance by trained Accountant. We guide people from every background to change their lives via our career-oriented courses in Jaipur. Our offline course primarily focus on college students and full/part-time employees. TIFA Education is best advance Excel institute in Jaipur.

Interested To Know More? Speak To Our Expert Academic Counsellor Now! CALL NOW

Course Highlight :-

  • Introduction
  • Getting Started
  • Explore Window
  • Office Button
  • Quick Access Toolbar
  • Mini Toolbar
  • Title, Zoom and View
  • Introduction
  • Getting Started
  • Explore Window
  • Office Button
  • Quick Access Toolbar
  • Mini Toolbar
  • Title, Zoom and View
  • Creating Formula
  • Copying Formula
  • Reference Formula
  • Error Show in Formula
  • Function Arguments Formula
  • Text Alignment
  • Text Decoration
  • Merges & Wrap
  • Rotate Cells
  • Borders and Shades
  • Setting Colours
  • Setting Fonts
  • Setting Cell Type
  • Applying Formatting
  • Style & Theme
  • Operators Functions
  • Numeric Functions
  • Text Functions
  • Statistical Functions
  • Date & Time Functions
  • Mark Sheet Table Simple Level
  • Mark Sheet Table Advance Level
  • Logical Functions {AND, OR, NOT}
  • Conditional Functions {IF, Nested IF, IF Error}
  • Mathematical Functions {COUNTIF, COUNTIFS, SUMIF, SUMIFS, SUMPRODUCTION}
  • Lookup Functions {VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE}
  • Financial Functions {PV, FV, PMT, IPMT, PPMT, RATE}
  • Insert Smart Art
  • Add Text Smart Art
  • Insert Pictures
  • Insert Clip Art
  • Format Picture
  • Insert Word Art
  • Format Word Art
  • Insert Lists
  • Insert Shapes & Format Shapes
  • Sheet Options
  • Adjustment Margins
  • Page Orientation
  • Header and Footer
  • Insert Page Breaks
  • Set Background
  • Freeze Panes
  • Print Setup
  • Security
  • E-Mail & Mail-Merge
  • Creating Charts
  • Editing Charts
  • Formatting Charts
  • Combination Charts
  • Using 3D Charts
  • Dynamically Charts
  • Using Secondary Axis in Graphs
  • Sharing Charts with Power Point/MS. Word
  • Charts Modified/Updated
  • Creating Pivot Table
  • Formatting Pivot Table
  • Customizing Pivot Table
  • Slicers Pivot Table
  • Grouping Data in Pivot Table
  • Pivot Table Charts
  • Define Name Range
  • Data Sorting and Filtering
  • Data Validation
  • Create Macros
  • Run Macros
  • Edit Marcos
  • Save Marco
  • Home Tab
  • Insert Tab
  • Page Layout Tab
  • Formulas Tab
  • Data Tab
  • Review Tab
  • View Tab
  • Home Cleaning Checklist
  • Packing Checklist
  • Contact List
  • Customer List
  • Simple Interest Loan Calculator
  • Loan Amortization
  • Home Budgets
  • Simple Invoices
  • Expenses Reports
  • Home Inventory
  • Salary Sheet (Days Wise)
  • Salary Wise (Time Wise)
  • Timesheets Calculators
  • Age Calculators
  • Do List (Drop Down List)
  • Simple Budgets
  • Stock Maintain Inventory
  • Attendance Sheet
  • Allowance & Deduction Calculation

Experience and Inspiring Trainers:

Our instructors bring their industry experienced years to use during the course. They are both expert and enthusiastic about presenting an impelling training as they are aware of every aspect of training. They can also advise you on all the options to make sure you get the best result possible.

Real-time Practice and Projects:

Our Advance Excel Courses are both thorough and efficient. We usually work on industry-associated projects. If you have a project or an idea then you can share it with our instructor after completion of the course and they will help you to work on it.

Prerequisites for Advance Excel course:

It is essential to know the basics of computer knowledge.

Certificate:

After ending this training, you will also get a course completion certificate in the Advance Excel to gain recognition from newly adaptable new skills.

Support and Careers Advice:

Our instructors are always willing to help you with any issues or questions concerning Advance Excel Spring-Hibernate. We qualify students for facing Interview questions on a given technology and help to build their online portfolio. As more than 70% of students are placed in reliable and reputed MNCs.