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

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.

.