This course will help the students and professionals to learn to make effective use of MS Excel in data analysis and presentation

Topics Covered

Brushing up the Basics • Entering data and Editing Cells • Inserting Rows and Columns • Moving and Copying data • Freezing and unfreezing panes • Printing Options • Creating/renaming/deleting worksheets • Using Comments • Using the Find and Replace text • Creating Charts Formatting Techniques • Different types of formats • Conditional formatting • Custom Number Formats • Creating and Using Styles • Adjusting the text alignment Functions and Formulas • Entering and editing formulas • Mathematical functions (Arithmetic, Exponential, Log, Trigonometric functions) • Statistical Functions (AVERAGE, STDEV, MEDIAN, MAX, MIN) • Financial Functions (NPV, PV, RATE) • Logical functions (IF, NOT), Nested IF, IFERROR • Date related functions (Date, Month, Year) Working with Multiple Workbooks and Applications • Creating Workspace • Working with multiple Workbooks • Creating and Using Hyperlinks • Copy Excel data and charts to Word and Power Point Advanced Features • Using Data validation • Using COUNTIF, SUMIF, and VLOOKUP Functions • Using Pivot Tables • Solving an equation using Data>Goalseek Using workbook Protection • Protecting Workbooks and Worksheets • Protecting Cells and Formulas

Who should attend

Students or Professionals

Pre-requisites

None

What you need to bring

You should have MS Excel 2007 loaded on your computer

Key Takeaways

• Fair knowledge of various menus and commonly required functions in Excel • Use of shortcut keys for improving efficiency of Excel usage • How to use Excel to create and manage worksheets for Attendance record, Exam results etc. • Creating charts for pictorial presentation of data • Using statistical functions for analyzing the data, e.g. Average, Min. marks, Max. marks etc. • Creating summary reports efficiently: using Pivot tables • Capturing outliers in a data set: using conditional formatting • Sorting, finding, replacing, organizing the data • Printing of reports and charts in Excel • Copy data from Excel to Word or Excel to Power Point presentation