Using Excel
The Illustrated Guide to using Microsoft Excel
Language - English
Updated on Jul, 2022
Excel,Microsoft Office,Office Productivity,Finance & Accounting
About the Book
Book description
We’ve all been there before, staring at a computer screen with no idea what to do — don’t worry Using Excel 2019 is here to help. Written by best-selling technology author, lecturer, and computer trainer Kevin Wilson, Using Excel 2019 is packed with easy to follow instructions, photos, illustrations, helpful tips and video demos.
You'll want to keep this edition handy as you make your way around Microsoft Excel. Have Fun!
Goals
- Start Excel and find your way around the ribbon menu
- Build spreadsheets, enter data, import data and format text
- Add borders, text orientation, colours and highlights
- Use conditional formatting
- Build formulas to manipulate data
- Use built in functions to add up, average and count data
- Use Lookup and IF functions
- Create charts from spreadsheet data and customise the layout
- Work with workbooks, open, save, and print workbooks
- Basic File Management
- Understand data analysis using goal seek, scenarios, forecasts,
- Build pivot tables and pivot charts
- Use data validation techniques to help keep data entry accurate
eBook Preview
Author Details
Ellumitech
eOur students work
with the Best
Related eBooks
Annual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now