Monday, 8 April 2019
Make Timeline Chart in Excel
Make Timeline Chart in Excel to show time based events in a graph beautifully. A timeline is a type of chart which visually shows a series of events in chronological order over a linear timescale. The power of a timeline is that it is graphical, which makes it easy to understand critical milestone chart, such as the progress of a project schedule.
A graphic timeline displays events chronologically and is a very effective way to visualize information over time. ... Easily create a compelling timeline chart and export it to your presentations
Milestone charts (timeline chart) is a useful tool for project planning chart .
Here is a step by step tutorial to make Timeline Chart in Excel
1 Write the timeline based events in notepad
2 Open Excel
3 Go to Insert Tab
4 Click on Smart Art
5 Choose Process Smartart Graphic
6 Copy the data from the note pad to the text of box 1
7 Delete the empty text boxes
8 Format the chart according to your taste
9 Your Timeline chart is ready !
Top Selling Amazon Products that you may like -
https://www.amazon.in/shop/mye-lesson
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
https://www.youtube.com/watch?v=KyMj8...
Learn Basic Excel Skills For Beginners || Part 1
https://www.youtube.com/watch?v=3kNEv...
10 Most Used Excel Formula
https://www.youtube.com/watch?v=2t3FD...
**Most Imporant Excel Formuls Tutorials**
Learn Vlookup Formula For Beginners in Excel
https://www.youtube.com/watch?v=vomCl...
5 Excel Questions Asked in Job Interviews
https://www.youtube.com/watch?v=7Iwx4...
Create Speedometer Chart In Excel
https://www.youtube.com/watch?v=f6c93...
Learn the Basic of Excel for Beginners || Part 2
https://www.youtube.com/watch?v=qeMSV...
Create Pareto Chart In Excel
https://www.youtube.com/watch?v=2Udaj...
How to Create Dashboard in Excel
https://www.youtube.com/watch?v=RM8T1...
Excel Interview Questions & Answers
https://www.youtube.com/watch?v=Zjv1I...
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook - https://www.facebook.com/excelmadeasy/
Connect with us on Twitter - https://twitter.com/Excelmadeasy
Monday, 18 June 2018
Thursday, 24 May 2018
Tuesday, 22 May 2018
Friday, 11 May 2018
Split First Name Middle and Last Name in Excel
Split Name First Middle and Last name in Excel with formula. There are 4 Excel formulas that we can use to extract names in excel.
1- Left Formula
2 - Mid Formula
3 - Right Formula
4 - Len Formula
To split middle name in Excel, the main idea is to find the spaces between the first name and the last name. Once that is done then it become easy to split words or extract words in excel.
Extract First name in Excel
The first name starts with the first character from the left (E) and ends at the fifth character (the first space). The formula extracts the first five characters in A2, starting from the left.
Formula for separating a first and last name, plus middle initial
Use the SEARCH function to find the value for num_chars:
Search for the numeric position of the space in A2, starting from the left. (5)
Split Middle name in Excel
The middle name starts at the sixth character position (S), and ends at the eighth position (the second space). This formula involves nesting SEARCH functions to find the second instance of a space.
The formula extracts three characters, starting from the sixth position.
Details of a formula for separating first, middle, and last names
Use the SEARCH function to find the value for start_num:
Search for the numeric position of the first space in A2, starting from the first character from the left. (5).
Add 1 to get the position of the character after the first space (S). This numeric position is the starting position of the middle name. (5 + 1 = 6)
Use nested SEARCH functions to find the value for num_chars:
Search for the numeric position of the first space in A2, starting from the first character from the left. (5)
Add 1 to get the position of the character after the first space (S). The result is the character number at which you want to start searching for the second instance of space. (5 + 1 = 6)
Search for the second instance of space in A2, starting from the sixth position (S) found in step 4. This character number is the ending position of the middle name. (8)
Search for the numeric position of space in A2, starting from the first character from the left. (5)
Take the character number of the second space found in step 5 and subtract the character number of the first space found in step 6. The result is the number of characters MID extracts from the text string starting at the sixth position found in step 2. (8 – 5 = 3)
Split Last name in Excel
The last name starts six characters from the right (K) and ends at the first character from the right (n). This formula involves nesting SEARCH functions to find the second and third instances of a space (which are at the fifth and eighth positions from the left).
The formula extracts six characters in A2, starting from the right.
The second SEARCH function in a formula for separating first, middle, and last names
Use the LEN and nested SEARCH functions to find the value for num_chars:
Search for the numeric position of space in A2, starting from the first character from the left. (5)
Add 1 to get the position of the character after the first space (S). The result is the character number at which you want to start searching for the second instance of space. (5 + 1 = 6)
Search for the second instance of space in A2, starting from the sixth position (S) found in step 2. This character number is the ending position of the middle name. (8)
Count the total length of the text string in A2, and then subtract the number of characters from the left up to the second instance of space found in step 3. The result is the number of characters to be extracted from the right of the full name. (14 – 8 = 6).
You can download this file from http://www.myeleson.org/downloads
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook - https://www.facebook.com/excelmadeasy/
Connect with us on Twitter - https://twitter.com/Excelmadeasy
Wednesday, 4 April 2018
Create Interactive Form in MS Word
Create Interactive Form in MS Word
Create Fillable Interactive Form in MS Word and use them to get data entry work done quickly in MS word . The forms are interactive and can have Calendar, Drop Down lists, Picture and much more built into word forms .
Saturday, 31 March 2018
Monday, 26 March 2018
How To : Convert Excel to PDF
Learn how to convert excel to pdf file without any additional software. This can be used to convert any numbers of excel files to pdf format.
Sunday, 25 March 2018
Find and Delete Blank Rows in Excel
Find and Delete Blank Rows in Excel
Find and Delete Blank Rows in Excel in one time . You can find all blank rows and delete them at once in excel ! I used the 2 features of excel to delete the blank rows in excel.
How to find and delete all blank rows and delete them
1 - Use Counta formula to identify blank rows
2 - Apply filter to get all blank rows together
3 - Delete all blank rows !
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook - https://www.facebook.com/excelmadeasy/
Connect with us on Twitter - https://twitter.com/Excelmadeasy
Saturday, 17 March 2018
Wednesday, 14 March 2018
Averageifs Formula in Excel
Averageifs formula in Excel is used to calculate averages based on multiple conditions so it Returns the average of all cells that meet multiple criteria.
Subscribe to:
Posts (Atom)