by John Legge | Jun 23, 2021 | Excel Tips, Hints and Tips, Microsoft Office Courses Leicestershire
SUMIF and COUNTIF Functions in Excel – how can I use these functions in my worksheets? This week’s hint and tip is about the SUMIF and COUNTIF functions in Excel and how you can use them in your worksheets. These are covered on our intermediate Excel...
by John Legge | Nov 11, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Leicestershire
Financial Cell Formatting in Excel – how can I use this formatting in my spreadsheets? Watch the video to learn more This week’s hint and tip is on financial cell formatting in Excel. This looks at this specific type of cell formatting and how it can be...
by John Legge | Sep 23, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Leicestershire
PDF Data into Excel – how can I use the ‘Get Data’ feature in my spreadsheets? Watch the video to learn more This week’s hint and tip is about getting PDF data into Excel using the ‘Get Data’ feature. This option isn’t on any...
by John Legge | Jul 22, 2020 | Hints and Tips, Microsoft Office Courses Leicestershire, Word Tips
Inserting and defining bullet points – how do I do this? Watch the video to learn more This week’s hint and tip is about how to insert and define a new bullet point within Excel. This is on our Intermediate Word course and it covers where the options are...
by John Legge | Jun 17, 2020 | Hints and Tips, Microsoft Office Courses Leicestershire, Word Tips
Reveal Formatting in Word – how can I use this command in my documents? Watch the video to learn more This week’s hint and tip is about reveal formatting in Word and how you can use it in your documents. This feature isn’t covered in our courses, so...
by John Legge | Sep 4, 2019 | Excel Tips, Hints and Tips, Microsoft Office Courses Leicestershire
Excel Tables – how you can use them within Excel to make named ranges more flexible This week’s hint and tip is about creating a table from your data in Excel and how it makes named ranges more flexible this way than just selecting and naming the range of...
