From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use Excel's Advanced Options to fine-tune settings and increase efficiency

Use Excel's Advanced Options to fine-tune settings and increase efficiency - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use Excel's Advanced Options to fine-tune settings and increase efficiency

“

- [Instructor] Excel contains a variety 2 of different settings and options, 3 and a number of them are found in an area 4 that is widely overlooked. 5 It's based on the File tab up in the ribbon. 6 We refer to them as Excel Options. 7 We've got a few screenshots here 8 reminding us of some of these features. 9 And again, depending upon how you use Excel, 10 they might or might not be important. 11 You can, every time you create a new workbook, 12 automatically have a certain number of sheets in it. 13 For example, maybe you work for a company 14 that has offices in six states. 15 You're involved in a project, 16 you're about to create a number of different workbooks. 17 It's always going to be handy 18 to have six worksheets in each one. 19 Make it easy, instead of creating them later, 20 create them automatically as you create new workbooks. 21 Possibly when you're entering decimal type data, 22 maybe it's…

Contents