Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formulas general

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas in general

Formulas in general

ResolvedVersion 365

Iain has attended:
Word Intermediate course
Access Intermediate course
Excel Intermediate course

Formulas in general

Please may I have some further information on all the forumlas that can be used in Excel (i.e SUMIFs, COUNTIFs and MAXIFs etc)?

RE: Formulas in general

Hello Iain,

Thank you for your question. As you may know, Excel has close to 500 different functions built in, and a limitless number of ways to combine formulas and functions.

You can download some Excel manuals from our website here:

https://www.stl-training.co.uk/microsoft-training-manuals.php

The Excel manuals contain various formulas and functions examples.


Below is a link to a very good website about Excel formulas and functions:

https://exceljet.net/

In this site, you can search for any type of calculation in Excel.


For video tutorials on Excel formulas, try Leila Gharani's Youtube channel below:

https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA

Here, you can also search, e.g. 'leila gharani sumif'

I hope this helps.

Kind regards
Marius Barnard
STL

Wed 12 Jul 2023: Automatically marked as resolved.

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.