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
|
What will you receive?
Participant will receive our Microsoft Excel I handouts and exercises.