Overview
Microsoft Excel 2013 skills are important skills to have in any profession or workplace. More often, no matter the job, the ability to work with Excel spreadsheets is expected in the workplace. Developing skills and experience with Excel allows you to work independently and solve problems. MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 Suite. This program teaches you the skills you need to work in Excel 2013. It also prepares you to take the Microsoft Office Specialist (MOS) Certification Exam 77-420. The material is presented in a step-by-step manner, and you will learn practical application through readings, hands-on exercises, and video presentations. The program also includes quizzes and exams, so you can regularly assess your skills. Through this Excel training, you will learn essential skills to create and edit basic worksheets and workbooks. You will learn advanced formulas, lists, and illustrations. You will then advance to adding charts, complex formatting, styles, and pivot tables. In the advance stages of the program, you will audit and analyze worksheet data to identify trends and progress. You will also strategically use data tools, collaborate with others, and create and manage macros.
Upon program completion, you will be able to perform the following tasks in Excel:
- Create and modify basic worksheets and perform calculations
- Modify the appearance of data within a worksheet
- Use the print features, formulas, and functions
- Create and modify charts
- Convert, sort, filter, and manage lists
- Insert and modify illustrations and tables
You will additionally be able to perform the following advanced Excel functions:
- Use conditional formatting, styles, and pivot tables
- Trace precedents and dependents
- Convert text and validate/ consolidate data
- Collaborate with others by protecting worksheets and workbooks
- Create, use, edit, and manage macros
- Import and export data
Overview
Microsoft Excel 2013 skills are important skills to have in any profession or workplace. More often, no matter the job, the ability to work with Excel spreadsheets is expected in the workplace. Developing skills and experience with Excel allows you to work independently and solve problems. MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 Suite. This program teaches you the skills you need to work in Excel 2013. It also prepares you to take the Microsoft Office Specialist (MOS) Certification Exam 77-420. The material is presented in a step-by-step manner, and you will learn practical application through readings, hands-on exercises, and video presentations. The program also includes quizzes and exams, so you can regularly assess your skills. Through this Excel training, you will learn essential skills to create and edit basic worksheets and workbooks. You will learn advanced formulas, lists, and illustrations. You will then advance to adding charts, complex formatting, styles, and pivot tables. In the advance stages of the program, you will audit and analyze worksheet data to identify trends and progress. You will also strategically use data tools, collaborate with others, and create and manage macros.
Upon program completion, you will be able to perform the following tasks in Excel:
- Create and modify basic worksheets and perform calculations
- Modify the appearance of data within a worksheet
- Use the print features, formulas, and functions
- Create and modify charts
- Convert, sort, filter, and manage lists
- Insert and modify illustrations and tables
You will additionally be able to perform the following advanced Excel functions:
- Use conditional formatting, styles, and pivot tables
- Trace precedents and dependents
- Convert text and validate/ consolidate data
- Collaborate with others by protecting worksheets and workbooks
- Create, use, edit, and manage macros
- Import and export data
