Up and Running with Excel Create Your Own Series
Up and Running with Excel
0% Completed
Handling Text with Formulas and Built in Tools
Drag the Fill Handle
Video - 00:00 mins
Create Your Own Series
Video - 10:30:01 mins
Joining Text
Video - 00:00 mins
Rapid Formula Copy
Video - 00:00 mins
Convert to Proper Case
Video - 00:00 mins
Formulas to Values
Video - 00:00 mins
Breaking Apart Text
Video - 00:00 mins
Parsing Fixed Width
Video - 00:00 mins
Diving into Formulas
AutoSum Tricks
Video - 00:00 mins
Relative Versus Absolute Formulas
Tables and Table Formulas
Video - 00:00 mins
Goal Seek
Video - 00:00 mins
Diving into Formulas Advanced
IF Formulas
Video - 00:00 mins
Lookups
Video - 00:00 mins
Date and Time
Video - 00:00 mins
SumIfs
Video - 00:00 mins
Charting and SmartArt
Creating and Formatting a Chart
Video - 00:00 mins
Adding or Removing Chart Data
Video - 00:00 mins
Saving Favorite Chart Settings
Video - 00:00 mins
Charting Differing Orders of Magnitude
Video - 00:00 mins
Pie Chart Tricks
Video - 00:00 mins
Sparklines
Video - 00:00 mins
Creating SmartArt
Video - 00:00 mins
Visual Impact
Color Scales, Icon Sets, Data Bars
Video - 00:00 mins
Icons for Only a Subset
Video - 00:00 mins
Paired Bar Charts with Negative Data Bars
Video - 00:00 mins
Sorting & Filtering
Data Preparation
Video - 00:00 mins
One-Click Sorting
Video - 00:00 mins
Sorting by Color
Video - 00:00 mins
Filter by Selection
Video - 00:00 mins
Other ways to Filter
Video - 00:00 mins
Pivot Table
Pivot Table Begins
Video - 00:00 mins
Changing and Updating a Pivot Table
Video - 00:00 mins
Pivot Table Design and Chartings
Video - 00:00 mins
Adding Slicer the New Filter
Video - 00:00 mins
Muliple Slicer
Video - 00:00 mins
Top 5 Customers
Video - 00:00 mins
Adding Timeline and Spicing up the Dashoard
Video - 00:00 mins
Show Min Max Average and Percentage
Video - 00:00 mins
Spice up your pivot table with Conditional Formatting
Video - 00:00 mins
Calculated Fields
Video - 00:00 mins
Get Pivot is not evil
Video - 00:00 mins
Drill Down Feature
Video - 00:00 mins
Grouping Data
Video - 00:00 mins
Generate 20 Reports in Just couple of clicks
Video - 00:00 mins
Advanced Pivot Tables
Data Consolidation in Pivot Table
Video - 00:00 mins
Join Multiple tables using data model
Video - 00:00 mins
Find Unique Items through data model
Video - 00:00 mins
PowerPivot
What is BI
Video - 00:00 mins
What is powerpivot
Video - 00:00 mins
Why PowerPivot
Video - 00:00 mins
Exploring the PowerPivot Options
Video - 00:00 mins
Dax Version of Sumif
Video - 00:00 mins
Actual vs Budget Report
Video - 00:00 mins
Power Query (Now Data Import)
Import Data from a Folder
Video - 00:00 mins
Import Data using Load To Option
Importing Data from a folder
Video - 00:00 mins
Clean Your Unstructured Data through Data Transform
Video - 00:00 mins
Recording Macros
Displaying the Developer Tab
Video - 00:00 mins
Recording a Simple Macro
Video - 00:00 mins
Simplifying the Macro
Video - 00:00 mins
Keys to Successful Recording
Video - 00:00 mins
Solver
Solver Setup
Video - 00:00 mins
What if Scenario
Video - 00:00 mins
Tips & Tricks
Removing Duplicates
Video - 00:00 mins
Copying Sheets
Video - 00:00 mins
Working In Group Mode
Video - 00:00 mins
Excel as word processor
Video - 00:00 mins
Text Box Trick
Video - 00:00 mins
Shrink Text
Video - 00:00 mins
Transposing Tricks
Video - 00:00 mins
Insert Blank Rows
Video - 00:00 mins
Hide Data
Video - 00:00 mins
Important Sheet
Video - 00:00 mins
Data Validation
Video - 00:00 mins
Fill up in the sideways
Video - 00:00 mins
Switch Column Trick
Video - 00:00 mins
Fill Blank Trick
Video - 00:00 mins
Pick from List
Video - 00:00 mins
Formula to Value
Video - 00:00 mins
F4 trick
Video - 00:00 mins
Format Part of Cell
Video - 00:00 mins
Print Small Selection
Video - 00:00 mins
Fit to One Page Trick
Video - 00:00 mins
Speak Cells
Video - 00:00 mins
Announcements Reviews Course Info
PreviousNext