Tutorialspoint

Using Excel

The Illustrated Guide to using Microsoft Excel

About the Book

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
Show More

eBook Preview

Author Details

With over 20 years’ experience in the computer industry, Kevin Wilson has made a career out of technology and showing others how to use it. After earning a master's degree in computer science, software engineering, and multimedia systems, Kevin has held various positions in the IT industry including graphic & web design, digital film & photography, programming & software engineering, developing & managing corporate networks, building computer systems, and IT support. He serves as senior writer and director at Elluminet Press Ltd, he periodically teaches computer science at college, and works as an IT trainer in England while researching for his PhD. His books have become a valuable resource among the students in England, South Africa, Canada, and in the United States. Kevin's motto is clear: "If you can't explain something simply, then you haven't understood it well enough." To that end, he has created the Exploring Tech Computing series, in which he breaks down complex technological subjects into smaller, easy-to-follow steps that students and ordinary computer users can put into practice.

Using Excel
This eBook Includes
  • Formats EPUB (Downlodable)
  • Pages 155
  • ISBN 9781913151041
  • Language English
price-loader