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.
This course provides a brief introduction to some the Excel filter and table features that can assist you in auditing and analyzing large volumes of data.
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.
The course introduces dynamic arrays. Excel dynamic arrays are one of the most significant improvements introduced in modern versions of Microsoft Excel.
This course is designed for intermediate users of Excel who are looking to improve their Excel skills and productivity.
Excel worksheets and workbooks are very commonly considered “number crunching” tools.
