Reset Password

Certification in Data Analysis in EXCEL

What You’ll Learn

  • Data Analysis – Process
  • Data Requirements Specification
  • Data Collection
  • Data Cleaning
  • Data Analysis
  • Communication
  • DatSyntax rules for names.
  • Creating names for cell references.
  • Creating names for constants.
  • Managing the names.
  • Scope of your defined names.
  • Editing names
  • Filtering names.
  • Deleting names.
  • Applying names.
  • Using names in a formula.
  • Viewing names in a workbook.
  • Using paste names and paste list.
  • Using names for range intersections.
  • 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
  • Slicers for Tables
  • Removing Unwanted Characters from Text
  • Finding required Text Patterns with the Text Functions
  • Extracting Data Values from Text
  • Extracting Data Values with Convert Text to Columns Wizard
  • Extracting Data Values with Flash Fill
  • Formatting Data with Text Functions
  • 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
  • Extracting Year, Month, Day from Date
  • Extracting Day of the Week from Date
  • Obtaining Date from Year, Month and Day
  • Calculating Number of Years, Months and Days between two Dates
  • Time Formats
  • Converting Times in Serial Format to Hour-Minute-Second Format
  • Converting Times in Hour-Minute-Second Format to Serial Format
  • Obtaining the Current Time
  • Obtaining Time from Hour, Minute and Second
  • Extracting Hour, Minute and Second from Time
  • Number of hours between Start Time and End Time
  • Information about Conditional Formatting
  • Conditional formatting by using Data bar
  • Conditional formatting by using Color Scales
  • Conditional formatting by using icon set
  • Find Duplicate values
  • Highlight Cells Rules
  • Clear Rules
  • Remove Duplicates
  • Conditional Formatting with Formulas
  • Find Triplicates
  • Find Duplicate Rows
  • Shade Alternate Rows
  • Create A Column List of Item in Excel
  • Import A List of Items from Cells
  • Use Your Custom List
  • Edit Or Delete a Custom List
  • Create A Custom List in Excel
  • Quick Sort
  • Multi- Level of Sorting
  • Custom Sort Order
  • Subtotal Function
  • Advance Filter
  • Filter Data from One Worksheet to Another Excel
  • Subtotal
  • Nested Subtotal
  • Subtotal by Sort
  • Subtotal by Filter
  • Formatting
  • Charts
  • Totals
  • Tables
  • Sparklines
×