daac-courses

Advance Excel

Advance Excel

Are you looking for the best Advance Excel Training in Jaipur ? Get the most comprehensive, basic and advanced level Excel training in Jaipur. Skill Level. Beginner. We are providing Training to the needs from Beginners level to Experts level,with real-time projects and working models.

DAAC Offering Deep level understanding about the course by Adding Advanced level of concepts to Our ADV EXCEL Course Curriculum . We just don’t Provide Advance Excel course we help you to understand the Technology from the Scratch level to Advanced level by Ensuring All the Advanced Topics during your Learning Journey with us.

So if you are the one who is searching for the Best ADVANCE EXCEL training institute in Jaipur /EXCEL training near me/EXCEL training in Mansarovar / Vidhyadhar Nagar / C Scheme . Enroll to Our Advance Excel course Today itself.

Course Feature

Advance Excel

  • Duration 1 Months
  • Class Timings 1.5 hour a day, 5 days a week
  • Eligibility

Module - I

Basic Excel

  • Text to Columns
  • Concatenate
  • The Concatenate Function
  • The Right Function with Concatenation
  • Absolute Cell References
  • Data Validation
  • Time and Date Calculations
  • Conditional Formatting
  • Exploring Styles and Clearing Formatting
  • Using Conditional Formatting to Hide Cells
  • Using the IF Function
  • Pivot Tables
  • Creating a Pivot Table
  • Specifying PivotTable Data
  • Changing a PivotTables Calculation
  • Filtering and Sorting a PivotTable
  • Creating a PivotChart
  • Formatting and Aligning Numbers
  • Formatting the Plot Area
  • Formatting Data Markers
  • Pie Charts
  • Creating a Pie Chart
  • Moving the Pie Chart to its Own Sheet
  • Adding Data Labels
  • Exploding a Slice of a Pie Chart
  • Data Analysis − Overview
  • Types of Data Analysis
  • Data Analysis Process
  • Working with Range Names
  • Range Name Syntax Rules
  • Creating Range Names
  • Creating Names for Constants
  • Managing Names
  • Scope of a Name
  • Grouping Items
  • Updating a PivotTable
  • Formatting a PivotTable
  • Using Slicers
  • Charts
  • Creating a Simple Chart
  • Charting Non-Adjacent Cells
  • Creating a Chart Using the Chart Wizard
  • Modifying Charts
  • Moving an Embedded Chart
  • Sizing an Embedded Chart
  • Changing the Chart Type
  • Chart Types
  • Changing the Way Data is Displayed
  • Moving the Legend
  • Formatting Charts
  • Adding Chart Items
  • Formatting All Text
  • Editing Names
  • Applying Names
  • Using Names in a Formula
  • Viewing Names in a Workbook
  • Copying Formulas with Names
  • Difference between Tables and Ranges
  • Create Table
  • Table Name
  • Managing Names in a Table
  • Table Headers replacing Column Letters
  • Propagation of a Formula in a Table
  • Resize Table
  • Remove Duplicates
  • Convert to Range
  • Table Style Options
  • Table Styles
  • Cleaning Data with Text Functions
  • Removing Unwanted Characters from Text
  • Extracting Data Values from Text
  • Formatting Data with Text Functions
  • Changing the “Value if false” Condition to Text
  • Copying Name using Formula Autocomplete
Minor Exam and Project

Module - II

Date Formats

  • Converting Dates in Serial Format to Month-Day-Year Format
  • Converting Dates in Month-Day-Year Format to Serial Format
  • Obtaining Today’s Date
  • Finding a Workday after Specified Days
  • Customizing the Definition of a Weekend
  • Extracting Year, Month, Day from Date
  • Extracting Day of the Week from Date
  • Obtaining Date from Year, Month and Day
  • Calculating Years, Months and Days between two dates
  • Number of Workdays between two given dates
Minor Exam and Project

Module - III

Conditional Formatting

  • Highlight Cells Rules
  • Top / Bottom Rules
  • Data Bars
  • Color Scales
  • Icon Sets
  • New Rule
  • Clear Rules
  • Manage Rules
Minor Exam and Project

Module - IV

Sorting

  • Sort by Text
  • Sort by Numbers
  • Sort by Dates or Times
  • Sort by Cell Color
  • Sort by Font Color
  • Sort by Cell Icon
  • Sort by a Custom List
  • Sort by Rows
  • Sort by more than one Column or Row
Minor Exam and Project

Module - V

Filtering

  • Filter by Selected Values
  • Filter by Text
  • Filter by Date
  • Data Analysis with Excel
  • Filter by Numbers
  • Filter by Cell Color
  • Filter by Font Color
  • Filter by Cell Icon
  • Clear Filter
  • Advanced Filtering
  • Filter Using Slicers
Minor Exam and Project

Module - VI

Other Topics

  • Subtotals with Ranges
  • Subtotals
  • Nested Subtotals
  • Quick Analysis
  • Quick Analysis with TOTALS
  • Sum
  • Average
  • Count
  • %Total
  • Running Total
  • Sum of Columns
Minor Exam and Project

Module - VII

Lookup Functions

  • Using VLOOKUP Function with range lookup TRUE
  • Using INDEX Function
  • Using MATCH Function
  • Using VLOOKUP Function
  • Using HLOOKUP Function
  • Using VLOOKUP Function with range lookup FALSE
  • Using HLOOKUP Function with range lookup FALSE
  • Using HLOOKUP Function with range lookup TRUE
Minor Exam and Project

Module - VIII

Pivoting

  • PivotTables
  • Creating PivotTable
  • Recommended PivotTables
  • PivotTable Fields
  • PivotTable Areas
  • Nesting in the PivotTable
  • Filters
  • Slicers
  • Summarizing Values by other Calculations
  • PivotTable Tools
  • Using Pictures in Column Charts
  • Band Chart
  • Thermometer Chart
  • Gantt Chart
  • Waterfall Chart
  • Sparklines
  • Pivot Charts
  • PivotChart from PivotTable
  • PivotChart without a PivotTable
  • Working with Multiple Sheets
  • Multiple Worksheets with same Structure
  • Creating a Formula across Multiple Worksheets
  • Summarizing Data in Multiple Worksheets
  • What-If Analysis
Major Exam and Project

Powered by Froala Editor

Skills Certificate
From the DAAC

Get In Touch
Related Courses

Highlights of Related Courses in Jaipur

Discover Our App

Access your courses anywhere, anytime & prepare with practice tests