18. November 2019 - 9:30 till 16:30
Microsoft Excel Functions Course | Sydney Campus, Room to be advised | Monday, 18. November 2019
Learn to work smarter with your data with our Microsoft Excel courses in Excel is one of the world’s most popular spreadsheet software applications. Learn Microsoft Excel with our Microsoft Excel courses in Sydney - short courses open to Microsoft Excel functions course is an advanced Excel course where you will learn to use a variety of Microsoft Excel functions, including logical functions, math functions, date and time and financial functions. This Microsoft Excel course is designed for those already familiar with how functions are used in Microsoft Excel or those who have completed Microsoft Excel Course: Level 2 (Intermediate) and are seeking a more in-depth understanding of key Excel OutcomesAt the completion of this Microsoft Excel functions course you should be able to:Use logical functions to test whether a statement is true or false.Use a range of lookup and reference functions.Use maths functions to solve complex problems.Use a variety of statistical functions.Use a variety of financial functions to perform calculations.Use the date and time functions to perform calculations.Use a range of text functions.Use a range of information functions to test worksheet ContentMicrosoft Excel Logical FunctionsUnderstanding Logical IF With IF With IF TRUE and Excel Lookup FunctionsUnderstanding Data Lookup VLOOKUP for Exact Reference ROW and COLUMN and Excel Maths FunctionsUnderstanding Maths ROUNDDOWN and ODD and Excel Statistical FunctionsUnderstanding Statistical Bar COUNT and LARGE and SMALL Using Excel Financial FunctionsUnderstanding Financial Excel Date and Time FunctionsUnderstanding Date and Time HOUR and Future Calendar Excel Text FunctionsUnderstanding Text the PROPER the UPPER and LOWER the CONCATENATE the LEFT and RIGHT the MID the LEN the SUBSTITUTE the T the TEXT the VALUE Excel Information FunctionsUnderstanding Information the CELL the ISBLANK the ISERR the ISODD and ISEVEN the ISNUMBER and ISTEXT the TYPE AudienceProviding comprehensive and thorough coverage of a variety of Microsoft Excel functions, including logical functions, math functions, date and time and financial functions, this Microsoft Excel course is ideal for anyone who has completed Microsoft Excel Course: Level 2 (Intermediate) or for existing users familiar with Microsoft Excel functions and seeking to further expand their StyleThis Microsoft Excel functions course is presented as a practical, instructor-led computer-based course in a Microsoft Windows environment. You’ll have dedicated access to a computer exclusively for your use so you can follow instructor training and work through PrerequisitesThis Microsoft Excel functions course assumes some knowledge of Microsoft Excel, including an understanding of how functions are used. An understanding of conditional logic, mathematics, statistics and financial concepts is assumed. You should be familiar with the basic functions of a computer operating system. This includes navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening and saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending the Basic Computer Skills Course before attempting this DatesAdditional instances of this course may be available and published on our website. See Microsoft Excel Functions Course for more information, or to join the waiting list and be advised when we schedule more.