Basic Microsoft Excel Level 1
Microsoft Excel 2010: Level 1 Course Outline
Course Objective: You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.
Target Student: This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.
Prerequisites: To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
We are pleased to announce Evanson Training’s One-day premier Basic Microsoft Excel Level 1 Training in Dubai on 24th June 2017 at 9:00 am to 3:00 pm.
Upon successful completion of this course, students will be able to:
- Create a basic worksheet by using Microsoft Excel 2010.
- Perform calculations in an Excel worksheet.
- Modify an Excel worksheet.
- Modify the appearance of data within a worksheet.
- Manage Excel workbooks.
Lesson 1: Getting Started with Excel
Topic A: Identify the Elements of the Excel Interface
Topic B: Navigate and Select Cells in Worksheets
Topic C: Customize the Excel Interface
Topic D: Create a Basic Worksheet
Lesson 2: Performing Calculations in an Excel Worksheet
Topic A: Create Formulas in a Worksheet
Topic B: Insert Functions in a Worksheet
Topic C: Reuse Formulas
Lesson 3: Modifying an Excel Worksheet
Topic A: Edit Worksheet Data
Topic B: Find and Replace Data
Topic C: Manipulate Worksheet Elements
Lesson 4: Modifying the Appearance of a Worksheet
Topic A: Apply Font Properties
Topic B: Add Borders and Colors to Cells
Topic C: Align Content in a Cell
Topic D: Apply Number Formatting
Lesson 5: Managing an Excel Workbook
Topic A: Manage Worksheets
Topic B: View Worksheets and Workbooks