Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The advanced excel Tools and Techniques – Excel expert
1.00 Day 1: Introduction and general arrangements
1.01 Mindset (4:28)
2.00 Week1: Introduction and foundation of excel.
2.00 Week1: Download practice files
2.01 Excel interface (12:09)
2.02 Cell referencing (17:43)
2.03 Range naming (0:21)
2.041 Math. and trig. Functions: A Frequently used (23:12)
2.042 Lookup and reference functions (24:37)
2.043 Date and time functions (22:38)
2.044 Logical and financial functions (23:04)
2.045 Text functions
2.046 Statistical functions
2.047 Information functions
2.048 Compatibility functions
2.05 Copying data
2.06 Conditional formatting
3.00 Week 2: Advanced features
3.01 Using filter and sorting
3.02 Adv filter and subtotal tool
3.03 Import data & Power query connections
3.04 Smart art
3.05 Spark lines
3.06 Slicer and timelines
3.07 Charts A
3.08 Charts B
3.09 Hyperlinks
4.00 Week 3: Data management
4.01 Data validation and Flashfill
4.02 Find Replace & GoTo
4.03 Auditing - Check references & Formula analysis
4.04 Data table
4.05 Goal seek
4.06 Scenario Manager
4.07 Sharing & editing permission
4.08 Mail merge
4.09 Cell Format
4.10 Short cut keys
5.00 Week 4: Dashboards and macros
5.01 Working with table
5.02 Working with Pivot table
5.03 Security management
5.04 Macros & VBA
5.05 Add-ins
5.06 Create dashboard & automation
5.07 Common errors
5.08 Functions B - Rarely used
2.046 Statistical functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock