MS Word Training data
Download : -> Address Book Download :-> Report_Indian-Oil
Welcome to masteringexcel.in
Download : -> Address Book Download :-> Report_Indian-Oil
Are you working in the HR department any facing problem to create page wise PDF increment letter and want to send automatically to all the employee respective PDF file. Solutions are here!!! Please watch this video till the end. Follow me on Instagram: https://lnkd.in/g2WdpJgYoutube: https://lnkd.in/gNp4BKtFacebook https://lnkd.in/ger2hiqLinkedin: https://lnkd.in/dtKkWnu Visit my web site www.masteringexcel.in Do subscribe to our YouTube channel & get […]
Advanced Filter means to filter your data on basis of complex conditions from the same worksheet or a different workbook. when a regular filter not able to filter data what you expect then we can go for an advanced filter. Advanced Filter is available in all versions of Excel from 2003 to 2019 👉 Steps […]
Select Data and use Ctrl+E
Click here to Download MS Word Manual Line Spacing Ctrl+2 -Double Line Spacing Ctrl+1 -Single Line Spacing Ctrl+5 -1.5 line Spacing Alignment Left Alignment – Ctrl + L Right – Ctrl + R Center – Ctrl + E Justify – Ctrl +J Indentation 1) First Line Indent 2) Left Indent 3) Right Indent 4) Hanging […]
Gantt Chart is very useful chart in Project Management. Gantt chart is used for Scheduling and planning a project. A Gantt chart is a type of bar chart that demonstrates a project schedule. 1) Prepare MS Excel Sheet. We have Four column first column contents Task name, Start Date, Finish date and Duration follow Image 1 2) […]
1) Make Excel Sheet Read only. Review tab -> Protect Sheet. 2) Make your Excel Workbook Partial Protected i) Select the table -> Right Click -> Format Cells -> Change Protection Check Box. 3) Protect Structure or Worksheet. Review tab -> Protect Workbook -> Type Password 4) Set Opening Password File -> Save As -> […]
Funnel charts are a type of chart, often used to represent stages in a sales process and show the amount of potential revenue for each stage. This type of chart can also be useful in identifying potential problem areas in an organization’s sales processes. Create a table in MS Excel like this. Select MS Excel Table -> Insert […]
Pre Test MS Excel Post Test MS Excel
Live Example
Click here to Download
Microsoft have created nice printable quick start guides for you. These printable materials can help new users getting oriented in the interface. or You can Download the PDF files for Excel, PowerPoint, Word, Outlook, OneNote, OneDrive, Teams, SharePoint, and Yammer. Download the files using the link below: Excel – Quick Start Guide PowerPoint- Quick Start […]
Steps to Populate Multiple Columns using Single Vlookup ——————————————————— 1) Select Columns or range of cells where we want to write formula. 2) Type Formula =VLOOKUP(A3,’Material Master’!A:E,{3,5,2},0) (AnchorData is name range of Master data) 3) Press Ctrl +Shift+ enter
Steps to Create Linier Series in Excel/WPS Spreadsheet———————————————————–1) Select any cell 2) Home Tab -> Rows & Columns -> Fill -> Series (WPS) / Home Tab -> Fill -> Series (MS Excel ) 3) Select Column Option -> Type Stop Value -> OK How to create date series Type first date manually -> Select the […]
Insert alternate blank rows using VBA code. Many time in MS Excel training program participants asked this Question. How to insert alternate blank rows. This is our input screen. After VBA Macros sheet will look like this. Open VBE (Visual Basic Editor ) Press Alt + F11 or ALT +Fn+F11 , Visual Basic Editor screen […]
I did lot of Advanced MS Excel corporate training workshop in Delhi, Mumbai, Chennai, Bangalore, Hyderabad pan India and abroad. One day i was doing training program in one of my customer in Bhilwara one of my participants asked me one question related to Pivot Table and on spot i develop on formula i want […]