Microsoft Excel 2016/19

by DPA Communications Claim Listing

In this course, you will learn the fundamentals of working with spreadsheets. You will learn how to produce a professional looking worksheet by entering numbers and creating time-saving Excel formulas and use the predefined Microsoft Excel 2016/19 functions.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

DPA Communications Logo

img Duration

1 Day

Course Details

In this course, you will learn the fundamentals of working with spreadsheets. You will learn how to produce a professional-looking worksheet by entering numbers, creating time-saving Excel formulas, and using the predefined Microsoft Excel 2016/19 functions.

You will also learn how to quickly and easily change the layout of your worksheet and enhance the appearance of your worksheet using the format commands. You will also learn how to work with multiple sheets within a file and how to set up and print your worksheet.

 

Create and Edit a Worksheet

  • Get acquainted with the Backstage View, Ribbon, and Quick Access Toolbar in Office 2016.

  • Explore the Excel screen.

  • Efficiently move through the worksheet using many shortcut keys.

  • Proficiently select cells and ranges.

 

Create Formulas and Functions

  • Produce a professional-looking worksheet by entering numbers and creating time-saving Excel formulas.

  • Effectively use the following Excel functions: SUM, AVERAGE, MIN, MAX, and COUNT.

 

Manage your Worksheet

  • Quickly insert, delete, or hide cells, rows, and columns.

  • Discover many unique techniques to cut, copy, and paste.

  • Use the latest Flash Fill features, which will automate many repetitive tasks.

 

Format your Worksheet

  • Enhance the appearance of your worksheet using the many formatting commands.

 

Manage your Workbook

  • Name, group, move, copy, and colour your worksheet tabs.

 

Print your Worksheet

  • Setup and print your worksheet.

  • Get Help Using the "Tell me what you want to do" Box

  • Use the new feature to learn how to do anything in Excel.

 

Application Overview: Microsoft Excel 2016/19

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, calculate data, create rich data visualizations,s, and create create professional-looking charts. You can compile your company's data into a Microsoft Office Excel workbook that can contain many worksheets.

Microsoft Excel can be used to manage numbers and calculations. You can create formulas in Excel that automatically update when you change your data.

  • Toronto Branch

    PO Box 1363, Toronto

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy