Excel 2013 - Advanced Formulas and Functions
About this courseCourse title: Excel 2013 – Course description: (A short description of the service with a slightly advertising/pitch feel)What you should already know: You should have an intermediate level of skill in Excel 2013. You should be able to create spreadsheets, rows, columns, formulas, and functions.What you will learn:By the end of class, you will…What you will need:For this course, you will need a KU Online ID. Course objectives:By the end of this course, participants will be able to:Understand the basic structure of formulas and functionsUse logical functions such as IF to perform calculations on line itemsUse conditional functions such as SUMIF to summarize specified data in a worksheetUse text functions to combine, extract, transform, and trim text in cellsUse date and time functions, such as TODAY, YEAR, and DAYS, to calculate spans of timeUse LOOKUP, VLOOKUP, and HLOOKUP to automatically reference values contained on other worksheets or to combine worksheetsTime: 2 hoursCourse Outline: Part 1 Logical FunctionsIF FunctionUse functions to apply conditional formattingNested IF FunctionsOR, AND, NOT FunctionsOR, AND, NOT Nested FunctionsIFERRORConditional FunctionsSUMIF, AVERAGEIF, COUNTIFSUMIFS, AVERAGEIFS, COUNTIFSText FunctionsLEFT, RIGHT, MIDFINDTRIMCONCATENATEUPPER, LOWERDate and Time FunctionsNOWTODAYYEARDAYS360NETWORKDAYSWEEKDAYPart 2 LOOKUP FunctionsLOOKUPVLOOKUPHLOOKUP ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- excel advanced formulas pdf
- list of excel formulas and functions
- advanced excel 2013 tutorial pdf
- formulas and functions in ms excel
- complex excel formulas and functions
- advanced excel formulas and functions pdf
- free excel formulas and functions
- advanced formulas in excel 2016
- all excel formulas and functions
- advanced algebra and functions test
- list excel formulas and functions
- excel inventory formulas and functions