Everyone

EDUTREE

KitKat

MS Excel 2010 Contents (हिंदी-Eng-தமிழ்) 

Chapter-1

1.    Introduction to Microsoft Excel 2010.

2.    Touring the interface.

3.    Finding the commands you need.

4.    Maintaining file compatibility.

Chapter-2

1.    Creating a worksheet.

2.    Entering data automatically with Auto Fill.

3.    Changing a worksheet's structure.

Chapter -3

1.    Understanding formulas and functions.

2.    Addingnumbersmanually.

3.    Adding numbers using Sum and AutoSum.

Chapter -4

1.    Working with numbers in columns.

2.    Preventing errors using absolute references.

3.    Using IF.

4.    Naming and using cell ranges.

Chapter -5

1.    Applying fonts, background colors, and borders.

2.    Using conditional formatting.

3.    Adding pictures and shapes

Chapter -6

1.    Inserting smartArt.

2.    Applying built-in styles.

3.    Using templates.

Chapter -7

1.    Making the pieces fit.

2.    Inserting headers and footers.

3.    Printing and PDFs.

Chapter -8

1.    Finding and replacing data.

2.    Freezing panes.

3.    Creating multiple customworksheet views.

Chapter -9

1.    Hiding or grouping rows and columns.

2.    Managing worksheets.

3.    Calculating formulas across worksheets.

Chapter -10

1.    Importing and exporting data in Excel.

2.    Setting workbook permissions.

3.    Sharing a workbook.

Chapter -11

1.    Splitting cell data into multiple cells.

2.    Joining data from multiple cells.

3.    Using tables to sort and filter data.

Chapter -12

1.    Using auditing to diagram.

2.    Working with GoalSeek.

3.    Using scenarios in formulas.

Chapter -13

1.    Creating a basic PivotTable.

2.    Modifying a PivotTable.

3.    Creating and modifying a PivotChart.

Chapter -14

1.    Inserting Spark lines.

2.    Creating a column chart.

3.    Placing Excel charts into other Office applications.

Chapter -15

1.    Understanding macros.

2.    Recording and using a simple macro.

3.    Editing a macro.

Chapter -16

1.    Customizing the Quick Access toolbar.

2.    Setting Excel options.

.

LearnEXCEL2010 (हिंदी-Eng-தமிழ்) video course

LearnEXCEL2010 (हिंदी-Eng-தமிழ்) video course ਦਾ ਨਵਾਂ ਵਰਜਨ