Conducted by certified instructors at NetCom Learning, the Microsoft Office Excel training classes explain elementary details like how to open, save, and close files, how to format a spreadsheet, how to build basic charts, and how to enter formulae into a cell. Through comprehensive Excel online training and Instructor-Led Training (ILT), participants will learn to use the most important features of Excel with full proficiency.
Learn Office Excel to analyze, organize, calculate, revise, update, and present your data in the desired format easily and clearly. The Microsoft Office Excel Level 1 (2019/2016/2013) training familiarizes students with the different features for creating spreadsheets, providing the fundamentals upon which they can build their knowledge and skills to become experts in data manipulation.
Intended Audience For This Excel Level 1 (2019/2016/2013) Course:
- This course is intended for students who wish to gain the understanding of Microsoft Office Excel 2019, 2016 or 2013.
- Students and professionals who want to learn basic Excel skills to create and work with electronic spreadsheets
Course Prerequisites For Excel Level 1 (2019/2016/2013):
Excel Level 1 (2019/2016/2013) Course Objectives:
- Get started with Microsoft Office Excel 2019
- Perform calculations
- Modify a worksheet
- Format a worksheet
- Print workbooks
- Manage workbooks
Excel Level 1 (2019/2016/2013) Course Outline:
- Getting Started with Microsoft Office Excel 2019
- Navigate the Excel User Interface
- Use Excel Commands
- Create and Save a Basic Workbook
- Enter Cell Data
- Use Excel Help
- Performing Calculations
- Create Worksheet Formulas
- Insert Functions
- Reuse Formulas and Functions
- Modifying a Worksheet
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
- Formatting a Worksheet
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply Styles and Themes
- Apply Basic Conditional Formatting
- Create and Use Templates
- Printing Workbooks
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
- Managing Workbooks
- Manage Worksheets
- Manage Workbook and Worksheet Views
- Manage Workbook Properties