This course covers the basics of creating, editing and formatting a chart and more. It also shows you how to create a default chart as well as a custom chart.
The course covers what every accountant should know about computers and information systems and technology. The practical and efficient use of computer technology is highlighted.
Arrays in Microsoft Excel are a very powerful, yet generally unknown tool. Using array formulas allows you to perform tasks that may currently take more than one step, and consolidate them into one step, improving efficiency.
This course provides a comprehensive examination of the Lookup and Reference category in Excel. It covers the LOOKUP and VLOOKUP functions.
This course will help improve productivity and efficiency in charting by learning how to create dynamic or interactive charts that update automatically.
This course covers how to create a custom function (sometimes called an UDF or user-defined function) in Excel.
This course overviews a number of Logical functions in Excel such as IF, IFS, AND, OR and then covers other decision-making functions such as AVERAGEIF, SUMIF, SUMIFs, COUNTIFs and MAXIFs.
The purpose of this course is to improve analysis of key performance measurements through effective presentation of information.
This course overviews some new features and functions that Microsoft offers in Excel 2019 and/or Microsoft 365.
The purpose of this course is to teach students about the various time value of money concepts.