Course Description:

Learning Path Includes: – Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions) – Excel Cell Reference: Absolute, Relative or Mixed? – Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples – Excel Hack: Copy Formula Without Changing Cell References (or Without File References) – How to set Default Workbook Theme in Excel and how this could help you save time – Excel Filter Basics (for quick data analysis) – Advanced Excel Filter (And, Or, Between conditions for criteria range) – Create SMART Drop Down Lists in Excel (with Data Validation) – Excel Custom Data Validation (Use formulas to check for text, numbers & length) – 3 REALLY Useful Chart Tips You May Have Missed – Excel Header & Footer (& Quickly Copy to other Sheets) – Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort – 3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa) – 3 Methods to Unhide All Sheets in Excel (& how to hide) – Excel’s Find and Replace (surprising features) – All about Excel Comments (Notes) in 8 Minutes! Shortcut Keys, Customize Background & More – Calculate Percentages the Right Way in Excel (% Change & Amount after % increase) – Better Excel Presentations: Increase Font Size of Formula Bar – Change CASE of text in Excel (3 ways including NO Formulas) – Why you SHOULD be USING Custom Number Formatting in Excel – Lock Cells & Protect Excel Worksheet – EVEN by Cell Color! – ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature) – The QUICKEST & EASIEST Way to Work with TEXT in Excel – 5 Excel INTERVIEW Questions You NEED to Get RIGHT – Do’s & Don’ts of Excel Spreadsheet Design (with Examples) – Excel Flash Fill For MAJOR Time Saving (7 Examples) – Your Excel Printing Problems, Solved! – Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers) – How Familiar Are You With Excel Cell Modes? (Ready, Enter, Point, Edit) – Properly Use Excel IFS Function Course Length: 3:59:44 hours

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.