Course Content
Handling Text with Formulas and Built in Tools
Add a summary of short text to prepare students for the activities for the topic. The text is shown on the course page beside the tooltip beside the topic name.
0/9
Drag the Fill Handle
00:00
Create Your Own Series
00:00
Joining Text
00:00
Rapid Formula Copy
00:00
Convert to Proper Case
00:00
Formulas to Values
00:00
Breaking Apart Text
00:00
Parsing Fixed Width
00:00
Diving into Formulas
Add a summary of short text to prepare students for the activities for the topic. The text is shown on the course page beside the tooltip beside the topic name.
0/2
AutoSum Tricks
00:00
Relative Versus Absolute Formulas
0/2
Tables and Table Formulas
00:00
Goal Seek
00:00
Diving into Formulas Advanced
0/5
IF Formulas
00:00
Lookups
00:00
Date and Time
00:00
SumIfs
00:00
Charting and SmartArt
0/8
Creating and Formatting a Chart
00:00
Adding or Removing Chart Data
00:00
Saving Favorite Chart Settings
00:00
Charting Differing Orders of Magnitude
00:00
Pie Chart Tricks
00:00
Sparklines
00:00
Creating SmartArt
00:00
Visual Impact
0/3
Color Scales, Icon Sets, Data Bars
00:00
Icons for Only a Subset
00:00
Paired Bar Charts with Negative Data Bars
00:00
Sorting & Filtering
0/6
Data Preparation
00:00
One-Click Sorting
00:00
Sorting by Color
00:00
Filter by Selection
00:00
Other ways to Filter
00:00
Pivot Table
0/14
Pivot Table Begins
00:00
Changing and Updating a Pivot Table
00:00
Pivot Table Design and Chartings
00:00
Adding Slicer the New Filter
00:00
Muliple Slicer
00:00
Top 5 Customers
00:00
Adding Timeline and Spicing up the Dashoard
00:00
Show Min Max Average and Percentage
00:00
Spice up your pivot table with Conditional Formatting
00:00
Calculated Fields
00:00
Get Pivot is not evil
00:00
Drill Down Feature
00:00
Grouping Data
00:00
Generate 20 Reports in Just couple of clicks
00:00
Advanced Pivot Tables
0/3
Data Consolidation in Pivot Table
00:00
Join Multiple tables using data model
00:00
Find Unique Items through data model
00:00
PowerPivot
0/6
What is BI
00:00
What is powerpivot
00:00
Why PowerPivot
00:00
Exploring the PowerPivot Options
00:00
Dax Version of Sumif
00:00
Actual vs Budget Report
00:00
Power Query (Now Data Import)
0/1
Import Data from a Folder
00:00
Import Data using Load To Option
0/2
Importing Data from a folder
00:00
Clean Your Unstructured Data through Data Transform
00:00
Recording Macros
0/4
Displaying the Developer Tab
00:00
Recording a Simple Macro
00:00
Simplifying the Macro
00:00
Keys to Successful Recording
00:00
Solver
0/2
Solver Setup
00:00
What if Scenario
00:00
Tips & Tricks
0/21
Removing Duplicates
00:00
Copying Sheets
00:00
Working In Group Mode
00:00
Excel as word processor
00:00
Text Box Trick
00:00
Shrink Text
00:00
Transposing Tricks
00:00
Insert Blank Rows
00:00
Hide Data
00:00
Important Sheet
00:00
Data Validation
00:00
Fill up in the sideways
00:00
Switch Column Trick
00:00
Fill Blank Trick
00:00
Pick from List
00:00
Formula to Value
00:00
F4 trick
00:00
Format Part of Cell
00:00
Print Small Selection
00:00
Fit to One Page Trick
00:00
Speak Cells
00:00
Up and Running with Excel
Previous
Next
0% Complete
Analytic Hub
Analytic Hub specializes in Power BI training and consultancy, offering expert-led courses, premium support, and tailored solutions. Our commitment to excellence ensures you achieve your data analytics goals with confidence and success.