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
