![]() ![]() ![]() ![]() Some useful tools that students can use when creating spreadsheets. How to summarise spreadsheet data in Pivot Tables.Ĭreating a Pivot Table in a separate sheet Some of the some of the calculations that can done on date values. That spreadsheets can be used for, such as: It involves:Ĭhapter demonstrates some examples of financial applications It includes:Ĭhapter demonstrates how to create macros and use buttons toĪ payroll linked to payslips. This chapter demonstrates how to link files so that it data isĬhanged in one file other linked files are updated. Statements to ensure calculations are only carried out when It involves:Ĭhapter introduces the IF command which allows Excel to makeĬhapter combines the use of IF and Lookup commands to produce Provides a project for students to apply their spreadsheet skills.Ī payroll for the EasyTune Car Care company.Ĭovers how to use formulas to predict outcomes. Some of the Drawing Tools that can be used to enhance a spreadsheet's Setting the sparkline type (Line, Column or Win/Loss) The more detailed chart techniques, such as: How to manage spreadsheet files using worksheets. This chapter demonstrates how to manage larger spreadsheets and rearrange data within them. ![]() The many cell duplicating commands that Excel provides. Some more detailed cell formatting techniques, such as: Introduces entering labels, values and formulas, formatting cells and worksheets, copying cell data, creating different types of charts such as Pie, Column, Line, Bar and Sparkline charts, and using the drawing tools.Ĭovers IF statements, Lookup commands, creating Sales Invoices, creating Payroll/Payslip systems, using Macros and Buttons, financial and date calculations, creating Pivot Tables, applying Conditional Formatting, and using AutoFormat, Styles and Save options.īasics of formatting the content of cells: It includes: Assignments are provided at the end of each chapter and the multi-user version provides projects at the end of each module. The tutorials can be used onscreen next to the software package, from a tablet or printed. 11: Making Predictions with Excel (12 pages)ġ2: Making Decisions with Excel (19 pages)ġ5: Sharing Data Between Files (24 pages) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |