The duration of this course is 36 contact hours. Collaborating, Exporting, Printing and Automating Excel 2016 with Comments, Tracking Changes, Consolidating, The Macro Recorder and Excel 2019 UserForms.Analyzing and presenting worksheet data using Charts, Sparklines, Diagrams, PivotTables, PivotCharts, What-if Analysis, and new Excel 2019 features.Selecting or composing appropriate formulas and functions troubleshooting and solving function errors assigning names to cells and ranges formatting values and creating custom number types enforcing data validation, sheet level and workbook level protection.Creating Basic Excel 2019 spreadsheets with calculations and summary functions choosing from a variety of borders, cells styles and workbook themes manipulating sheets, columns, rows and the data contained within.If you wish to become certified, this course prepares you for the Microsoft Excel 2019 certification exam. Microsoft Excel 2019 is designed to provide participants with a fundamental understanding of the Excel environment and the ability to complete tasks using calculations, graphing tools, pivot tables and more.
0 kommentar(er)
