While Excel has a myriad of uses, it really comes into its own when it comes to calculating numbers. Perhaps you’ve used it to add up a list of numbers or to carry out a multiplication or division? And if you have, you’ve probably used the plus (+), minus (-), multiply (*) or divide (/) symbols.

However, some calculations can become very complicated and long-winded if you try and create them by writing a formula. For example, a calculation such as finding the Average of a group of numbers could become quite long if you were to work it out for yourself. Similarly, if you have 300 items that you want to add up, it would be tedious to write a long formula with 300 calculations.

So, this is where the built-in Functions in Excel come in. These are specially programmed formulas that allow you to perform more complicated calculations much more easily.

Let’s have a look at how this works and at some basic functions.

The structure of a basic function

Because functions are so varied, the details of their construction are unique, but they all follow a similar basic structure.

A function always begins with an Equals sign, followed by the Function name, then the details of the function in brackets. For example:

=Average(B3:B6)

Where Average is the Function name and the cell references in brackets are the cells to calculate. The content between the brackets will be always be different depending on the function used.

Using Basic functions via the Auto Sum Button

The Auto Sum button contains five commonly used basic Functions. These are SUM, AVERAGE, COUNT Numbers, MAX and MIN.

Figure 1 – Excel has some regularly used functions available from the AutoSum button

To use a basic function using the Auto sum button

  1. Click on the cell where you want the result of the calculation
  2. Go to the Editing group on the Home tab on the ribbon
  3. Click on the AutoSum drop down button
  4. Select the Function you require

Figure 2 – Sum a column using AutoSum

  1. The cells Excel thinks you want to calculate will be highlighted and the Function will appear in the cell – If Excel hasn’t selected the cells you want, click and drag over the ones you do want to include
  2. Press Enter
  3. The answer will be shown in the cell

Magic! I bet you found that easier than you expected. Excel has hundreds of built-in functions based on the same principles, so once you have mastered these basic functions, you’ll have the confidence to move on to these. Excel is your playground, just waiting for you to explore it.

To learn more about Microsoft Excel visit the Excel category of courses on tomorrow’s VA All Courses (tomorrowsva.com)

Or why not take 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