Microsoft Advanced Excel
Microsoft Advanced Excel
With our Microsoft Advanced Excel Course you will master the most widely used spreadsheet. We have the best trainers to trained you and you will learn Excel workbook, tables, cells, interactive components, creating dashboard, filtering, charting, sorting, data processing, Pivot Table with real data sets.
What will you learn
-
Think like Excel
To be proficient in Excel, you have to think like Excel does. We’ll teach you that so you can write powerful formulas without a hiccup.
-
Complete mastery of Excel
In this advanced course, you will get more than a handful of unique tips as well tools to help you master Excel like a champ.
-
Practical use of Excel in work
Our advanced Excel training will help you streamline and automate your work flow with the humble Excel sheet.
Become an Excel wizard with our program and easily streamline your business. Our course will help you acquire the following skills-
- Basic formula syntax
- Common errors and IFERROR
- Function, CTRL & ALT shortcuts
- Fixed vs. volatile functions
- Anatomy of the IF statement
- Fixing errors with IFERROR
- Sum product function
- VLOOKUP
- Index and Match functions
- CONCATENATE Function (&)
Lessons
- 98 Lectures
- 07:52:10
- Introduction02:18
- Formula Library & Auditing Tools05:48
- Evaluate Formula02:05
- Basic Formula Syntax05:05
- Fixed, Relative, & Mixed05:09
- Common Errors & the IFERROR08:38
- Function, CTRL & ALT Shortcuts07:48
- BONUS: Shortcuts for Mac Users03:27
- Custom Data Validation Rules04:08
- Fixed vs. Volatile Functions04:05
- HOMEWORK: Formulas 10101:00
- Introduction02:05
- Anatomy of the IF Statement05:18
- Nested IF Statements05:26
- AND/OR Operators09:32
- NOT vs. "<>"04:05
- Fixing Errors with IFERROR05:08
- Common IS Statements06:46
- HOMEWORK: Logical Operators01:00
- Introduction02:18
- Working Named Arrays04:25
- ROW/ROWS & COLUMN/COLUMNS04:34
- VLOOKUP/HLOOKUP06:10
- Joining Data with VLOOKUP07:08
- Fixing Errors IFERROR,VLOOKUP05:02
- VLOOKUP Reference Array02:51
- The INDEX Function02:18
- The MATCH Function03:46
- INDEX & MATCH together07:19
- Combining MATCH with VLOOKUP05:15
- UPDATE:VLOOKUP Correction06:39
- The OFFSET Function03:41
- Combining OFFSET with COUNTA 03:22
- OFFSET to dynamic scrolling10:28
- Lookup/Reference Functions01:06
- Introduction02:16
- UPPER/LOWER/PROPER & TRIM04:08
- CONCATENATE Function (&)04:48
- LEFT/MID/RIGHT & LEN04:05
- TEXT/VALUE05:38
- SEARCH/FIND06:44
- Data with IF(ISNUMBER(SEARCH)06:29
- Combining RIGHT,LEN,SEARCH06:05
- The SUBSTITUTE Function03:54
- HOMEWORK:Text Functions01:02
- Introduction02:36
- DATEVALUE: Your New BFF06:18
- TODAY()/NOW()03:29
- YEAR/M./D./H./M./SECOND04:02
- The EOMONTH Function07:05
- The YEARFRAC Function03:10
- WEE/WOR.DAY.NETWORKDAYS08:54
- The DATEDIF Function05:24
- Designing Sample Budget Pacing12:08
- DATEVALUE:Your New BFF06:18
- HOMEWORK: Date,Time Functions01:00
- Introduction01:46
- Rules of Array Functions04:05
- Pros & Cons Array Functions03:08
- 2-Dimensional Array Constants07:19
- Array Constants in Formulas05:52
- Named Array Constants05:29
- The Transpose Function05:05
- Array vs.Non-Array Comparison03:21
- Returning the "X" Largest Values 04:05
- Counting Characters Across02:34
- "MAX IF" Array Formula04:30
- "MAX IF" with Multiple Criteria07:40
- Double Unary Operator ("--")04:57
- HOMEWORK: Array Functions01:54
- Introduction02:25
- The INDIRECT Function11:18
- HYPERLINK:Awesome as it Sounds07:17
- Time Data with WEBSERVICE08:49
Reviews
My job is entirely based on the Excel sheet. However, I’m not very good at Excel, which led me to taking the Prolytics course. Now I can proudly say that I too am a pro at Excel!
Every single Excel sheet formula was taught in such a simplistic manner by the trainers at Prolytics that I had no problem in remembering them! This is how all Excel courses should be!
Excel formatting, formulae and other functions were brilliantly taught by the experts at Prolytics. The course even offered extra bonus tips, which really helped me at excelling in my job!