Professional Web Development Multi-Language with(ASP.Net) and WordPress. All our prebuild websites includes the following services:
Tutorials for Microsoft Excel 2010 /2013

Tutorials for Microsoft Excel 2010/ 2013

 

Microsoft Excel is the industry leading Spreadsheet software. It is part of the MS Office suite of software. Microsoft Excel is a spreadsheet tool capable of performing calculations, analysing data and integrating information from different programs. Microsoft Excel is comprised of organisational units called workbooks. A standard workbook contains worksheets. Worksheets perform calculations, store and organise data, present graphics and controls. We can cover MS Excel from Introduction to advanced level.

 

Target Audience : Aimed at users who are new to Microsoft Excel and want to set up their own business or learn to manage an exiting business.

 

Course Objectives: On completion of the course, attendees will be professional Excel users with an in-depth knowledge of Excel reporting and automation techniques. Attendees will be capable of developing and supporting spreadsheets for spreadsheet intensive industries, which include business, banking and financial services, accounting, software and other online industries.

Course Duration6 classes, two hours per class, or ( (Any time which suit you) 
Course Fee
280 per course.

Course Content :

MS Excel Basics Level

·          Excel - Home

·          Excel - Getting Started

·          Excel - Explore Window

·          Excel - Backstage

·          Excel - Entering Values

·          Excel - Move Around

·          Excel - Save Workbook

·          Excel - Create Worksheet

·          Excel - Copy Worksheet

·          Excel - Hiding Worksheet

·          Excel - Delete Worksheet

·          Excel - Close Workbook

·          Excel - Open Workbook

·          Excel - Context Help

Editing Worksheet

·          Excel - Insert Data

·          Excel - Select Data

·          Excel - Delete Data

·          Excel - Move Data

·          Excel - Rows & Columns

·          Excel - Copy & Paste

·          Excel - Find & Replace

·          Excel - Spell Check

·          Excel - Zoom In-Out

·          Excel - Special Symbols

·          Excel - Insert Comments

·          Excel - Add Text Box

·          Excel - Undo Changes

Formatting Cells

·          Excel - Setting Cell Type

·          Excel - Setting Fonts

·          Excel - Text Decoration

·          Excel - Rotate Cells

·          Excel - Setting Colors

·          Excel - Text Alignments

·          Excel - Merge & Wrap

Intermediate & Advanced Level

Formatting Cells

·          Excel - Borders and Shades

·          Excel - Apply Formatting

·          Formatting Worksheets

·          Excel - Sheet Options

·          Excel - Adjust Margins

·          Excel - Page Orientation

·          Excel - Header and Footer

·          Excel - Insert Page Breaks

·          Excel - Set Background

·          Excel - Freeze Panes

·          Excel - Conditional Format

Working with Formula

·          Excel - Creating Formulas

·          Excel - Copying Formulas

·          Excel - Formula Reference

·          Excel - Using Functions

·          Excel – Bult in Functions

Advanced Operations

·          Excel - Data Filtering

·          Excel - Data Sorting

·          Excel - Using Ranges

·          Excel - Data Validation

·          Excel - Using Styles

·          Excel - Using Themes

·          Excel - Using Templates

·          Excel - Using Macros

·          Excel - Adding Graphics

·          Excel - Cross Referencing

·          Excel - Printing Worksheets

·          Excel - Email Workbooks

·          Excel- Translate Worksheet

·          Excel - Workbook Security

·          Excel - Data Tables

·          Excel - Pivot Tables

·          Excel - Simple Charts

·          Excel - Pivot Charts

·          Excel - Keyboard Shortcuts



تصميم و إنشاء مواقع إلكترونية إحترافية متعدد اللغات اى اس بي و ووردبرس ويضم جميع خدمات الإنشاء و التصميم في الأتي :

Designed & developed by: ITQAN Software