MS Excel
MS Excel
- 0 lessons
fromAED 60
Delivered as a scheduled course — online, live or in your workplace. Tell us your scheme and team size and we’ll confirm dates and pricing.
- ✓Scheduled delivery — online, live or on site
About this course
Introduction:
MS-EXCEL is a part of Microsoft Office suite software. It is an electronic spreadsheet with numerous rows and columns, used for organizing data, graphically represent data(s), and performing different calculations.
Objectives:
Create, open, and view a workbook.
Examine Spreadsheet concept and explore MS Excel environment.
Save and print workbooks.
Enter and edit data.
Modify a worksheet and workbook.
Work with cell references.
Learn to use functions and formulas.
Create and edit charts and graphics.
Course Outlines:
Introduction
MS Excel Basic commands
Formatting
Formulas
Parts of Formulas
Functions
Single Arguments
Keyboard Shortcuts
Error Types
Circular Reference
Watch Window
Styles (Built-in)
Worksheet Protection
Who should attend?
Students
IT Professionals
Learning Outcomes:
This course will make you program in MS Excel. Students will be able to understand how to insert, delete, and adjust cells, columns and rows. They will learn how to apply conditional formatting and work with ranges and charts. Discover how to sort, filter, and query data with database functions.