
Please allow 24 hours to process the payment.
Topics
Getting Started with Microsoft Office Excel 2016; Performing Calculations; Modifying a Worksheet; Formatting a Worksheet; Printing Workbooks; Managing Workbooks; Working with Functions; Working with Lists; Analyzing Data; Visualizing Data with Charts; Using PivotTables and PivotCharts; Working with Multiple Worksheets and Workbooks; Using Lookup Functions and Formula Auditing; Sharing and Protecting Workbooks; Automating Workbook Functionality; Creating Sparklines and Mapping Data; Forecasting Data.
Prerequisite
- Microsoft Excel Intermediate course or equivalent.
Learning Objectives
By the end of the course, you should be able to:
- Use SUMIF, SUMIFS, COUNTIF, and COUNTIFS functions
- Use VLookup and Hlookup functions
- Look for an exact match or closer match.
- Create a drop-down list for a set of cells to pick the right set of data.
- For a particular set of cells, set the rules to insert values
- Create and view multiple scenarios
- Summarize scenario results in a separate worksheet
- Filter, Show, and Hide PivotTable Data
- Create, Edit & Format PivotTables
- Analyze Data Dynamically Using PivotTables
- Filter a PivotTable by using multiple methods
- Create a formula that references PivotTable data
- Use PivotTables to analyze data dynamically.
- Creating & Using PivotChart
- Create Dynamic Charts Using PivotCharts
- Create, update, modify, and filter a PivotChart
- Use PivotCharts to create dynamic charts.
- Use Goal Seek to get the desired result.
- Use Solver to find the optimal solution.
- Apply conditional formatting to the table
- Analyze Data Using Descriptive Statistics
- Create charts & customize the appearance of the chart.
- Ability to find trends in data.
- Use sparklines to summarize data
- Enable, Create and Modify Macros
- Examine, step through, and run a macro
- Run Macros When a Button is Clicked
- Add macro buttons to the Quick Access Toolbar
- Create hyperlinks.
- Share workbooks.
- Manage comments.
- Track and manage colleagues’ changes.
- Save workbooks for the Web.
- Save a workbook as a PDF
- Add, display, review, and delete comments
- Password-protect a workbook and a worksheet
Assumptions
- The student has access to Microsoft Excel software for hands-on exercises.
- The student is familiar with writing formula and function in Excel
- The student has at least 1 year of experience using Microsoft Excel or attended Excel Intermediate class.
Who should take this Course?
- The student has at least 1 year of experience using Microsoft Excel or attended Excel Intermediate class.
What do you need?
- At least 1 year of experience using Microsoft Excel or attended Excel Intermediate class.
- Excel 2016 installed on your computer.