Microsoft Excel ( Spreadsheets ) Functions & Formatting Features Training
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.
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.
Basic understanding of what Excel offers and is capable of doing with some understanding of spreadsheets.
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