Share this link via
Or copy link
Overview
Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas What you'll learn: Easily create, manage and filter tables to answer key questions of your dataLearn the IF, HLOOKUP, VLOOKUP and other functions for powerful capabilitiesEasily aggregate data in Tables using Sum, Count, Average, Max and MinUse Conditional Formatting to highlight data according to a range of conditionsLearn to use Data Bars, Color Scales and Icons in SpreadsheetsUse the SUMIF, COUNTIF...
Syllabus
- Introduction
- Tables
- Conditional Formatting
- SUMIF, AVERAGEIF and COUNTIF Formulas
- Date Formulas
- Text Formulas
- IF, HLOOKUP and VLOOKUP Formulas
- Additional Formulas
- Conclusion
Instructor
Ian Littlejohn
Reviews
No reviews yet. Be the first to review!
Alternative Courses
Introduction to AI Programming Welcome to the AI programming with...
Free
You must be logged in to submit a review.