MS Excel Basic

MS Excel Basic

About This Course

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, MacOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.

Career Advancement Areas

Microsoft Excel for Beginners is best suited for people who are relatively new to Excel and want to get more out of Microsoft Excel to make the best use of the software in their day-to-day use.

Learn Microsoft Excel tips & techniques that will make your work you work faster, efficiently, and you will be able to do complex tasks in a matter of minutes too.

What You Will Learn

  • Recognize spreadsheet terminology; start Microsoft Excel and identify the components of the Excel interface; create a new workbook; open an existing workbook; navigate worksheets.
  • Enter and edit text, values, and formulas; use AutoFill; review the order of operations; save and update a workbook; and save a workbook in different file formats.
  • Move and copy data and formulas; use the Office Clipboard; use Paste Link; view formulas; work with relative and absolute references; and insert and delete ranges, rows, and columns.
  • Use SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations in a worksheet.
  • Format and merge cells; apply number and color styles; use the Format Painter tool and setup conditional format rules. Create, format, modify, and print charts based on worksheet data; work with various chart elements; apply chart types and chart styles.
  • Insert and modify a picture and SmartArt graphics, and represent data graphically.
  • Check spelling; find and replace text and data; preview and print a worksheet; set page orientation and margins; create and format headers and footers; and print gridlines.

Instructions

Prerequisites
None
Duration
5 Hours
Who Should Register?
  • Anyone interested to learn MS Excel

Overview

Delphi Training Center
Course Type:
Training Course
Study Mode:
Classroom
Location:
Delphi Star Training Centre, Dubai
Fees:
499 AED
Certification:
Course Completion Certificate
Date:
31/03/17


Your information is 100% Secure and will be delivered directly to the school.