The first thing to get your head around here is what is a Workbook and what is a Worksheet! The answer is – you add your data to a Worksheet or Worksheets, and those Worksheets in turn live inside a Workbook.

When you create a new Workbook in Excel, the default is that it will contain three Worksheets, but you can add many more, or even delete them if you only want one single Worksheet or if you no longer need a specific Worksheet. You can move Worksheets around within the Workbook, and even copy them within the same Workbook or to a different Workbook.

And if you find that you only ever need one Worksheet in each Workbook, you can set the default option to have only one Worksheet in new Workbooks.

You can create a new blank Workbook in a number of ways, so let’s get started with that.

Create a new blank Workbook from the Start screen

  1. Click the Excel shortcut on either your desktop, the Task bar, the Windows Start screen or the Start menu
  2. A window like the one in the picture will pop up.

Figure 1 – Create a new blank workbook

  1. Click on Blank Workbook

Create a new blank Workbook using the keyboard

Once you have Excel open, you can start a new workbook by pressing the Control key and the letter N to create a new workbook: Control + N

Create a new blank Workbook from the Quick Access Toolbar

If you have the icon for New Workbook on the Quick Access Toolbar, simply click on it to create a new book.

Figure 2 – Create a new workbook from the shortcut icon
 

Create a new blank Workbook from the File Menu

  1. Click the File Menu
  2. Click New

Figure 3 – Create a new workbook from the file menu

  1. Select Blank Workbook

Creating New Workbooks Using Templates

Excel comes with many built in templates which can speed up your editing time.

Create A Workbook from A Template

  1. Click File
  2. Click New

Figure 4 – Create from template

  1. Select the template you want to use from those displayed

Search for A Template

In Excel 2016, you can search for many more sample templates online if the local ones do not meet your needs. Let’s say I want to create an invoice template:

  1. Type Invoice into the Search bar and press Enter or click the magnifying glass – a list of templates matching your search are displayed along with Categories on the right of the screen.

Figure 5 – Search for a template

  1. Click on the template you want to use.

Changing worksheet order

If the worksheets in your workbook are not in the right order, you can drag and drop them into the order you need.

Figure 6 – Move worksheets around by dragging

Let’s say I would like to place the Coffee Sales worksheet in front of the other tabs

  1. Click and drag on the Sheet name – you will see a little arrow and a picture of a page
  2. Drop the worksheet in the location you require.

Hey presto!

Move or copy a Worksheet to a different workbook

  1. Right click on the sheet tab you wish to move or copy
  2. Click on Move or Copy
  3. In the dialog box that pops up, select where you want to move the worksheet to (i.e. which of the open workbooks you want to move it to)
  4. Select where you want the worksheet within the workbook
  5. If you want a copy, tick the Create a copy box
  6. Click OK

Figure 7 – Move or copy on a right click

Set the number of Worksheets in a new Workbook

If you always need more than one worksheet when starting a workbook, you can set the Excel Options to start up a workbook with as many worksheets as you need.

  1. Click File
  2. Click Options

Figure 8 – Get to options from the File menu

  1. Set the number of worksheets

Figure 9 – Set the number of worksheets to start with

  • Change – Include this many sheets to the number you require (I have set it to 3 sheets here)
  • Click OK
  1. All new workbooks will now contain three worksheets (or the number you have set)

Figure 10 – Your new settings take effect

I hope that quick introduction to Worksheets and Workbooks will help you get started with your spreadsheets. Now you’ve got the hang of it, you’re ready to enter your data. And, another quick tip, don’t forget to save your Workbooks as you go along!

To learn about Microsoft Excel – visit the Excel Course Category at tomorrow’s VA All Courses (tomorrowsva.com)

Or take a look at the HUB and have access to ALL my courses including any new ones that are added. Always the best value.

The session was well structured and the explanation was very clear. It was amazing how Shelley managed to squeeze so much info in just one hour and a half! Colin’s support and contributions were also very valuable, and so were “Virtual Veronica”‘s. Thank you for a most interesting and useful training session at the Miss Jones Virtual Summit!

Laura Carizzo- Royal Norwegian Embassy in Argentina

I haven’t used PowerPoint in 20 years, this has really boosted my confidence.

Lyn Parker

Course is packed with so much valuable information in a easy-to-understand and follow language, even for a complete beginner. I can respect the fact that sometimes it’s very hard for an expert to break the information down to basics. but Shelley has done it brilliantly. I was sure that I knew quite a bit but Shelley has proven me wrong even at the very beginning of the basics of PowerPoint. Lessons are short and precise which allowed me to easily transfer the new skill into practice without being overwhelmed and to carry on adding on more with each lesson. I had so many ‘Aha!’ moments and for most of them I couldn’t believe I used to pay graphic designer to do it for me, now, thanks to Shelley, I am looking forward to creating, designing, converting my presentations all by myself!

Iva Freeman – Vertex Human Capital

Shelley was very thorough and knew a lot of tip’s for using Teams, thank you 🙂

James O’Connor – Cavannah Homes

Very informative, constantly getting everyone in the meeting involved, loved every bit of it!

Dylan Teal Hopkins – Cavannah Homes
Fantastic and informative training and great to see all of the exciting functions with Microsoft Teams.
Laura Rigby – The Apprenticeship College
Shelley was really clear in her teaching and went at a pace that was helpful to us. We covered all we needed to know to get us started, as a small team, using MS Teams. She was also very helpful in the run up to the session, with check in calls and ensuring our platform was set up correctly. I would highly recommend Shelley to anyone wanting to learn to navigate their way around MS Teams.
Leigh Dowling – Innuous

Microsoft Teams One to One Training Session

Shelley was approachable, easy to work with, and agile with answering questions to apply the session to my specific needs

Melissa Marshall – Present Your Science

A course on Outlook had been on the top of my list when Shelley asked VA’s what they wanted to learn.

It was a real case of ‘so that’s how you do it’ or ‘I never knew that’. I have to say that I learnt so many great tips it has definitely improved the way I work in Outlook and my inbox is looking colourful and organised and I can’t wait to share this knowledge with my clients.

Jacqueline Leake – JLeake VA Services – Outlook

A great course with lots of examples and step by step instructions. I can now confidently create infographics and as a bonus, I learnt a lot of new PowerPoint functionality that will enhance all my PowerPoint work and save me so much time.

Jessica Bailey – Integral Resource

I really like Shelley’s courses. She has a clear and easy to follow teaching style. In ‘How to Create Fillable Forms’ I’ve learned about the functions of the Developer ribbon which will mean I’ll be able to create a bespoke Returns Form for a client who has an online shop

Freya Henderson – Virtual Office Orkney

Shelley was really clear in her teaching and went at a pace that was helpful to us. We covered all we needed to know to get us started, as a small team, using MS Teams. She was also very helpful in the run up to the session, with check in calls and ensuring our platform was set up correctly. I would highly recommend Shelley to anyone wanting to learn to navigate their way around MS Teams.

Sarah Clements – Inuous

Absolutely superb course, easy to follow and to refer back whilst putting it all into practice! I was unaware of the extent you can customise a presentation and it’s just made me want to know more – what’s next Shelley?

Denise Williams

I thought I had a pretty good grasp of Outlook until I did this course! In her videos, Shelley is clear and concise, and the language she uses is straightforward and jargon-free. Each module is broken down into manageable chunks, which helps keep your attention and means the course is easy to fit in around other commitments. I’ve created email templates and implemented rules that are already saving me time, and as all the other things I’ve learnt start to become second nature, the positive impact on my efficiency is fast becoming clear. This course has been incredibly beneficial and I would highly recommend it to anyone looking to strengthen their skills and boost productivity.

Pip Doleman VA

I thought I knew Powerpoint really well, but I wanted to specifically learn how to use Powerpoint to create better infographics, easily and quickly. Shelley explains everything in a very logical and clear way, so I understood everything the first time I heard it. The most useful thing I learnt was that Powerpoint can do so much more than I thought it could. By also using the short cuts that Shelley showed me I am much quicker than I have ever been and I thought I was already quick!

Susan Marot

Shelley Fishel of Tomorrow’s VA has a wealth of experience in Microsoft Office. I met her in person 2 years ago at the PA Show in London. I also saw her in action in a fab workshop and knew she was the whizz that everyone had told me she was. I have since bought a lifetime access to her HUB and all the courses in there are a MUST if you are a VA on a mission. The courses will give you confidence in all the Office 365 components and will catapult you to dizzy heights

Alex Hughes