Microsoft Excel ( Spreadsheets ) Functions & Formatting Features Training

Microsoft Excel ( Spreadsheets ) Functions & Formatting Features Training

MS Excel In-House & Online Individual, Group Training Programs

Microsoft Excel ( Spreadsheets ) Functions & Formatting Features Training

Trainer

Excel Dashboard

Target Audience: Anyone who wants to have a grasp on what spreadsheets have to offer and how they can apply some of the built-in functions and formatting features of Microsoft Excel.

Excel Dashboard for Reporting

Learning Outcome :

Equipping participants with the necessary knowledge to understand the capabilities of spreadsheets and how best to use them for reporting and simple data analysis.

Pre- Requisite

Basic understanding of what Excel offers and is capable of doing with some understanding of spreadsheets.

Training Benefit

Participants will have a better understanding on the capabilities of using Microsoft Excel in their daily work and how to apply the various built-in functions and features of it to gather useful information from raw data.

Training / Course Outline:

1. INTRODUCTION TO SPREADSHEETS

A brief outline and overview of what Excel is and its general capabilities in the business world.

2. UNDERSTANDING THE RIBBON

Activating and deactivating the Ribbon. Adding and removing Command buttons on the Quick Access Toolbar. Understanding the list of options available to customize default settings.

3. FORMATING WORKSHEETS

Creating and Modifying a Worksheet. Inserting and deleting cells, rows, and columns. Changing cell formatting. Applying numeric formats. Changing data alignment. Hiding and unhiding columns and rows. Moving around a sheet using the double click approach. Shortcut keys to accomplish tasks quickly. Other techniques to enhance the appearance of a spreadsheet.

4. AUTOCOMPLETE, AUTOFIT & AUTOFILL

Simplify your effort in filling various columns or rows with numbers or text using the Fill Handle. Learn to transpose a set of data from rows to columns and vice versa. Fitting a column width automatically

5. WORKING WITH FORMULAS

Basics of the SUM, MAX, MIN, AVERAGE and COUNT formulas. Incorporating above formulas within different sheets and files. Introducing the IF function for “what-if” analysis.

6. CREATING CHARTS

All you need to know about charts in a simplified way and how it can help you analyze data for better business decision making. Understanding Pie Charts; Bar Charts; Column Charts; Line Charts Modifying chart layouts. Converting one type of chart to another.

7. OTHER FEATURES

Inserting Comments. Sorting Data. Applying Headers and Footers. Modifying Page Properties. Changing default options

8. ANALYZING RAW DATA

Basic analysis of raw data using functions and features covered above

Contact us : https://www.malaysia-training.com/contact-us