/Comprehensive Excel Masterclass

Course Curriculum

Section 1 · Project 1

○ Concatenate ○ Date ○ Number ○ Pivot ○ Text

Section 2 · Project 2

○ Filter ○ Large Small ○ Left Right Mid ○ Time ○ Trim ○ VL HL XL

Section 3 · Project 3

○ Cell Reference ○ IF Functions ○ Text to Column ○ Data Validation

Section 4 · Project 4

○ Pivot ○ Iferror ▶ Index Match ○ Paste Special ○ Round ○ Search Find ○ Sorting ○ Substitute Replace

Section 5 · Project 5

○ Name Manager ○ Network Days ○ Sub Total ○ Text ○ Workday ○ And Or

Project 4

Index Match

← Previous Continue →