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.
DurationThis 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.
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.
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.
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.
This course is designed for: New and Experienced HR professionals
This is a complete package to learn MS Excel from scratch and move to intermediate and advanced topics/levels accordingly as required by the student. The skills and knowledge acquired here will help you become a proficient user of MS Excel.
About Coursetakers.ae
Coursetakers.ae is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UAE, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 www.coursetakers.ae All Rights Reserved. Terms and Conditions of use | Privacy Policy