Select, sort and copy, move and delete data Enter data into cells and use good practice in creating lists.Choose built-in options such as the Help function within the application to enhance productivity.Work with spreadsheets and save them in different file formats.On completion of this Microsoft office Excel course, each learner will be able to: Microsoft Excel 2019 will be used in this training. Through this Microsoft office training, learners will understand and be able to accomplish tasks associated with developing, formatting, modifying, and using a spreadsheet and standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.
Intellezy, Excel, Excel 2019, escel 2019 - advanced, microsoft excel, microsoft excel 2019.Microsoft Excel Course in Singapore trains learners in the basic concept of spreadsheets and demonstrates the ability to use a spreadsheet application. Please email with proof of completion to obtain your certificate. This IAAP-certified counts for 3.75 recertification points for the CAP certification under the Technology and Information Distribution content area. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Excel 2019 - Advanced Course Author: Intellezy