How to use Microsoft office EXCEL CONCATENATE function easily and efficiently This function in excel is used to connect cells values into one value. What is Excel concatenation function? The Microsoft Excel CONCAT function allows you to join 2 or more strings together. It was released in Excel 2016 and replaces the CONCATENATE function. The CONCAT function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the CONCAT function can be entered as part of a formula in a cell of a worksheet.

Learn how in this video to create a drop down box in a Microsoft Excel Cell.
If you would like to learn how to use Microsoft Excel effectively visit - www.NQTraining****/LearnExcel.asp
We also have available Microsoft Excel Cheat Sheets that will help you work with Microsoft Excel effectively visit - www.NQTraining****/MicrosoftOfficeCheatSheets.asp

Learn how to work with Excel's Menus and how to turn the Expanding Menus and recently used commands on and off in Microsoft Excel 2003.
If you would like to learn more about Microsoft Excel 2003 visit our website - www.NQTraining****/learnexcel.asp

Learn how in this video how to create a header and footer using the default options found in the Page Setup dialog box.
If you would like to learn more about Microsoft Excel then visit our website - *******www.NQTraining****/learnexcel.asp

In this video you will learn how to create a custom header and footer. You will learn how to insert items such as dates, times, custom text, file names and worksheet names into the header and footer. You will also learn to add page numbers.
To learn more about Microsoft Excel 2003 visit our website - *******www.NQTraining****/learnexcel.asp

In this video you will learn how to split a screen in Microsoft Excel into multiple panes. You will also learn how to remove the split screen as well.
If you would like to learn more about Microsoft Excel then visit - *******www.NQTraining****/learnexcel.asp

In this video you will learn how to Freeze your headings in your spreadsheet. Doing this will ensure that as you scroll through your data, you will still be able to see your worksheet headings.
To learn more about Microsoft Excel simply visit our website - *******www.NQTraining****/learnexcel.asp