Introduction to Excel Introduction to Excel interface Understanding rows and columns Understanding Cell Naming Working with Excel workbook and sheets Formatting Excel workbook New, Open, Close, Save, Save As Formatting Text: Font Size, Font Style Font Color, Use the Bold, Italic, and Underline Wrap text, Merge and Centre Currency, Accounting and other formats Modifying Columns, Rows & Cells Perform Calculations with Functions Functions Mathematical Functions Real Time Example Formulas & Problems Sort and Filter Data Using number filter, Text filter Custom filtering Removing filters from columns Conditional formatting Create Effective Charts to Present Data Visually Inserting Column, Pie chart etc. Create an effective chart with Chart Tool Design, Format, and Layout options Adding chart title Changing layouts Chart styles Editing chart data range Editing data series Changing chart