O'Reilly logo

Office 2016 All-In-One For Dummies by Peter Weverka

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1

Up and Running with Excel

In This Chapter

arrow Creating an Excel workbook

arrow Understanding what a worksheet is

arrow Entering text as well as numeric, date, and time data

arrow Using the AutoFill command to enter lists and serial data

arrow Setting up data-validation rules

This chapter introduces Microsoft Excel, the official number cruncher of Office 2016. The purpose of Excel is to track, analyze, and tabulate numbers. Use the program to project profits and losses, formulate a budget, or analyze Elvis sightings in North America. Doing the setup work takes time, but after you enter the numbers and tell Excel how to tabulate them, you’re on Easy Street. Excel does the math for you. All you have to do is kick off your shoes, sit back, and see how the numbers stack up.

This chapter explains what a workbook and a worksheet is, and how rows and columns on a worksheet determine where cell addresses are. You also discover tips and tricks for entering data quickly in a worksheet and how to construct data-validation ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required