MS Excel

Organizations rely on information to make sound business decisions regarding all manner of affairs. This is where the power of Microsoft Excel 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 Microsoft Office 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.

Course Objectives:

Day 1

  • Get started with Microsoft Office Excel 2016.

  • Perform calculations.

  • Modify a worksheet.

  • Format a worksheet.

  • Print workbooks.

  • Manage workbooks.

Day 2

  • Work with Functions

  • Work with Lists

  • Analyze Data

  • Visualize Data with Charts.

  • Create advanced formulas.

  • Analyze Data with PivotTables and PivotCharts.

Day 3

  • Work with multiple worksheets and workbooks.

  • Use Lookup functions and formula auditing

  • Share and protect workbooks.

  • Automate workbook functionality.

  • Create sparklines and map data.

  • Forecast data.

Contact us to customize this class with your own dates, times and location at info@cynwavesolutions.com or call 1-706-828-1891.