Advance Excel

by Option Training Institute FZ LLC

This is an advanced level course and it will teach you about organizing, recording and sorting data, entering the text and mathematical equations, keeping the tracks, chart, graph, and compare statistics and so much more.

Price : Enquire Now

Contact the Institutes

Fill this form
Option Training Institute FZ LLC Logo

img Duration

20 Hours

Course Details

This is an advanced level course and it will teach you about organizing, recording and sorting data, entering the text and mathematical equations, keeping the tracks, chart, graph, and compare statistics and so much more.

 

Chapter : MS Excel

A. Getting Started

  • Use of Online templates

  • Spreadsheet Terminology

  • The Excel Environment

  • Navigating a Worksheet

 

B. Home

  • Clipboard

  • Font

  • Alignment

  • Numbers

  • Styles

  • Cells

  • Editing

 

C. Insert

  • Tables – Pivot Tables

  • Inserting and Deleting Ranges, Rows, and Columns

  • Illustrations – Pictures, shapes, smart art

  • Charts – Charts basics, Formatting Charts

  • Sparkline

  • Reports

  • Links - hyperlink

  • Text – Header & Footer

  • Symbols

 

D. Page Layout

  • Themes

  • Page Setup – Margins, orientations, size , background

  • Scale to Fit

  • Sheet Option – Gridlines,, headings

  • Arrange

 

E. Formula

  • Function Library

  • Moving and Copying Data

  • Moving, Copying, and Viewing Formula

  • Absolute and Relative References

  • Entering Functions

  • Lookup & Reference – VLOOKUP , HLOOKUP

  • AutoSum

  • Other Common Functions

  • FORMATTING- Text Formatting

  • Row and Column Formatting

  • Number Formatting

  • Conditional Formatting

  • Additional Formatting Options

  • SmartArt Graphics

  • F. Data

  • Sort & Filter

 

G. Review

  • Proofing - Spelling and Grammar, Thesaurus

  • Language

  • Comments

  • Compare

  • Protect – protect Workbook, protect sheet

 

H. View

  • Workbook View

  • Show

  • Zoom

  • Window

 

I. Printing

  • Printing Worksheets

  • Page Setup Options

 

In Dubai, Option is offering preparatory guidance and tutorial for various examinations such as the GMAT, GRE, SAT, ACT, AP, UCAT and LNAT. Feel free to post your queries regarding our latest batches, study centre, courses, study material, lecturers/trainers/instructors, fees or any other questions and doubts related to our services.

We’d also like to hear your ideas and suggestions to make ameliorations in our efforts and offerings to provide you with the best of services.

Simply type your doubt or query; suggestion or improvement; or just a tiny message that you have for us in the space provided with your name and email address and we’ll work towards delivering to you our best.

  • Knowledge Village Branch

    FZ LLC G 37 & G 34, Block 13, Al Sufouh Road Knowledge Park, Knowledge Village, Dubai
  • Teacher's Name
  • N/A
  • Teacher's Experience
  • N/A
  • Gender
  • Male
  • Teacher's Nationality
  • Indian

Check out more MS Excel courses in UAE

Focus Training and Educational Institute Logo

MS Excel

The centerpiece of Microsoft Office, "Excel," is a significant contribution and a spreadsheet application that was created exclusively for business use. It was created to manage data transformations such as arithmetic operations and more.

by Focus Training and Educational Institute
  • Price
  • Start Date
  • Duration
Knowledge Point Institute Logo

Certificate In MS Office

Master the essential tools of Microsoft Office with Knowledge Point Institute's comprehensive MS Office course. This course covers the core applications: Word, Excel, PowerPoint, and Outlook, providing you with the skills needed to excel in both academic and professional environments.

by Knowledge Point Institute
  • Price
  • Start Date
  • Duration
Focus Training and Educational Institute Logo

Ms Office

Microsoft Office is a program that includes all of the technological requirements for a corporate working environment. Each application performs a unique task and offers its users a certain service.

by Focus Training and Educational Institute
Al Muhairi Computer & Management Training Institute (AMC) Logo

Microsoft Office (Word, Excel, Powerpoint)

KHDA attested certificate can be provided to students.This course will prepare you to use all important modules of MS Office suite like MS Excel, Word and Powerpoint. It also discusses other skills like browsing techniques, email, the intern

by Al Muhairi Computer & Management Training Institute (AMC)
  • Price
  • Start Date
  • Duration
Octus Mindz Training Institute Logo

Excel Basics to Advance Level

Learn to work with Excel by covering all the skills and knowledge from the basics to advanced in this course by Octus Mindz.

by Octus Mindz Training Institute
  • Price
  • Start Date
  • Duration

© 2024 www.coursetakers.ae All Rights Reserved. Terms and Conditions of use | Privacy Policy