Access 23 lectures & 2 hours of content 24/7.So if you're ready to ramp up your formula skills and take your Excel analytics game to the next level, this is the course for you. It's time to start working smarter, not harder. In this course, you’ll sample some of Excel’s most powerful formula tools, including basic options like calculation modes, line breaks, and auditing tools, as well as more complex use cases like detecting duplicates, creating dynamic workbook links, randomizing lists, and configuring many-to-many lookups.
#MICROSOFT EXCEL DATA ANALYSIS CERTIFICATE PRO#
This course is part of the Excel Pro tips series, designed to help everyday users develop expert-level skills by mastering the same tools and techniques used by top pros and Excel MVPs.
#MICROSOFT EXCEL DATA ANALYSIS CERTIFICATE MOD#
DEMO: Highlighting Rows with MOD - 3:50.Creating and Managing Formula-Based Rules - 4:39.YEAR/MONTH/DAY & HOUR/MINUTE/SECOND - 3:04.Categorizing Data with IF(ISNUMBER(SEARCH)) - 5:39.HOMEWORK: Lookup & Reference Functions - 0:54.DEMO: Building a Scrolling Chart with OFFSET - 9:51.Selecting List Items with CHOOSE - 13:15.DEMO: Building Dashboards with XLOOKUP - 18:16.SNEAK PEEK: XLOOKUP (Office 365 Only) - 4:29.DEMO: Basic Dashboards with Stats Functions - 8:09.HOMEWORK: Conditional Statements & Logical Operators - 0:44.QUIZ: Conditional Statements & Logical Operators.Conditional Statements & Logical Operators.Formula Auditing: Evaluate Formula & Error Checking - 7:48.Formula Auditing: Trace Precedents & Dependents - 10:14.Important Note for StackSkills Students.