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 |