Microsoft Excel I

Why and for whom?

Excel is a very powerful spreadsheet that can perform large numbers of calculation. It gives you the tools you need to manage your business data, turn your data into information and analyze, communicate, and share your results.

This course will give you the fundamental skills for building workbook, creating worksheet, putting formula, drawing chart in Excel. After this course, you can easily create and modify spreadsheets and will become familiar with Excel to manage your business data, such as budgeting, forecasting, business analysis, cash flow statement...

What will you learn?

During the training, we provide step-by-step instructions on :

Explore the New Excel Interface
~ Working with Ribbon
~ Working with Quick Access Toolbar

Get Started with Excel
~ Understand Workbook & Worksheet
~ Understand Rows, Columns & Cells
~ Using Keyboard Shortcuts
~ How to Get Help

Working with Workbook & Worksheet
~ Create, Save, Copy, Delete a Workbook
~ Switch between workbooks & Worksheets
~ Insert, Copy, Rename & Delete a Worksheet
~ Zoom the display of a Worksheet
~ View different part of a Worksheet at the same time
~ View Multiple Worksheets in a Workbook at the Same Time

Entering Data in a Worksheet
~ Quick Data Entry with features such as AutoFill, AutoComplete & AutoCorrect
~ Check Spelling
~ Enter the Same Data on Multiple Worksheet
~ Enter the Same Data into Several Cells at Once

Editing Worksheet
~ Edit Cell Contents
~ Replace All Data in a Cell
~ Copy One Selection to Several Locations
~ Copy only Values, Comments, or Cell Formats
~ Rearrange Data from Columns to Rows or Vice Versa

Working with Formulas
~ Working with Auto Calculating
~ Enter a Simple Formula
~ Formula with Cell References
~ Formula with Names
~ AutoSum Function
~ Sum Data from different worksheets

Formatting Cells
~ Ways of Formatting Cells: Ribbon, Mini Toolbar or Format Cell Dialog box
~ Text Formatting: Wrap Text, Rotate Data in a cell
~ Number Formatting: Currency, decimal points
~ Split or merge cells
~ Border & Fill Colors
~ Copy Format
~ Clear Format without delete the contents

Creating Charts
~ Create Charts
~ Switch between an Embedded Chart and a Chart Sheet
~ Change Chart Types
~ Change the Layout or Style of a Chart
~ Change the Type of a Chart
~ Format a Chart: Add Chart Title, Data table, ...

Printing Worksheets
~ Preview a Page before Printing
~ Print Several Worksheet At Once
~ Print Specific Area(s) of a Worksheet
~ Repeat Labels on every Page
~ Add Header/Footer
~ Work with Page Break

Workshop Projects

During the course, you will be exploring the Excel and doing hands on exercise. This will help on understand how to make full use of Excel's features.

New Interface of Excel	Cusomize Quick Access Toolbar
Access Keys & Keyboard Shortcuts To quickly running a command	View Multiple Worksheets View different worksheets of a worksbook at the same time
View different parts of a worksheets within a same window	Date Format Changing Date Format to D/M/YY
Formatting Worksheets Changing Date Format to D/M/YY	Entering Data Quickly entering data using Fill Handle
Editing Data Rearranging data from columns to rows or vice versa	Auto Calculation
Switching worksheets	Color Sheet Tabs