Publisher's Synopsis
This is a guide for you on how to use Microsoft Excel. The various features provided by Excel have been discussed; hence you will know how to use them. You are guided on how to use Excel worksheets including creating new worksheets, copying worksheets, hiding worksheets, moving data etc. The author also helps you know how to format Excel cells including rotating cells, changing color, merging, wrapping etc. Excel supports the use of arithmetic operators for calculation of arithmetic operations. These have been discussed. Excel data can be validated, filtered and grouped. The author helps you know how to do this on your data. With Excel, you can also sort your data. This book guides you on how to do this. With numeric data, you may need to perform a number of calculations. This can easily be done using formulas. The author helps you know how to apply formulas and functions on your data. You are also guided on how to insert various graphics into your Excel worksheet. Excel macros allow Excel users to automate most of the tasks that they do on a daily basis. This makes it easy for them to use Excel. This book guides you on how to create Excel macros. Charts and tables have also been discussed. Here is a preview of what you'll learn:
- What is Excel?
- Excel Worksheets
- Formatting Cells
- Arithmetic Operations
- Validating, Grouping and Filters
- Data Sorting
- Ranges
- Formulas
- Working with Graphics
- Excel Macros
- Charts and Tables
