Microsoft Excel: A Definitive Guide for Beginners for Office 365 by Jeanette Dunnett
Ever been curious about Excel and you are not sure where to
begin? Do you want to get better and faster at Excel? Do you want to learn
tricks they don’t teach in Excel course? Do you what to learn how to get the
most of out Excel? Do you feel overwhelmed when learning about or using Excel?
This is the book for you! Microsoft Excel: A definitive Guide for Beginners for
Office 365 covers all the essential topics you need to know.
What will you learn?
This comprehensive book covers many topics for all the essential
skills in Excel. You will learn about what Excel is, reasons to learn it, basic
terminology, the different areas of the Excel screens, terminology, inputting
data, formatting, data manipulation, preparing to print, reviewing
spreadsheets, shortcuts, and the basics on formulas and functions.
- Opening, closing,
and saving workbooks
- How to delete
files, renaming workbooks
- Navigating around
Excel for worksheets and cells
- Resizing screens,
and working with multiple workbooks
- How to move,
copy, and delete worksheets
- Adding, deleting
cells, rows, columns and worksheets
- The different
screen views in Excel
- Learn about the
parts of the Excel worksheet: title bars, ribbons, status and formula bars, the
different cursor types
- Formatting: font
options, text and cell alignment, formatting cells, and the different number
formats in Excel, and the format painter
- Learn about the
basics of inputting data such as copy, cut, paste undo and redo, finding and
replacing data and removing duplicate values
- Sorting,
filtering, and grouping data and working with large volumes of data
- Learn important
shortcuts
- How to proofread
your workbook, add comments and notes
- Learn the basics
about formulas and functions
What are you waiting for? Let’s get started!
