Basic Excel and Powerpoint

Basic Microsoft Excel Level 1

 

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 Two-days premier Basic Excel and Powerpoint Training in Dubai on 18th & 19th August 2017 at 9:00 am to 4: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

Lesson 1: Getting Started with PowerPoint

  • Navigate the PowerPoint Environment
  • Create and Save a PowerPoint Presentation
  • Use Help

Lesson 2: Developing a PowerPoint Presentation

  • Select a Presentation Type
  • View and Navigate a Presentation
  • Edit Text
  • Build a Presentation

Lesson 3: Performing Advanced Text Editing

  • Format Characters
  • Format Paragraphs
  • Format Text Boxes

Lesson 4: Adding Graphical Elements to Your Presentation

  • Insert Clip Art and Images
  • Insert Shapes

Lesson 5: Modifying Objects in Your Presentation

  • Edit Objects
  • Format Objects
  • Group Objects
  • Arrange Objects
  • Animate Objects

Lesson 6: Adding Tables to Your Presentation

  • Create a Table
  • Format a Table
  • Insert a Table from Other Microsoft Office Applications

Lesson 7: Adding Charts to Your Presentation

  • Create a Chart
  • Format a Chart
  • Insert a Chart from Microsoft Excel

Lesson 8: Preparing to Deliver Your Presentation

  • Review Your Presentation
  • Apply Transitions
  • Print Your Presentation
  • Deliver Your Presentation
×
Enter Your Number For Call Back
📞 Request A Call Back