Setup Menus in Admin Panel

Course Curriculum

Welcome To Advanced Excel 2016
1.1 Welcome to the course 00:00:00
1.2 Why Excel and why modeling 00:00:00
Proficient Excel Formatting
2.1 Cell styles allows you to be faster 00:00:00
2.2 Filter by color 00:00:00
2.3 Formatting Cells Part I – Working with data in Excel 00:00:00
2.4 Formatting Cells Part II – Customize numbers the way you lik (1) 00:00:00
2.5 Highlight key data with Excel Conditional Formatting 00:00:00
2.6 Let’s start from scratch and create a P&L sheet 00:00:00
2.7 Pasting values, formulas, and formats with Paste Special 00:00:00
How to be 3.0x faster than average users
3.1 Grouping Excel rows and columns – The correct way to do it! 00:00:00
3.2 Use multiple screens simultaneously 00:00:00
3.3 Working on multiple sheets at the same time 00:00:00
Excel mechanics
4.1 A great way to apply Find & Replace 00:00:00
4.2 Circular References – An example 00:00:00
4.3 Find & Replace – Our favourite Excel tool 00:00:00
4.4 Trace precedents – Display the relationship between formulas 00:00:00
4.5 What Are Circular References in Excel 00:00:00
Not so simple Excel Functions
5.1 Advanced Excel functions Choose; Vlookup & Choose 00:00:00
5.2 Advanced Excel functions Index, Match, Match 00:00:00
5.3 Advanced Excel functions Index; Match; Index & Match 00:00:00
5.4 Advanced Excel functions Indirect; Vlookup & Indirect 00:00:00
5.5 Advanced Excel functions Offset; Offset & Match 00:00:00
5.6 Advanced Excel functions Rows; Columns; Vlookup & Columns 3 00:00:00
5.7 Advanced Excel functions Vlookup & Match 00:00:00
5.8 Date functions 00:00:00
5.9 What is a nested function 00:00:00
Excel tips & tricks
6.1 Excel tips & tricks Part 1 00:00:00
6.2 Excel tips & tricks Part 2 00:00:00
6.3 Excel tips & tricks Part 3 00:00:00
6.4 Excel tips & tricks Part 4 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 week, 3 days
1 STUDENTS ENROLLED
Copyright @2019