When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Productivity
SkillShare logo

Excel PRO TIPS Part 3: Formulas

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Excel PRO TIPS Part 3: Formulas

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon2 hours 1 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Excel PRO TIPS Part 3: Formulas

Formula Tips Intro

Manual vs. Automatic Calculation

Formula Line Breaks

Converting Units of Measurement

Real-Time Tools with TODAY & NOW

Formula Auditing Tools

Pivot-Style Reports with Formulas

Counting Words in a Cell

Dependent Drop-Downs with INDIRECT

Hyperlinking Between Worksheets

"Fuzzy Match" Lookups

Random Selection with OFFSET & RANDBETWEEN

Combining INDEX & MATCH

Matching Items Between Lists

Counting Duplicates with SUMPRODUCT

Many-to-Many Lookups

What You Will Learn?

  • Welcome to Excel Pro Tips for Power Users!.
  • Please note that this is PART 3 of a 6-PART series, and that this is a limited version of the full course. To access additional course materials (including quizzes, 1-on-1 support, and Excel project files), please visit courses.excelmaven.com..
  • __________.
  • FULL COURSE DESCRIPTION:.
  • This course is NOT an introduction to Excel..
  • It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical "hacks". It's about featuring some of the most powerful and effective tools and techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies..
  • Unlike most courses, this one is non-linear, meaning that you can bounce around and explore individual lectures freely. Each video is designed to be an independent and self-contained demo, designed to help you learn these tools and techniques in quick, bite-sized lessons..
  • __________.
  • The tips and techniques covered in the full course fall into six parts:.
  • PART 1: Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.).
  • PART 2: Formatting Tips (freeze panes, row/column grouping, custom number formats, etc.).
  • PART 3: Formula Tips (auditing tools, fuzzy lookups, uniques/duplicates, randomization, etc.).
  • PART 4: Visualization Tips (sparklines, filled maps, custom templates, form controls, etc.).
  • PART 5: PivotTable Tips (slicers & timelines, custom layouts, value calculations, etc.).
  • PART 6: Analytics Tips (outlier detection, simulation, forecasting, CUBE functions, etc.).
  • __________.
  • While the level of difficulty varies considerably, the demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying concepts (like PivotTables or advanced formulas, for example)..
  • Students who have completed the full Excel Maven stack will be well-positioned to maximize the value from this course:.
  • Advanced Excel Formulas & Functions.
  • Data Visualization with Excel Charts & Graphs.
  • Data Analysis with Excel PivotTables.
  • Intro to Power Query, Power Pivot & DAX.
  • __________.
  • It's time to start working smarter, not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you..
  • See you in there!.
  • -Chris (Founder, Excel Maven & Maven Analytics).
  • __________.
  • NOTE: Most demos are compatible with Excel 2007-2016 or Office 365 (some may be unavailable for Mac or Excel Online).