Setup Menus in Admin Panel

Course Curriculum

1.1 Course Structure & Outline
1.1 Course Structure & Outline Details 00:00:00
1.2 Resource Files and Datasets
1.2 Resource Files and Datasets Details 00:00:00
1.3 Bonus Extra Homework Exercises
1.3 Bonus Extra Homework Exercises Details 00:00:00
2.1 Excel Introduction
2.1 Excel Introduction Details 00:00:00
2.2 The Formula Library & Auditing Tools
2.2 The Formula Library & Auditing Tools Details 00:00:00
2.3 Demo Using the Evaluate Formula Tool
2.3 Demo Using the Evaluate Formula Tool Details 00:00:00
2.4 Basic Formula Syntax
2.4 Basic Formula Syntax Details 00:00:00
2.5 Fixed, Relative, & Mixed References
2.5 Fixed, Relative, & Mixed References Details 00:00:00
2.6 Common Errors & the IFERROR statement
2.6 Common Errors & the IFERROR statement Details 00:00:00
2.7 Function, CTRL & ALT Shortcuts
2.7 Function, CTRL & ALT Shortcuts Details 00:00:00
2.8 Bonus Shortcuts for Mac Users
2.8 Bonus Shortcuts for Mac Users Details 00:00:00
2.9 Creating Custom Data Validation Rules
2.9 Creating Custom Data Validation Rules Details 00:00:00
2.10 Fixed vs. Volatile Functions
2.10 Fixed vs. Volatile Functions Details 00:00:00
2.11 Homework Formulas 101
2.11 Homework Formulas 101 Details 00:00:00
3.1 Introduction
3.1 Introduction Details 00:00:00
3.2 Anatomy of the IF Statement
3.2 Anatomy of the IF Statement Details 00:00:00
3.3 Nested IF Statements
3.3 Nested IF Statements Details 00:00:00
3.4 AND OR Operators
3.4 AND OR Operators Details 00:00:00
3.5 NOT vs. "<>"
3.5 NOT vs. “<>“ Details 00:00:00
3.6 Fixing Errors with IFERROR
3.6 Fixing Errors with IFERROR Details 00:00:00
3.7 Common IS Statements
3.7 Common IS Statements Details 00:00:00
3.8 Homework Logical Operators
3.8 Homework Logical Operators Details 00:00:00
4.1 Introduction
4.1 Introduction Details 00:00:00
4.2 Basic Statistical Functions
4.2 Basic Statistical Functions Details 00:00:00
4.3 SMALL LARGE & RANKPERCENTRANK
4.3 SMALL LARGE & RANKPERCENTRANK Details 00:00:00
4.4 RAND() & RANDBETWEEN
4.4 RAND() & RANDBETWEEN Details 00:00:00
4.5 The SUMPRODUCT Function
4.5 The SUMPRODUCT Function Details 00:00:00
4.6 COUNTIFSSUMIFSAVERAGEIF
4.6 COUNTIFSSUMIFSAVERAGEIF Details 00:00:00
4.7 Project Showcase Building a Basic Dashboard with COUNTIFS & SUMIFS
4.7 Project Showcase Building a Basic Dashboard with COUNTIFS & SUMIFS Details 00:00:00
4.8 Homework Statistical Functions
4.8 Homework Statistical Functions Details 00:00:00
5.1 Lookup Introduction
5.1 Lookup Introduction Details 00:00:00
5.2 Working with Named Arrays
5.2 Working with Named Arrays Details 00:00:00
5.3 ROWROWS & COLUMNCOLUMNS
5.3 ROWROWS & COLUMNCOLUMNS Details 00:00:00
5.4 VLOOKUPHLOOKUP
5.4 VLOOKUPHLOOKUP Details 00:00:00
5.5 Joining Data with VLOOKUP
5.5 Joining Data with VLOOKUP Details 00:00:00
5.7 VLOOKUP Reference Array Options
5.7 VLOOKUP Reference Array Options Details 00:00:00
5.8 The INDEX Function
5.8 The INDEX Function Details 00:00:00
5.9 The MATCH Function
5.9 The MATCH Function Details 00:00:00
5.10 Using INDEX & MATCH together
5.10 Using INDEX & MATCH together Details 00:00:00
5.11 Combining MATCH with VLOOKUP
5.11 Combining MATCH with VLOOKUP Details 00:00:00
5.12 Update VLOOKUP Correction
5.12 Update VLOOKUP Correction Details 00:00:00
5.13 The OFFSET Function
5.13 The OFFSET Function Details 00:00:00
5.14 Combining OFFSET with COUNTA to return a variable list
5.14 Combining OFFSET with COUNTA to return a variable list Details 00:00:00
5.15 Project Showcase Using OFFSET to create a dynamic scrolling chart
5.15 Project Showcase Using OFFSET to create a dynamic scrolling chart Details 00:00:00
6.1 Advanced Excel Introduction
6.1 Advanced Excel Introduction Details 00:00:00
6.2 UPPERLOWERPROPER & TRIM
6.2 UPPERLOWERPROPER & TRIM Details 00:00:00
6.3 The CONCATENATE Function (&)
6.3 The CONCATENATE Function (&) Details 00:00:00
6.4 LEFTMIDRIGHT & LEN
6.4 LEFTMIDRIGHT & LEN Details 00:00:00
6.5 TEXTVALUE
6.5 TEXTVALUE Details 00:00:00
6.6 SEARCHFIND
6.6 SEARCHFIND Details 00:00:00
6.7 Categorizing Data with IF(ISNUMBER(SEARCH))
6.7 Categorizing Data with IF(ISNUMBER(SEARCH)) Details 00:00:00
6.8 Combining RIGHT, LEN, and SEARCH
6.8 Combining RIGHT, LEN, and SEARCH Details 00:00:00
6.9 Bonus The SUBSTITUTE Function
6.9 Bonus The SUBSTITUTE Function Details 00:00:00
6.10 Homework Text Functions
6.10 Homework Text Functions Details 00:00:00
7.1 Introduction
7.1 Introduction Details 00:00:00
7.2 DATEVALUE Your New BFF
7.2 DATEVALUE Your New BFF Details 00:00:00
7.3 Date Formatting & Fill Series
7.3 Date Formatting & Fill Series Details 00:00:00
7.4 TODAY()NOW()
7.4 TODAY()NOW() Details 00:00:00
7.5 YEARMONTHDAY & HOURMINUTESECOND
7.5 YEARMONTHDAY & HOURMINUTESECOND Details 00:00:00
7.6 The EOMONTH Function
7.6 The EOMONTH Function Details 00:00:00
7.7 The YEARFRAC Function
7.7 The YEARFRAC Function Details 00:00:00
7.8 WEEKDAY, WORKDAY & NETWORKDAYS
7.8 WEEKDAY, WORKDAY & NETWORKDAYS Details 00:00:00
7.9 The DATEDIF Function
7.9 The DATEDIF Function Details 00:00:00
7.10 Project Showcase Designing a Sample Budget Pacing Tool
7.10 Project Showcase Designing a Sample Budget Pacing Tool Details 00:00:00
7.11 Homework Date & Time Functions
7.11 Homework Date & Time Functions Details 00:00:00
8.1 Introduction
8.1 Introduction Details 00:00:00
8.2 CreatingEditing formatting rules
8.2 CreatingEditing formatting rules Details 00:00:00
8.3 Demo Highlighting every other row with the MOD() function
8.3 Demo Highlighting every other row with the MOD() function Details 00:00:00
8.4 Demo Formatting cells based on the value of another cell
8.4 Demo Formatting cells based on the value of another cell Details 00:00:00
8.5 Demo Formatting rows using statistical functions
8.5 Demo Formatting rows using statistical functions Details 00:00:00
8.6 Demo Formatting rows using text functions
8.6 Demo Formatting rows using text functions Details 00:00:00
8.7 Homework Formula-Based Formatting
8.7 Homework Formula-Based Formatting Details 00:00:00
9.1 Introduction
9.1 Introduction Details 00:00:00
9.2 Rules of Array Functions
9.2 Rules of Array Functions Details 00:00:00
9.3 Pros & Cons of Array Functions
9.3 Pros & Cons of Array Functions Details 00:00:00
9.4 Vertical, Horizontal, and 2-Dimensional Array Constants
9.4 Vertical, Horizontal, and 2-Dimensional Array Constants Details 00:00:00
9.5 Using Array Constants in Formulas
9.5 Using Array Constants in Formulas Details 00:00:00
9.6 The Transpose Function
9.6 The Transpose Function Details 00:00:00
9.7 Linking Data Between Sheets Array vs. Non-Array Comparison
9.7 Linking Data Between Sheets Array vs. Non-Array Comparison Details 00:00:00
9.8 Returning the X Largest Values in a Range
9.8 Returning the X Largest Values in a Range Details 00:00:00
9.9 Counting Characters Across Cells
9.9 Counting Characters Across Cells Details 00:00:00
9.10 Creating a MAX IF Array Formula
9.10 Creating a MAX IF Array Formula Details 00:00:00
9.11 Bonus MAX IF with Multiple Criteria
9.11 Bonus MAX IF with Multiple Criteria Details 00:00:00
9.12 Bonus Using the Double Unary Operator (--)
9.12 Bonus Using the Double Unary Operator (–) Details 00:00:00
9.13 Homework Array Functions
9.13 Homework Array Functions Details 00:00:00
10.1 Introduction
10.1 Introduction Details 00:00:00
10.2 INDIRECT
10.2 INDIRECT Details 00:00:00
10.3 HYPERLINK
10.3 HYPERLINK Details 00:00:00
10.4 WEBSERVICE, FILTERXML
10.4 WEBSERVICE, FILTERXML Details 00:00:00
11.1 Wrapping up
11.1 Wrapping up Details 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 year
15 STUDENTS ENROLLED
Copyright @2019