Go beyond the basics and learn how to write a formula, work with a built-in function, create a chart and organize data in a list.
Upon successful completion of this course participants will be able to: 1. How to open and interact with Excel and how to save and close workbooks 2. How to enter various kinds of data, how to enter formulas and functions, how to move and copy data, 3. How to format text and numbers, how to align text, and how to apply borders and styles to cells and ranges 4. Know about various data-entry shortcuts; how to use paste options; and how to insert, delete, and hide data in your worksheets 5. How to create charts, change their type, and insert and control the elements they contain. 6. How to split and manage worksheet windows, set print options, print and preview workbooks, create headers and footers, and share workbooks with other users 7. About workbook properties, how to check workbooks for accessibility and compatibility issues, and how to use templates
Spreadsheets for Beginners or previous experience with Excel or other spreadsheet programs. Follow-up Course: Microsoft Excel Intermediate.