Chat with us, powered by LiveChat
Showing 13 Result(s)

Introducing Power BI mobile app’s new look (preview)

Introducing Power BI mobile app’s new look (preview) Power BI Mobile provides the tools users need to stay connected to their data, wherever business takes them. But, as organizations grow, we understand that it’s increasingly difficult for Power BI users to discover and manage the content that matters to them on the go.  It’s important …

Excel for Data Sciencists

Essential Excel Functions for Building Financial Models

Essential Excel Functions for Building Financial Models Financial modelling is ALL about the functions! Basically, the whole point of building a financial model is so that when the inputs change, the outputs change as well – so a good financial modeller will know lots of lots of functions. Check out my list of favorite Excel …

How to Split First Name and Last Name in Excel using LEFT and RIGHT Functions

How to Split First Name and Last Name in Excel using LEFT and RIGHT Functions

How to Split First Name and Last Name in Excel

Microsoft Excel offers 2 ways of splitting Text strings in Excel cells. This tutorial explores the use of LEFT and RIGHT Functions to achieve this with the support of the LEN and FIND Functions. The names of salesmen are listed in column A and we would like the first name and last name to go to column B and C respectively.

Watch the video below.

The Microsoft Excel Workbook can also be downloaded here How-to-split-first-name-and-last-name-in-Microsoft-Excel.xlsx

 

Share with your followers...
Email this to someone
email
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Insert a named range into a formula in Excel

Insert a named range into a formula in Excel

Insert a named range into a formula in Excel You can quickly insert a named range to a formula that you are building in your Excel spreadsheet. Using named ranges in formulas makes it easier to build and maintain formulas. Using a named range in a formula also makes the formula look more user-friendly. Insert …

Define and solve a problem by using Solver

Define and solve a problem by using Solver

Define and solve a problem by using Solver Excel Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a …

× Chat with us!