You are here

Excel (2016/2013/2010) Combo

Excel (2016/2013/2010) Combo

Overview

NetCom Learning
519 8th Ave
New York, NY 10018
Register for Course
Monday, February 18, 2019 - 4:00am
$885

Details

This course is suited for those using Microsoft Excel (2016/2013/2010). This course will be taught using Microsoft Excel. Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Excel (2016/2013/2010) can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. Level 1 Objectives: Get started with Excel 2016 and understand key terminologies Navigate a spreadsheet Modify and format a worksheet Learn to open, save, manage, print, and close workbooks Learn about different formulae and perform calculations Sort and organize data and import data from other applications Level 2 Objectives: Work with Vlookup and Hlookup functions, lists, and named cells and ranges Analyze data, and use charts to visualize data Learn to use PivotTables and PivotCharts for data analysis Learn to create advanced formulas Learn to use validation in a spreadsheet Learn how to export Excel into different formats and how to protect worksheets and workbooks Level 3 Objectives: Learn to work with multiple workbooks and worksheets Learn about advanced text and cell formatting Learn to share and link workbooks and worksheets and how to protect them Learn how to add custom controls and update changes Understand automating workbook functionality Learn to forecast data and create map data and sparklines Learn to locate errors in a spreadsheet

Register for Course

Additional Sessions