0000420 - WORKSHOP

Work with spreadsheets and save them in different formats, either locally or in the cloud. Use Help resources, keyboard shortcuts, and the “Go To” tool to enhance productivity. Enter data into cells and apply appropriate methods to create lists. Select, sort, copy, move, and delete data. Modify rows and columns in a worksheet. Appropriately copy, move, delete, and rename worksheets. Create mathematical and logical formulas using the program’s standard functions. Use proper methods for creating formulas and be able to recognize error codes in formulas. Format numbers and text content in a spreadsheet and use table styles or available auto-formatting options. Choose appropriate charts, create and format them to convey information meaningfully. Modify page setup settings in a spreadsheet and check and correct content errors before final printing.

Apply advanced formatting options such as conditional formatting and custom number formatting, as well as manage worksheets. Use functions related to logical, statistical, financial, and mathematical operations. Create charts and apply advanced formatting to them. Work with tables and lists to analyze, filter, and sort data. Create and use scenarios. Validate and check spreadsheet data. Improve productivity by working with named cell ranges and macros. Use linking, embedding, and importing functions to integrate data. Compare and merge spreadsheets. Apply security features to spreadsheets.