The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing, formatting, and using a spreadsheet.
What will you learn in this Microsoft Excel Basic Level Training?
• The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer.
• He or she will understand and be able to accomplish basic operations associated with developing, formatting, and using a spreadsheet.
• Additionally, trainees will be able to accomplish standard mathematical operations using basic formulas and functions.
• The trainee will be able to demonstrate competence in using some of the features of Excel such as filtering, managing data and creating charts.
Course Outline
OFFICE WORKSPACE BASICS
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with Key Tips
• Using the Status Bar
INTRODUCTION TO EXCEL
• What is Excel?
• Getting to Know the Excel Window
• Moving the Cell Selector
• Opening a Workbook
• Navigating a Workbook
• Selecting Cells
• Creating Workbooks
• Saving a Workbook
• Closing a Workbook
ENTERING AND EDITING DATA
• Entering Text, Numbers, and Dates
• Editing Data
• Using AutoComplete and AutoFill
• Copying Data
• Moving and Clearing Data
• Using Undo and Redo
• Finding and Replacing Data
FORMATTING DATA
• Introduction to Formatting
• Applying Number Formats
• Applying Font Formats
• Changing Cell Alignment
• Applying Cell Styles
• Copying Formats
• Clearing Formats
• Finding and Replacing Formats
FORMATTING WORKSHEETS
• Inserting and Deleting Rows and Columns
• Inserting and Deleting Cells
• Adjusting Column and Row Sizes
• Hiding Worksheet Components
• Inserting and Deleting Worksheets
• Copying and Moving Worksheets
• Customizing Sheet Tabs
• Adding a Worksheet Background
KICK START WITH BASIC FORMULAS AND FUNCTIONS
• What are Formulas and Functions?
• Entering Formulas
• Entering Functions
• Using the Insert Function Tools
• Using AutoSum
• Copying and Moving Formulas
For more information about our Digital Marketing Masterclass, contact us at 1700-81-5520 or email us at training@excelacademy.my. To keep updated with our training you can follow us on Facebook, https://www.facebook.com/excelacademyofexecutiveeducation
Check out other courses: https://www.excelacademy.my/hrdcorp-claimablecourse/