#Microsoft office excel 2013 training how to#
#Microsoft office excel 2013 training password#
#Microsoft office excel 2013 training windows#

This module explains how to use some useful tricks and tools in Excel.

Add macros to the Quick Access Toolbar.

Adding a Macro to the Quick Access Toolbar.

Adding Macros to the Quick Access Toolbar.

You can then run the macro, or let Excel perform the steps for you, saving you both time and effort. Instead of performing each step of the operation, you can create a macro that stores these steps.

#Microsoft office excel 2013 training password#

Password protect ranges in a worksheet.Īs you work with Excel, you may find that you repeat certain operations frequently.

Password Protecting Ranges in a Worksheet.

This module explains how to use features that are useful when sharing and working with others.

Use Goal Seek to figure out the value to input to obtain a specific result.

Consolidate data from a number of different ranges into one new range.

Use Data Validation to restrict the type of data that can be entered into a cell.

This lesson covers the most commonly used Data Tools. Some of them are intended to save you time by extracting or joining data and others perform complex calculations.

Check for errors frequently found in formulas.ĭata Tools in Microsoft Excel are simply tools which make it easy to manipulate data.

Trace dependents to determine which cells are impacted by a specific cell.

Trace precedents to determine which cells impact a specific cell.

This module explains how to audit worksheets. This module explains how to work with pivot tables.Īfter completing this module, students will be able to:

The Top 20 Highest-Paying IT Certifications in 2022.

What are Four Types of Cloud Computing Services.

35 Important In-Demand IT Skills for 2022.

Partner With Us Add product value and help your clients keep their skills up to date.

Room Rentals Renting a classroom from ExitCertified is easy and convenient.

Government Government training solutions at ExitCertified.

Corporate Training Achieve your strategic goals through organizational training.

Group Training Work with us on a custom training plan for your next group training.

Individual Training Build your technical skills and learn from an accredited instructor.

#Microsoft office excel 2013 training windows#

You are comfortable in the Windows environment and are able to use Windows to manage information on the computer.You have previously used a personal computer and know how to navigate with the mouse and keyboard.Also useful for learners who are transitioning from earlier versions of MS Excel ®. T his course is designed for beginner Excel ® users and students who want to develop their skills in creating, editing, formatting, and printing basic Microsoft® Office Excel® 2013 worksheets. Lesson 1: Get started with MS Excel ® 2013.Use basic excel functions to create and develop Excel worksheets and workbooks to help you work with and analyze the data. MS Excel ® 2013 Part 1covers key concepts of the Microsoft ® Office Specialist (MOS) exam objectives to help you prepare for the Excel ® 2013, and Excel ® 2013 Expert Exams. This program helps you manage your data for more efficient planning and decision making. Microsoft Excel is designed for robust data processing. Typically the amount of data that is available requires programs that can quickly and efficiently do the work.

Companies depend on data accuracy to make major operations decisions.