You already know how to get Microsoft Office Excel 2016 to perform simple calculations to make your job easier. However, manually entering formulas will take you only so far. As you progress with Excel, you'll need to know how to ask Excel more complex questions about your data and to get the answers you expect.
There are over 300 functions in Excel. No need to learn them all. This course is right for you if you want - or need - to perform more complex calculations, e.g. calculate with Date and Time or perform calucaltion based if a criteria is met or not. You will learn how to use the most important function in each category.
Because you will understand how functions work, you are able to locate and work with other functions you need.
In Excel, functions are simply built-in, predefined formulas that you can quickly and easily insert into worksheet cells. Learn how to 'talk' to Excel at a higher level to get the most out of your data.
Learn how to use functions will save you time, effort, and possibly a few headaches down the road. (Functions, Basic Function Syntax, The Function Library Group, TheFunction Arguments Dialog Box, Graphical Cell and Range Reference Entry, The AutoSum Feature, Other Commonly Used Functions, The Formula AutoComplete Feature)
By reusing your content, you can eliminate the hassle and reduce the likelihood of entering numerous errors in your workbooks.
Excel provides you with a number of methods to reuse nearly any of your content, including formulas and functions, basically by using a variety of copy and paste techniques. (Formulas and the Cut, Copy, and Paste Commands, Drag-and-Drop Editing, The Paste Options, The Paste Special Options, Relative References, Absolute References, Mixed References, AutoFill and Formulas, Worksheet References, Excel Errors)
Learn how to ease your work by name ranges for use in functions and formulas.
Cell names and range names are exactly what they sound like. They are meaningful names you assign to a given cell or range to make it easier to both understand what calculations are being performed in a formula and to reuse the references for a number of purposes. (Cell and Range Names, Names and the Name Box, Name Manager, The Create from Selection Command)
Although it's certainly helpful to be able to name a range or a cell for easy navigation, the real power of this feature lies in the ability to easily identify references in formulas and to quickly and accurately insert references into multiple formulas. (Cell and Range Names in Formulas, Manually Entering Cell or Range Names, The Use in Formula Command Method, The Formula AutoComplete Method)
Learn how to perform far more complex tasks in Excel beyond adding up rows and columns and multiplying the sum by some other figure. (Function Categories, The Excel Function Reference, Comparison Operator Basics, Function Syntax, The COUNTIF Function, The TODAY Function)
The logical functions in Excel provide a method for testing various conditions to calculate a result of a value, text, or a calculation which enable you to ask questions of your data.
The IF function returns one value if the logical test you enter as an argument is true, and it returns a different value if the logical test is not true.
Learn how to combine logical tests. (AND Function, OR Function, NOT Function)
The key to combining multiple calculations into a function in a single cell is nesting. Nesting is, simply, using a function as an argument within another function.
Learn how to use other powerful IF Functions. (SUMIF, COUNTIF, AVARAGEIF)
Learn how to work with of some of the more commonly used date and time functions.
Learn how to work with more advanced date and time functions - not only important to all, who frequently deal with scheduling and analyzing data for particular periods of time. (The NETWORKDAYS Function, The WEEKDAY Function, The WORKDAY Function, The ISOWeeknum Function)
Excel's text functions let you manipulate text in cells to extract portions of text to other cells or combine them.
This basic text functions let you manipulate text in cells to extract portions of text to other cells or combine them to produce e.g. full names or addresses. (The LEFT Function, The RIGHT Function, The MID Function)
To extract text from cells that contain values of varying characters, Excel also includes the FIND function. Very helpful, e.g. when you want to seperate names like 'Lastname, Firstname' into two separate cells.
This feature splits a single column of text into multiple columns. For example, you can create first and last name columns from one column of full names. Actually its not a Function ... but a helpful feature that need to be mentioned here!
One of the most powerful text functions available in Excel is the CONCATENATE function. This function enables you to concatenate, or join together, text strings from multiple cells into a single cell. This function can save you massive amounts of time when you need to pull together data from multiple cells that already exists in your worksheets. (The CONCATENATE Function, Text Concatenation with the Ampersand, &)
Excel contains three text functions that are very useful for formatting text to display it in the desired format.
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.