Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac

Use common functions with Formula AutoComplete :

Lesson 3-2 from: Microsoft Excel 2016 Expert Skills (0 Video Lessons)
Use common functions with Formula AutoComplete
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Before you watch your first video you need to know three things!
1. This is a walk-through and not a stand-alone video lesson
The walk-through is intended to be used only with an e-book or paper book. Read and work through the printed lesson first. Only watch the video walk-through if you have difficulty with it.
2. Video walk-throughs do not have a sound track
Reading out the lesson steps (shown in the captions) wouldn't add any value. If a wordy narrative was added it would bloat the walk-through and make it less useful for its intended purpose.
3. Make sure that you use the interactive transcript and e-book button
Jump straight to the step you need to see using the interactive transcript. window. Just click on the step you need. Play with the other buttons too - you'll never have seen some of the features our player has before.
OK - I’ve got it! Don't show this again.
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2016 Expert Skills
Session: Session 3: Advanced Functions
Lesson: Lesson 3-2 Use common functions with Formula AutoComplete Create an Excel SUM function within an Excel SUM Formula using Formula AutoComplete, thumbnail for video lesson from  Excel 2016 Expert Skills Lesson 3-2
Description:

You'll learn how to create an Excel SUM function within an Excel SUM Formula using Formula Autocomplete in this video lesson. You'll begin by creating a SUM function and then go on to create an AVERAGE function, a COUNT function, a MAX function and a MIN function all using Excel 2016's Formula AutoComplete feature. This feature is very similar to the IntelliSense feature that is included in some other products. The lesson shows how to enable Formula AutoComplete if it is disabled, how to use it to select any function from Excel's function library and how to work with the Syntax Box to determine which values the function requires.