An Overview of the Excel Basics That Will Assist You When Using Excel Functions and Formulas. This Microsoft Excel training class is designed for students to gain the skills necessary to use pivot tables, basic formulas and worksheet sheet tools, utilize data tools, collaborate with others, and create and manage data.

if you are using Microsoft excel for the first time, This course about the basic elements of MS EXCEL. In this, course you will learn, how to create a workbook using a template, add data by typing in a worksheet, create a basic chart, save a workbook, use formulas, shortcuts and much more. Basic Excel - An Overview of the Excel Basics That Will Assist You When Using Excel Functions and Formulas.

Students who have nil skills with Microsoft Excel who want to learn more excel, formulas, calculation skills or students who want to learn the topics covered in this course in the interface. This course if good for Level 1, beginners, school - college - university's students.

After completing this course, students will be able to: Insert the course objectives in a bulleted list with periods. For example.

Create pivot tables and charts

Learn to trace precedents and dependents

Learn functions and dependents calculation

Convert text and validate and consolidate data.

Collaborate with others by protecting worksheets and workbooks

Import and export data

This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

What is the Excel?, Excel Application Setting - Calculation, Vba Tab options, Edit Custom list, Worksheet Calculation, Autocorrect Option, Macro Enable / Disable
Overview of basic Excel skills, Basic Short Keys, Worksheet Operations ,Cell Operation , Format Cells ,Freeze Panes
Shortcuts, keyboard shortcuts, navigation shortcuts, Paste Special - many more paste options
Techniques of Paste Special, Protect Worksheets & Workbooks , Time Saving Utilities ,Format Painter
Text to Columns with fixed and delimited parameters, Data Sorting using custom list ,Summarizing data using Auto Outline
Concept of Cell Referencing, Relative Referencing, Absolute Referencing, Mixed Referencing
Page Setup - Margins, Header and Footers, Orientation, Hyperlinked Spreadsheet, Freezing, much more...

No Additional reading just do practice on sheet given by institute.