Niit Excel Tutorial Pdf

Microsoft excel is a spreadsheet program.

Niit excel tutorial pdf. A new worksheet will be added for the pivot table. We use it to create reports that need calculations and charts. Excel will automatically select the data for the pivot table. In this course you will see how to create a basic worksheet by entering text values and formulas change the appearance of worksheet data by using a variety of formatting techniques create formulas by using some of excels built in functions filter and sort excel data etc.

The pivottable field list is located to the right. Specifically you will learn about the following topics. Excel is supported by both mac and pc platforms. This series covers the basic concept formula and features of ms excel.

Niits learning and talent development solutions have received widespread recognition globally. Introduction to the excel spreadsheet preparing a gradesheet learning outcomes this tutorial will help you understand what a spreadsheet is and where a spreadsheet might come in useful for classroom management. Microsoft excel is a powerful electronic spreadsheet program you can use to automate accounting work organize data and perform a wide variety tasksof excel is designed to perform calculations analyze information and visualize data in a spreadsheet. The excel screen name box standard toolbar formula bar active cell menu bar title bar select all button status bar tab scrolling buttons sheet tabs worksheet scroll bars minimize buttons restore buttons close.

Join microsoft excel 2013 classes from niit to become an excel expert. Excel will also automatically select new worksheet as the destination for the pivot table. Understanding the basic concepts of a spreadsheet including. Comprehensive and detailed training support to download free pdf for learning excel from a to z.

Click on the start button. In this workshop we will learn how to move around and work inside the spreadsheet. Microsoft excel for beginners 20 hours this is a basic computer workshop. Microsoft excel is one of the most popular spreadsheet applications that helps you manage data create visually persuasive charts and thought provoking graphs.

Microsoft excel tutorial handout opening microsoft excel 1. This course is complete with examples for each of the topic covered in the series. The sessions demonstrate using native hindi language. Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit them.

Also this application includes database and charting features. Niit advanced excel training course helps you learn advanced topics in ms excel 2013 for data representation and analysis. The company has been named among the top 20 training outsourcing companies for the past seven consecutive years by training industry inc. After completing this course users will learn how use excel for official or personal purpose.