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.

Google Online Preview   Download