Excel 2016 (PC)

This training course introduces you to the functions and tools of Microsoft Excel 2016, enabling you to create and manage robust worksheets, analyze data, and securely share your work. Beginning with the basics, you’ll familiarize yourself with the Excel interface and learn how to enter data into cells, and devise simple to intermediate-level formulas to perform calculations. You’ll explore ways of effectively managing your data by tracing the precedents and dependents, and learn how to sort and validate data. The course also shows you how to create tables and charts, as well as how to protect your documents from errors or unwanted revisions. You’ll learn how to import data from other sources, including text and XML files, and how to print your worksheets or export them into different formats. This 1-hour, 30-minute is part of our Microsoft Excel 2016 training series designed to give you the tools and knowledge to begin working effectively in Excel.

Learning objectives:

• Enter data into an Excel worksheet either manually or using the auto-fill function
• Create formulas to perform calculations on your data
• Manage large amounts of data quickly and easily through sorting and data validation
• Devise and format tables and charts to display your data
• Collaborate with others while protecting sensitive or important data from unwanted edits
• Import and export your Excel spreadsheets into other formats