Microsoft Excel
Week-Wise schedule

Week 1 Day 1 Getting Started with Excel - Excel Spreadsheets
Day 2 Launching and Exploring and Entering data into a Spreadsheet
Day 3 How to Widen Rows and Columns in Excel and Centring Data in a Cell
Day 4 Font formatting in Excel and Saving your work
Day 5 Entering Data into Cells - The Spreadsheet
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 2 Day 1 AutoFill and Entering formulas in Excel
Day 2 Adding up with SUM
Day 3 Extending the Spreadsheet ,Adding up Rows in Excel,Copy and Paste in Excel
Day 4 Multiplying , Weekly and Annual Sums
Day 5 Adding Comments to Cells
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 3 Day 1 Excel charts, Sorting Data, Create a Bar Chart
Day 2 Formatting the Chart ,Resizing the Chart , Creating a Pie Chart
Day 3 math operators in Excel - The Basic Operators
Day 4 Combining mathematical Operators
Day 5 A Budget spreadsheet
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 4 Day 1 An introduction to Functions - The Average Function
Day 2 Date and Time Functions in Excel
Day 3 Financial Functions in Excel
Day 4 Conditional Logic and Conditional Formatting
Day 5 The CountIF Function , The AND and SUMIF functions in Excel
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 5 Day 1 Excel Tables
Day 2 Scenarios in Excel
Day 3 How to use Goal Seek
Day 4 Absolute versus Relative cell referencing
Day 5 Named Ranges in Excel , Using Named Ranges
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 6 Day 1 Pivot Table in Excel
Day 2 Data Input Forms in Excel
Day 3 Data Validation in Excel , Displaying Error Messages
Day 4 Web Integration and Excel
Day 5 How to Create a Web Query in Excel
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 7 Day 1 How to Add Hyperlinks in Excel
Day 2 Insert a spreadsheet into a Word document
Day 3 Reference a formula in a different Worksheet
Day 4 Insert drawing objects into spreadsheets
Day 5 Insert images into Excel
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions

Back

List of Practice Lab Rooms to connect

No Practice Lab Rooms were created to connect