Basics Of Ms Excel

Syllabus

1T4-A: Basics of MS Excel

Unit I

Introduction to Excel – About Excel, Features of MS-Excel, The Excel Environment; Quick Access Toolbar, Title Bar, Ribbon Tabs, Name Box, Formula Bar, Scroll Bars, Status Bar, Page Views, Zoom Tool. Ribbon Display Options Button, Excel Workspace, Cells. Creating Worksheets and Workbooks – Creating and Renaming Worksheets, Saving Workbook, Copying and Moving a Worksheet. Inserting and Deleting Rows and Columns, Inserting Header and Footer in a Worksheet.

Formatting Cells; Selecting Cells, Entering Text and Numeric Data into the Cells, Applying Fonts and Background Colour, Aligning Data, Merging Cells, Text Wrapping, Number Formatting – Text, Percentage, Currency, Dates. Creating Series, Resizing Columns Width and Rows Height. Excel Shortcuts – Using Keyboard Shortcuts 

Unit II

Excel Formulas and Functions – Performing Basic Mathematical Operations using Formula, Applying Formulas using Cell Names and Range, Formatting Text using Different Text Functions, Performing Calculation using Numerical and Mathematical Functions. If Function, Logical Functions-AND, OR, NOT.

Tables - Creating a Table, Applying Styles to Tables, Adding and Editing Records, Inserting Records and Fields, Deleting Records and Fields.

Unit III

Filters, Grouping and Charts in Excel- Filtering Records, Sorting Data by Single and Multiple Columns, Custom Sort, Changing Sort Order, Eliminating Duplicate Records.

Chart Preparation – Creating Charts, Selecting Charts and Chart Elements, Moving and Resizing Charts, Changing the Chart Type. Apply Custom Data Formats and Layouts- Changing the Data Range, Switching Column and Row Data, Choosing a Chart Layout, Choosing a Chart Style, Printing Charts, Deleting Charts, Applying Word Art Styles to Chart Elements.

Unit IV

Introduction to Pivot Tables- Creating Pivot Tables and Pivot Charts, Manipulating a PivotTable, Changing Calculated Value Fields, Applying PivotTable Styles, Creating a PivotChart, Setting PivotTable Options.