Link to sample file: http://simpletek.ca/files/excel-2013-files/ In this tutorial learn to use IF function followed by SumIF, SumIFS. Use Count Function and a variation of it called CountIF; in the same manner understand AverageIF. And lastly we will look at Vlookup function.
- Category
- Tech
Sign in or sign up to post comments.
Be the first to comment
Up Next
Autoplay
-
Microsoft Excel 2013/2016 Pt 5 (Format, Insert/Delete, Concatenate, Text To Column)
by ava 334 Views -
Microsoft Excel 2013/2016 Pt 1 (Enter/Delete/Edit Cells, Save, Open, Formula)
by ava 306 Views -
Microsoft Excel VLOOKUP Tutorial for Beginners - Office Excel 2003, 2007, 2010
by ava 389 Views -
Microsoft Excel 2016 - Learn Excel 2016 Beginners Tutorial Video
by ava 414 Views -
Microsoft Excel 2013/2016 Pt 2 (Formula, Functions, Fill Handle)
by ava 341 Views -
How To Use VLOOKUP In Microsoft Excel 2010
by ava 406 Views -
How to Do a VLOOKUP in Excel - Video Tutorial
by ava 406 Views -
HUGE Microsoft Access Tutorial - 3 HOURS! - Import Excel Into Access 2013/2016
by ava 363 Views -
Gantt Chart Excel Tutorial - How to make a Basic Gantt Chart in Microsoft Excel 2013
by ava 368 Views -
Microsoft Excel 2013/2016 Pt 4 (Page Setup, Header/Footer, Repeat Row)
by ava 276 Views -
Microsoft Excel 2013 - Using Excel's MATCH And INDEX Functions
by ava 302 Views -
Tutorial Microsoft Excel - How To Use Vlookup in Excel
by ava 313 Views -
Excel Gantt Chart Tutorial - How To Make A Gantt Chart In Microsoft Excel 2013 Excel 2010 Excel 2007
by ava 641 Views -
Microsoft Excel 2016 Tutorial For Beginners Part 2 Full Intro Learn How to Use Excel 2016
by ava 395 Views -
How To Use VLOOKUP In Excel
by ava 149 Views -
Tips on Performing VLOOKUP in Microsoft Excel : Microsoft Office Lessons
by admin 514 Views -
The COUNTIF Function In MS Excel
by ava 299 Views -
Microsoft Excel - Tự Học Excel Hiệu Quả Nhất. Bài 1: Giới Thiệu Microsoft Excel.
by ava 572 Views -
Microsoft Excel 2016 Tutorial For Beginners: Excel Crash Course Refresher for Job Interviews & Exams
by ava 430 Views -
Microsoft Excel 2013 Training - Formulas And Functions - Excel Training Tutorial
by ava 437 Views -
Microsoft Excel 2013 Training -- Using The VLOOKUP Function
by ava 342 Views -
Microsoft Excel 2016 Tutorial For Beginners Part 1 Full Intro Learn How To Use Excel 2016
by ava 518 Views
Add to playlist
Sorry, only registred users can create playlists.




