Overview

Although the basic functions of Excel will be covered, areas of focus include graphs and charts, the use of advanced financial functions and analytical tools, reporting templates, linking of worksheets and workbooks, importing and manipulating data, macros (automation of tasks), auditing tools, and other features especially useful to the financial or accounting professional.This program is highly recommended for those who want to understand the basic concepts of spreadsheets and want to demonstrate the ability to expertly use Microsoft Excel 2016 for keying in, manipulating and reporting data easily.

What you'll learn

• Create a plan for effective workbook and worksheet design
• Plan, design, create and manage Excel worksheets
• Identify and utilize the appropriate formatting for data in Excel
• Identify appropriate mathematical processes necessary to achieve a result in Excel
• Create mathematical formulas in Excel Devise formulas utilizing relative, absolute and mixed cell references in formulas in Excel
• Specific mathematical and statistical functions in Excel and their use in cell formulas
• Describe how various charts can be used to represent quantitative data in in Excel
• Determine appropriate chart style to represent data; use date to create and revise chart in Excel
• Manage large volumes of data through the use of Tables in Excel
• The fundamentals of table design and create a table in Excel
• Determine appropriate use pivot tables to group and ungroup data in Excel
• Create a pivot table in Excel
• Explain the appropriate use of one-variable and two-variable tables in Excel
• Explain the appropriate use of conditional math and statistical functions in Excel
• Analyze and manipulate data in Excel through the use of mathematical and statistical functions.
• Link excels workbooks to manage and combine data sets.
• Explain the purpose and procedure for Web Query for Excel.
• Import data into Excel from external web sources Identify some of the various templates available for Excel and explain their appropriate use.