In this video, staff author Jess Stratton shows users how to work with individual cells, such as formatting text and data type, and using preset styles.
- [Instructor] Let's go over some basic cell techniques…that you'll be using on a day to day basis.…The first thing that you might want to do is…format your cells.…I'll click and drag to highlight them all.…On the home ribbon tab, here's where you…can change the data type.…Right now it's set to number…but you can use the dropdown list…and change to anything, such as currency,…short date, long dates, times,…percentages, fractions.…You can also change what type of currency,…where you want the decimal point to go,…and if you want the zeroes at the end…of the dollar signs, or not.…
If you prefer to work with a dialog box…you can click the down arrow to the right…of the number format pane…and it's going to bring up a dialog box…where you can work with more settings.…For example, in the currency area…you can quickly set the amount of decimal places…you want, what kind of currency symbol you're using,…and how you want negative numbers portrayed.…You'll find that you get different options…for each data type that you choose.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Converting Google Sheets to Excel format
- Working anywhere with Excel Online
- Working with sheets
- Creating an Excel table
- Applying conditional formatting
- Working with formulas
- Working with charts and sparklines
- Sharing files and collaborating with others
- Reviewing and tracking changes