Excel

Excel 2016 – 2.11.6 – Multiple Delimiters

Can we use multiple delimiters in the CONCAT() or TEXTJOIN() Functions? Yes we can and this video shows you how.

DETAIL

Excel 2016 – 2.11.5 – TEXTJOIN Over CONCAT

So we can see there are two Functions replacing CONCATENATE(). Now let’s take a look and see the differences between them.

DETAIL

Excel 2016 – 2.11.4 – The TEXTJOIN Function

Another new Function! This is also replacing the CONCATENATE() Function!

DETAIL

Excel 2016 – 2.11.3 – The CONCAT Function

CONCAT() is a new function and is replacing CONCATENATE(). However, it’s not the only one…

DETAIL

Excel 2016 – 2.11.2 – The CONCATENATE Function

You’ve seen how to concatenate manually, now you’ll see how to do it using the CONCATENATE Function. IMPORTANT INFO: This Function is being deprecated – but it’s important to know, for backward compatibility.

DETAIL

Excel 2016 – 2.11.1 – Manual Concatenation

If you need to ‘join’ things together such as combining First Name and Surname into the same cell, then you need to concatenate.  This is how you do it manually.

DETAIL

Excel 2016 – 2.10.20 – The TIMEVALUE Function

Do you have Dates that are actually Text? Well, if you do, then it’s worth using the TIMEVALUE Function, to convert them so that they become calculable.

DETAIL

Excel 2016 – 2.10.19 – Time Exceeds 24 Hours

In topic 5 ‘Calculate Date and Time’ we saw that once you cross over 24 Hours, you have to use a special format. Well, it’s exactly the same when Time crosses over 24 Hours.

DETAIL

Excel 2016 – 2.10.18 – Calculate Minutes With Currency

We’ll take it a step further and show Excel that we’re calculating with Minutes rather than Hours.

DETAIL

Excel 2016 – 2.10.17 – Calculate Time With Currency

If you’ve ever tried it, you know you can get strange results! You just need to let Excel know that it is Time that it is calculating.

DETAIL

Excel 2016 – 2.10.15 – Timesheet Removing Break Times

Now we know how to subtract time, but what if we want to subtract the lunch time from a Timesheet? This video shows you one way to achieve this.

DETAIL

Excel 2016 – 2.10.14 – Subtract Time

We’re going to look at this calculation working, but we’re also going to look at how it can go wrong, and why!

DETAIL

Excel 2016 – 2.10.13 – Time Formatting

Just like Dates, Times can also be formatted to show them the way you wish to see them.

DETAIL

Excel 2016 – 2.10.12 – DATEVALUE Function

Sometimes, when you download data from systems, like SAP, Dates actually come in as Text – which means they are non-calculable. However, if Excel recognises their structure, then it can convert them into Dates that can be calculated, using the DATEVALUE function.

DETAIL

Excel 2016 – 2.10.11 – WORKDAY Function

You know the date that a project is going to start. You know how many days you have to complete it. What you don’t know is the date that it’s going to end, because you need to exclude Saturdays and Sundays – and Holidays. Well, that’s what this function does.

DETAIL

Excel 2016 – 2.10.10 – NETWORKDAYS Function

Do you need to know the number of working days between two dates – i.e. excluding Saturdays and Sundays? Do you also need to exclude holidays? Look no further, this is the function for you!

DETAIL

Excel 2016 – 2.10.9 – WEEKDAY Function

Do you need to be able to show what day of the week it is, on your spreadsheet? The WEEKDAY function and some custom codes can do the job for you.

DETAIL

Excel 2016 – 2.10.8 – DATEDIF Function

You won’t find the DATEDIF function in the Help menu for Excel because it is no longer supported. Yet we can still use it, once we know how.

DETAIL

Excel 2016 – 2.10.7 – EOMONTH Function

Do you have a project that is due in 2 months time, but it’s due at the end of the month? If so, the End of Month is the one that will work out that date for you!

DETAIL

Excel 2016 – 2.10.6 – EDATE Function

If you need to know what the date will be a month from now, or 3 months from now – then this is the function that will give you that.

DETAIL

Excel 2016 – 2.10.5 – Calculate Date and Time

If you’ve ever tried to calculate with Dates and Times that run over the 24 hour period, then you’ll know that you get some very strange results! This video shows you the custom code that you need to use, to overcome this issue.

DETAIL

Excel 2016 – 2.10.4 – Addition with Dates

This video is going to show you how to find a future date by using addition with dates.

DETAIL

Excel 2016 – 2.10.3 – Subtract Dates and Formatting Issues

Dates are easy to calculate with because they are actually numbers. However, sometimes you’ll come across some formatting issues. This video will show you one way to deal with this.

DETAIL

Excel 2016 – 2.10.2 – Custom Date Formatting

This video shows you the codes that you can use to customise Dates to look a different way in the cell, while keeping the correct format in the background, so that we can calculate with our Dates.

DETAIL

Excel 2016 – 2.10.1 – About Dates and Formatting

In this video we’re going to look at the way Excel likes Dates to be entered. We’re also going to look at some shortcuts for putting in Dates.

DETAIL

Excel 2016 – 1.12.6 – Create Custom Views

If you’re in the position that you regularly have to print out information from a file for others and each time you do you have to carry out certain tasks, such as hiding some columns or rows, then this feature is definitely for you!

DETAIL

Excel 2016 – 3.13.12 – Use Solver and Reports

This video shows you how to use Solver and how to create the different reports that it makes available.

DETAIL

Excel 2016 – 3.13.11 – Add Solver to Excel

Solver is NOT part of the default set-up of Excel, which means we need to add it in. This video shows you how.

DETAIL

Excel 2016 – 3.13.10 – About Solver

There are few things you need to be aware of, to use Solver. This video explains them.

DETAIL

Excel 2016 – 3.13.9 – Goal Seek

A lovely simple little feature, that is always handy to know.

DETAIL

Excel 2016 – 3.13.8 – Create a Summary Report

This video shows you the print out that you can get, or Summary Report, from the Scenario Manager.

DETAIL

Excel 2016 – 3.13.7 – Named Cells with Scenarios

This video shows you how to use Named Cells with your Scenarios, which means they are much easier to read and makes for a better print out.

DETAIL

Excel 2016 – 3.13.6 – The Scenario Manager

This video shows the Scenario Manager and how it’s commonly used.

DETAIL

Excel 2016 – 3.13.5 – Two-input Data Table

This video shows how to use two inputs into a Data Table.

DETAIL

Excel 2016 – 3.13.4 – Start-up Data Table

We are still looking at a One-input Data Table but this time we’re looking at a Start-up company. We want to show the Revenue, Profit and Variable Costs associated with differing sales amounts.

DETAIL

Excel 2016 – 3.13.3 – Data Table with Multiple Formulas

This video is still showing a One-input Data Table, but with multiple formulas which produces multiple results.

DETAIL

Excel 2016 – 3.13.2 – Create a One-input Data Table

This video brings you through the steps required to create a One-input Data Table.

DETAIL

Excel 2016 – 3.13.1 – About Data Tables

This video explains what a One-input Data Table and a Two-input Data Table are. It also shows the results after the Data Table feature has been applied.

DETAIL

Excel 2016 – 1.7.11 – Group Worksheets

This feature is one of those ‘must haves’. It allows you to carry out multiple actions, to multiple sheets, at the same time.

DETAIL

Excel 2016 – 1.12.5 – Print Comments or Notes

Back in Lesson 2 you learned how to create Comments or Notes; however, they don’t print automatically. This video shows you how to make them print.

DETAIL

Excel 2016 -1.13.6 – Delete a Style

We’ve created a Style that, I’m sure, you don’t want to keep. So now we’ll look at how to remove a Style, completely.

DETAIL

Excel 2016 – 1.13.5 – Return to the Normal Style

This shows you how to return all your data back to the Normal Style.

DETAIL

Excel 2016 – 1.13.4 – Copy a Style to Another Workbook

When you create your own Style, or edit an existing Style, that change takes place within the current Workbook only. This video shows you how to copy those changes to other Workbooks.

DETAIL

Excel 2016 – 1.13.3 – Create a Style by Example

Do you want to create your own Styles rather than use the built-in Styles? No problem, this video shows you how.

DETAIL

Excel 2016 – 1.13.2 – Edit a Style

This shows you how to edit a default Style and how that change automatically updates on all pages in the Workbook, that are using that Style.

DETAIL

Excel 2016 – 1.13.1 – Apply Cell Styles

This shows you how to apply the pre-made default Styles contained in Excel.

DETAIL

Excel 2016 – 1.2.12 – Create Comments or Notes

You can add comments to cells to help users to work with your data. Depending on the version of Excel that you are using, you might see the choice as Comments – or Notes – or both.

DETAIL

Excel 2016 – 1.8.13 – Custom Date Formatting

Dates are formatted separately to figures and text and this video will show you how to apply custom formatting to dates so that you can display them in the way that you want to see them.

DETAIL

Excel 2016 – 1.8.12 – Custom Format Example

This video shows a practical use of a custom format to display both text and a figure in the same cell. Why is this different to just typing our text directly into the cell? Well, done this way, the cell will remain calculable.

DETAIL

Knowledge Market in Your Business

Knowledge Market is a great source for online video tutorials. We have developed a range of topics based on the applications that you use every day.
So whether you wish to refresh your existing knowledge - or you want to learn something new - we've got everything you need when you need it and where you need it.

Membership

Our Membership options have been developed to suit your specific needs. Contact us today to find out how we can be part of your office support infrastructure.

CONTACT

Email: kelly@knowledgemarket.ie

Performance Support and Learning for:
Microsoft Office – Excel, PowerPoint, Project, Word

Privacy & Cookies

This website uses Cookies. Continued use of the site will be deemed as your acceptance of this necessity.

Please read our Privacy Policy