Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Using Excel

The Illustrated Guide to using Microsoft Excel

person icon Kevin Wilson

ebook icon Elluminet Press

language icon Language - English

updated on icon Updated on Jul, 2022

category icon Office Productivity,Microsoft,Excel

price-loader

This eBook includes

Formats : EPUB, PDF (Downlodable)

Pages : 155

ISBN : 9781913151041

Language : English

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
Using Excel

eBook Preview

Author Details

Ellumitech

<a href="https://market.tutorialspoint.com/author/kevin_wilson">Kevin Wilson</a>

Ellumitech, a division of Elluminet Press Ltd, specializes in creating and delivering high-quality, instructor-led online courses and ebooks. Committed to serving students, professionals, and lifelong learners worldwide, Ellumitech combines innovation and expertise to provide engaging and accessible educational content across diverse subjects.

Building on the trusted reputation of Elluminet Press Ltd, Ellumitech focuses on practical, actionable knowledge through interactive learning experiences. Designed to meet the demands of modern learners, its courses foster inclusivity and deliver impactful results.

With a mission to simplify complex topics, Ellumitech equips learners with the tools to thrive in an ever-changing world. Whether you're upskilling for your career, expanding academic horizons, or pursuing personal growth, Ellumitech ensures a seamless, enriching journey to success.

Our students work
with the Best

Related eBooks

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515