
lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostr navigation et dolore magna aliqua.


George Apostolov

John Doe

Mark Dinn

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/6929ff357dd0e157abed902e/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Configure your first trigger to begin the automation workflow.</li>
 <li>Select 'Microsoft Excel' as your data source application.</li>
 <li>Set up a trigger that activates when new spreadsheet data arrives.</li>
 <li>Connect your account to access your data sources.</li>
 <li>Connect to your specific spreadsheet for data monitoring.</li>
 <li>Customize data mapping fields for your integration.</li>
 <li>Click 'Test trigger' to move to the next step in your Excel-AppSheet integration.</li>
 <li>Select 'AppSheet' as your destination for Excel data.</li>
 <li>Specify what action AppSheet should take with your Excel data.</li>
 <li>Continue setting up the data mapping between systems.</li>
 <li>Click 'Test step' to test your automation to ensure data flows correctly.</li>
 <li>Click 'Publish' to activate your Zap.</li>
</ol>

Excel AppSheet Integration

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a00de243f01ed60a4e787/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the chart you wish to edit.</li>
 <li>Go to the top menu bar afterwards, then tap 'Chart Design'.</li>
 <li>Following that, browse the Chart Style menu and then select your preferred option.</li>
 <li>After completing these steps, the selected chart style will be added to your Microsoft Excel diagram.</li>
</ol>

How to Add a Chart Style to the Microsoft Excel Diagram

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a00e8243f01ed60a4e812/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and double-click the cell where you wish to add the checkmark.</li>
 <li>After that, head over to the top navigation bar and click 'Insert'.</li>
 <li>Choose 'Symbol' from the available options.</li>
 <li>Subsequently, select your preferred checkmark symbol under Bullets &amp; Stars.</li>
 <li>After completing these steps, a checkmark will be added to the selected cell in your Microsoft Excel worksheet.</li>
</ol>

How to Add a Checkmark in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a00ef243f01ed60a4e894/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Click on the lettered header of the column to the right of where you want the new column to appear.</li>
 <li>Right-click on the selected column header, then click Insert from the context menu.</li>
 <li>A new column will be added to the left of the selected column.</li>
</ol>

How to Add a Column in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a0112243f01ed60a4ebde/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, head over to the top menu bar and click the 'Add-Ins' option under the Home tab.</li>
 <li>After that, click the search bar and type 'Data Analysis Tool Pack'.</li>
 <li>Choose one from the suggested results and then click the 'Add' button next to it.</li>
 <li>After completing these steps, the selected data analysis tool pack will be added to your Microsoft Excel program.</li>
</ol>

How to Add a Data Analysis Tool Pack in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a0116243f01ed60a4ec32/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li><article>Inside your Microsoft Excel worksheet, find and select the cell where you want to add the date picker calendar.</article></li>
 <li>After that, go to the top menu bar and click the 'Number Format' menu under the Home tab.</li>
 <li>Choose 'Short Date' or 'Long Date' from the list of options.</li>
 <li>After completing these steps, the date picker calendar will be automatically added to the selected cell. Simply click the cell twice to bring out the date picker.</li>
</ol>

How to Add a Date Picker Calendar to Cells in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a012d243f01ed60a4ee38/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Go to the Insert tab in the ribbon and click Header &amp; Footer in the Text group.</li>
 <li>Scroll down to the bottom of the worksheet to access the footer area.</li>
 <li>Click in the footer area and type the desired text.</li>
 <li>Customize the footer by adding text, page numbers, or other details, then click outside the footer area to save changes.</li>
</ol>

How to Add a Footer in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a0140243f01ed60a4efc4/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li><article>Inside your Microsoft Excel worksheet, navigate to the top menu bar and click 'Insert'.</article></li>
 <li>Find and choose 'Header &amp; Footer' from the given options.</li>
 <li>Following that, tap the 'Add Header' field and type the word or phrase you wish to use.</li>
 <li>Subsequently, click anywhere around the worksheet to save the changes.</li>
 <li><article>After completing these steps, the header will be added to your Microsoft Excel file.</article></li>
</ol>

How to Add a Header in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a015d243f01ed60a4f22d/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select the cell where you wish to add a new line.</li>
 <li>After that, double-click on the selection and then press the following key combinations: (Mac) 'Option+Command+Return' or (Windows) 'Alt+Enter'.</li>
 <li>Finally, a new line will be added within the selected cell.</li>
</ol>

How to Add a New Line Within the Cell in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a018c243f01ed60a4f5a0/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file you want to edit and select the number of rows where you want to insert new ones. For example, to insert 10 rows, highlight 10 existing rows or cells.</li>
 <li>Right-click on any highlighted number.</li>
 <li>Click on "Insert."</li>
 <li>Now the 10 rows have been inserted.</li>
</ol>

How to Add a Row in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a019e243f01ed60a4f6fe/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, navigate to the top menu bar and then click 'Insert'.</li>
 <li>Choose 'Signature Line' from the available options under the Text section.</li>
 <li>One by one, provide the necessary details, such as the Signer's Name, Designation, and Email Address. Additionally, you can also include a short instructions if you wish to.</li>
 <li>Once done, tap 'OK' to proceed.</li>
 <li>After completing these steps, the signature line will be added to your Microsoft Excel worksheet.</li>
</ol>

How to Add a Signature Line in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a01c1243f01ed60a4f9ac/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>While your Microsoft Excel worksheet is currently in use, head over to the menu bar and then click 'File'.</li>
 <li>Select 'Properties' from the list of options.</li>
 <li>After that, tap the 'Summary' tab to proceed.</li>
 <li>Come up with a unique title for your Microsoft Excel document and then enter it into the 'Title' input field.</li>
 <li>Finally, click 'OK' to apply the changes and add the provided title to your worksheet.</li>
</ol>

How to Add a Title in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a01e4243f01ed60a4fc20/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Insert'.</li>
 <li>Select 'Header &amp; Footer' from the available options.</li>
 <li>After that, tap the 'Add Header tab'.</li>
 <li>Next, choose the 'Picture' option and then select the image file you wish to use as a watermark.</li>
 <li>Click anywhere around the worksheet to apply the changes.</li>
 <li>After completing these steps, the watermark will be added to your MS Excel document.</li>
</ol>

How to Add a Watermark in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a0240243f01ed60a5033a/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Click on the chart.</li>
 <li>In the upper-right corner of the chart, click the Chart Elements button (a plus sign icon).</li>
 <li>Check the Axis Titles box.</li>
 <li>Click the axis title placeholders and enter text like "Sales" for Y-axis and "Months" for X-axis.</li>
 <li>Select the axis titles and use the Home tab to adjust font size, style, and color as needed.</li>
</ol>

How to Add Axis Labels Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2ca7a98365d08656fffa/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Highlight the cell(s) or range of cells where you want to add borders.</li>
 <li>Go to the Home tab, locate the Font group, click the Borders icon.</li>
 <li>Choose your desired border style (e.g., All Borders, Outside Borders, or Thick Borders).</li>
 <li>Now you have the borders added, you can customize them further to suit your needs.</li>
</ol>

How to Add Border in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2d4b57f8f6cdddddd5d5/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Type any date on your excel cell.</li>
 <li>Drop down the cell and it will be auto arranged.</li>
 <li>If the dates don't auto-arrange, click AutoFill Options and select Fill Series or your desired format.</li>
 <li>If you want to change the date format, right-click the cell and select Format Cells.</li>
 <li>Select your desired date format, then click OK.</li>
 <li>Drag down to autofill, and the date format will update automatically.</li>
</ol>

How to Add Dates in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2d96d673bd5aa8e5f436/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Click on the cell where you want the drop-down list.</li>
 <li>Click on the "Data" tab and select "Data Validation"</li>
 <li>In the dialog box, under Allow, choose "List."</li>
 <li>Add Your List Items under source.</li>
 <li>Select cells in Excel that already contain your list.</li>
 <li>Once added click on "OK."</li>
 <li>Your drop-down list will appear in the selected cell.</li>
</ol>

How to add drop down list in microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2db0d673bd5aa8e5f5b3/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select the chart for which you want to add an error bar.</li>
 <li>Select "Add Chart Element" on the Excel ribbon.</li>
 <li>Select "Error Bars" and choose the type of error bars you prefer.</li>
 <li>Click on the error bar to select it, then customize it as needed.</li>
</ol>

How To Add Error Bars In Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2dced673bd5aa8e5f91d/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file you wish to edit on MS Excel.</li>
 <li>Open the file you wish to edit on MS Excel.</li>
 <li>Click the bottom-right corner of the cell and drag it to the range where you want to copy the formula.</li>
 <li>Release the mouse, and the cells will automatically fill based on the formula you copied.</li>
</ol>

How to add formula for whole column microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2df3d673bd5aa8e5fbff/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li><article>Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'View'.</article></li>
 <li>Find 'Gridlines' from the available options and then tick the checkbox beside it.</li>
 <li>After completing these steps, the gridlines will be added instantly to your Microsoft Excel worksheet.</li>
</ol>

How to Add Gridlines in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2e62d673bd5aa8e604bb/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select row 9 (one row below where you want the new rows).</li>
 <li>Drag the selection three rows down (you can check the count in the small window).</li>
 <li>Right-click and select "Insert" to add the rows.</li>
 <li>Three rows will be inserted below row 8.</li>
</ol>

How to Add Multiple Rows Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2e9ad673bd5aa8e608f4/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the Excel file where you want to insert the picture.</li>
 <li>At the top of the Excel, locate and click on the "Insert" tab and select "Shapes".</li>
 <li>While holding the triangle shape, hold down the "Alt" key.</li>
 <li>Go to "Format" and select "Shape Fill" then click "Picture."</li>
 <li>After selecting "Pictures", choose "From a file."</li>
 <li>Browse your files, select the picture you want to insert, and click "Insert."</li>
 <li>Click and drag the corners of the image to resize it proportionally.</li>
</ol>

How to add picture in ms excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2f0ad673bd5aa8e61306/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, locate and select the cell that contains the formula you wish to edit.</li>
 <li>After that, head over to the ribbon section and click the formula bar.</li>
 <li>Place the text selection cursor right after the Equals (=) sign and then start typing the text you wish to add. Enclose it in a pair of quotation marks.</li>
 <li>Subsequently, enter an 'Ampersand' symbol between the closing quotation mark and the Sum function. Once done, press the 'Enter' or the 'Return' key to run the formula.</li>
 <li>After completing these steps, the text will be added to the selected formula in your Microsoft Excel worksheet.</li>
</ol>

How to Add Text to a Formula in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2f20d673bd5aa8e6147a/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select a cell and then type an 'Equals' (=) sign to proceed with the computation.</li>
 <li>Following that, select the cell that contains the time you wish to add and then type a 'Plus' (+) sign.</li>
 <li>Type 'Time' afterwards, then enter the specific number of hours, minutes, and seconds you wish to add. Follow this format to make sure that the formula is correct: (HH,MM,SS).</li>
 <li>Once done, click anywhere around the worksheet to apply the changes and run the formula.</li>
 <li>After completing these steps, the results will be displayed on the selected cell. It will show the exact time after adding the specified number of hours, minutes, and seconds to the selected time data.</li>
</ol>

How to Add Time in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2f29d673bd5aa8e61511/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file you want to edit.</li>
 <li>Select the chart that you want to add a trendline. </li>
 <li>Click on the "+" icon located at the top of the selected chart to proceed.</li>
 <li>Choose "Trendline," and select the type of trendline you want to use.</li>
</ol>

How to add trendline in microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2f59d673bd5aa8e61954/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the column you wish to edit.</li>
 <li>Following that, grab the resize handle at the top-right corner of the selected column and drag it until you achieve your desired column width.</li>
 <li>After completing these steps, the width of the selected column will be adjusted based on your preference.</li>
</ol>

How to Adjust the Column Width in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2f86d673bd5aa8e61d14/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Highlight the column or range of cells containing the names you want to sort.</li>
 <li>In the Home tab, go to Editing section and click Sort &amp; Filter.</li>
 <li>In the Sort &amp; Filter group, click Sort A to Z (for ascending alphabetical order).</li>
</ol>

How to Arrange Names in Alphabetical Order in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2f9cd673bd5aa8e61f16/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select the whole sheet by clicking the triangle in the top left corner.</li>
 <li>Move your mouse between columns A and B until the cursor changes to a two-sided arrow.</li>
 <li>Double-click the boundary, and the column width will adjust to fit the content.</li>
</ol>

How to Autofit in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2fb7d673bd5aa8e62444/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Navigate to Formulas in the Excel Options menu.</li>
 <li>Click Calculate Options.</li>
 <li>Ensure Automatic is selected. Click OK.</li>
</ol>

How to Automatically Calculate Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2fb9d673bd5aa8e62456/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select the cell where you want the row numbering to begin.</li>
 <li>In the first cell (e.g., A1), type the formula: =ROW().</li>
 <li>Drag it down to automatically fill the row numbers in each subsequent cell.</li>
 <li>Now that you've created numbered rows, you can adjust and customize them as needed.</li>
</ol>

How to Automatically Number Rows in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3001d673bd5aa8e6291b/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the cells that go along the lines you wish to bold.</li>
 <li>After that, head over to the top menu bar and then click the 'Borders' option under the Home tab.</li>
 <li>Choose 'More Border Styles' from the list of options.</li>
 <li>Under the Border Style section, find and click the 'Thick Line' option.</li>
 <li>Subsequently, choose the specific border you prefer to use.</li>
 <li>After completing these steps, the lines of the selected cells will appear in bold. </li>
</ol>

How to Bold Lines in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3050d673bd5aa8e62ee9/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file you wish to edit.</li>
 <li>In the cell under 'Bonus', type the formula <code>=VLOOKUP(B2,$G$3:$H$24,2,FALSE)</code>, as shown in the example, where the cells contain the positions of the different employees.</li>
 <li>Go to the Excel ribbon, click on ''Number,'' and then select the ''%'' format.</li>
 <li>Under ''Total'', type the formula <code>=C2*(D2=1)</code>As per the example provided, the calculation is based on the values in columns C and D.</li>
 <li>Highlight both the cells under the ''Bonus'' and ''Total'' columns to apply the formula to the remaining cells below.</li>
</ol>

How to calculate bonus in ms excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3053d673bd5aa8e62f42/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li><article>Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Formulas'.</article></li>
 <li>Select 'More Functions' from the available options.</li>
 <li>Subsequently, hover your mouse cursor over the 'Statistical' option and then click 'VAR.S'.</li>
 <li>Tap the 'Number1' input field and then enter the cell range that contains the data you wish to calculate.</li>
 <li>Once done, tap 'Insert' to proceed.</li>
 <li>After completing these steps, the sample variance of the selected dataset will be calculated based on your input.</li>
</ol>

How to Calculate Sample Variance in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3055d673bd5aa8e62f6f/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file in MS Excel and click on the cell where you’d like the answer to display.</li>
 <li>Type "=STDEV" and select the type of standard deviation you wish to use.</li>
 <li>Add an open parenthesis, select the cells you want to include in the calculation, and then close the parenthesis.</li>
</ol>

How to calculate standard deviation in microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3056d673bd5aa8e62f83/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open your Excel spreadsheet where you want to calculate the total.</li>
 <li>Click on the cell where you want the sum.</li>
 <li>Look for the AutoSum (Σ) button in the ribbon.</li>
 <li>Press Enter, and the sum will appear in the cell.</li>
</ol>

How to calculate sum in ms excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3059d673bd5aa8e62fba/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select a cell and then type an 'Equals' (=) sign.</li>
 <li>Following that, type 'Trunc' and then select it from the suggested results.</li>
 <li>Add the Yearfrac function next. Simply input 'Yearfrac' and choose it from the recommended matches.</li>
 <li>After that, select the cell that contains the birthdate data and then insert a 'Comma' (,).</li>
 <li>Type 'Today' and select it from the suggested results. End the first part of the formula with a closing parenthesis.</li>
 <li>Proceed further by inserting a 'Comma' (,) and selecting '1 Actual/Actual' from the given options.</li>
 <li>Once done, add two closing parentheses and then hit the 'Enter' or 'Return' key to finally process the results.</li>
 <li><article>After completing these steps, the age will be calculated based on the selected data in your Microsoft Excel worksheet.</article></li>
</ol>

How to Calculate the Age in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a305ad673bd5aa8e62fd2/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find the column containing the numbers you want to compute the average and then select the cell right below the last input.</li>
 <li>Following that, head over to the top navigation bar and then click 'Formulas'.</li>
 <li>Choose 'AutoSum' from the available options.</li>
 <li>Tap 'Average' afterwards.</li>
 <li>After completing these steps, the average of the number values above the selected cell will be calculated instantly.</li>
</ol>

How to Calculate the Average in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a305bd673bd5aa8e62fe7/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select the cell where you wish to run the mean calculations, and then type an 'Equals' (=) sign to get started.</li>
 <li>After that, input 'Average' and then select it from the suggested results.</li>
 <li>Enter the cell range that contains the values you want to calculate and then add a closing parenthesis at the end of the formula.</li>
 <li>Once done, click anywhere around the worksheet to finally process the result.</li>
 <li>After completing these steps, the mean of the selected dataset will be calculated and displayed instantly.</li>
</ol>

How to Calculate the Mean in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a305ed673bd5aa8e63012/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Click the cell where you want the total to appear.</li>
 <li>Go to the Home tab.</li>
 <li>Click AutoSum in the Editing group.</li>
 <li>Excel will automatically select a range; adjust it if needed and press Enter.</li>
</ol>

How to Calculate Total in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30a0d673bd5aa8e635a3/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Go to the Page Layout tab in the ribbon.</li>
 <li>Select Margins.</li>
 <li>Click Custom Margins.</li>
 <li>Under Center on Page, check the box for Horizontally.</li>
 <li>Click OK to center the worksheet horizontally.</li>
</ol>

How to Center Worksheet Horizontally in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30acd673bd5aa8e63686/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select the chart you want to customize (click on the chart or press Ctrl + A).</li>
 <li>Click the plus sign and select "Axis", then "Primary Horizontal" to open the Format Axis pane.</li>
 <li>In the Format Axis pane, go to the "Axis Options" tab to adjust the X-axis settings.</li>
 <li>Choose "Text Axis" or "Date Axis" based on your data type.</li>
 <li>Click "Close" to apply the changes.</li>
</ol>

How to Change Axis Values Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30b4d673bd5aa8e636ff/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Press Ctrl + A or click the square between the column and row headers to select all cells.</li>
 <li>In the ribbon, click the Home tab and locate the Font group.</li>
 <li>Click the Fill Color icon and select a color from the palette or choose More Colors for additional options.</li>
</ol>

How to Change Background Color in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30c4d673bd5aa8e6388a/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file you wish to edit on MS Excel. </li>
 <li>Select a cell and type in "=UPPER"</li>
 <li>Add an open parenthesis, click on the desired cell, and then close the parenthesis.</li>
 <li>Press Enter, then drag the fill handle (the small square at the bottom-right corner of the cell) to the cells where you want the same function applied.</li>
 <li>You can follow the same steps to convert to lowercase or proper case if needed.</li>
</ol>

How to change case in microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30cdd673bd5aa8e638c1/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select your data by clicking the first cell, then press Ctrl + Shift + Right Arrow and Ctrl + Shift + Down Arrow.</li>
 <li>Go to the Home tab, click on Conditional Formatting, and select Manage Rules.</li>
 <li>Click New Rule, then click OK.</li>
 <li>Choose Format only cells that contain.</li>
 <li>Set the rule to format cells with values greater than or equal to your sales target (e.g., 5000).</li>
 <li>Click the Format button, go to the Fill tab, and choose a color for the background (e.g., green).</li>
 <li>Click Apply and OK to highlight cells above the target in green. Changing the sales target (e.g., to 7500) will automatically update the formatting.</li>
</ol>

How to Change Cell Color Based on Value Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30dbd673bd5aa8e63997/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Highlight the cells containing the numbers you want to format as currency.</li>
 <li>In the Home tab, locate the Number section, click the Number Format dropdown.</li>
 <li>Go to Currency section and choose a Symbol.</li>
 <li>Once done, click OK.</li>
 <li>The selected cells will now display numbers formatted as currency using your system's default currency symbol.</li>
</ol>

How to Change Currency in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30e3d673bd5aa8e63a3c/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Highlight the cells containing the dates you want to format.</li>
 <li></li>
 <li>Change the Locale to 'United Kingdom' to apply the European date format (day-month-year).</li>
 <li>Choose the most suitable date format, then click on OK.</li>
 <li>The dates in your selected cells will update automatically.</li>
</ol>

How to Change Date Format in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3126d673bd5aa8e64036/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select Options at the bottom of the list to open the Excel Options window.</li>
 <li>In the Excel Options window, click on Language from the left sidebar, then select Add a Language.</li>
 <li>Select the language and click Add.</li>
 <li>After making changes, click OK and restart Excel for the changes to take effect.</li>
</ol>

How to Change Language in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3214ab56e05a00fd595e/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Launch Microsoft Excel and open the worksheet where you want to change the orientation.</li>
 <li>Go to the Page Layout tab in the ribbon, and in the Page Setup group, click the Orientation dropdown.</li>
 <li>Choose Landscape from the dropdown to change the page orientation.</li>
</ol>

How to Change Orientation to Landscape Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3232ab56e05a00fd5cb0/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file you want to edit.</li>
 <li>Click on the cell where you want the changes to be applied, type an equals sign followed by the word 'LOWER', and then select the cell of choice. For example, <code>=LOWER(A3)</code>.</li>
 <li>Click the bottom corner of the cell and drag to highlight the rest of the names or words you wish to modify.</li>
 <li>As you can see the names are now all in lower case.</li>
</ol>

How to change text case in ms excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3243ab56e05a00fd5df8/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the chart containing the data series you wish to rename.</li>
 <li>After that, head over to the top navigation bar and tap 'Chart'.</li>
 <li>Choose 'Select Data' from the available options.</li>
 <li>Next, navigate to the Chart Editor panel and select the field that contains the data series you want to customize.</li>
 <li>Tap the 'Edit Title' icon afterwards.</li>
 <li>Subsequently, enter the new data series name into the provided input field and then click the 'Done' icon to apply the changes</li>
 <li>After completing these steps, the name of the selected data series will be changed accordingly.</li>
</ol>

How to Change the Data Series Name in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a324fab56e05a00fd5ea5/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the cells that contain the text you wish to change the font size.</li>
 <li>After that, navigate to the top menu bar and then click the 'Font Size' menu under the Home tab.</li>
 <li>Choose the new font size you wish to use.</li>
 <li>After completing these steps, the font size of the selected text will be changed according to your input.</li>
</ol>

How to Change the Font Size in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a325fab56e05a00fd5fca/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the chart you wish to edit.</li>
 <li>After that, navigate to the top menu bar and click 'Chart'.</li>
 <li>Choose 'Select Data' from the available options.</li>
 <li>Next, tap the 'Format' tab to proceed further.</li>
 <li>Locate and select the data series represented by the legend you wish to edit.</li>
 <li>Subsequently, tap the 'Series Name' field and replace the default name with a new one. Do the same thing for other series.</li>
 <li>After completing these steps, the legend text of the selected chart will be changed based on your input.</li>
</ol>

How to Change the Legend Text of Microsoft Excel Charts

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a327aab56e05a00fd61e3/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select the chart you wish to edit.</li>
 <li>After that, head over to the top menu bar and click 'Chart'.</li>
 <li>Choose 'Select Data' from the available options.</li>
 <li>Next, click the 'Format' tab to access the chart settings related to the y-axis values.</li>
 <li>Select 'Vertical Axis' from the list of options.</li>
 <li>From there, you can now change the y-axis values of the selected chart. To edit the data range, navigate to the Bounds section and change the default Minimum and Maximum values.</li>
 <li>Next, change the default value of Major Units under the Units section to edit the data interval.</li>
 <li>After completing these steps, the y-axis values of the selected chart will be changed based on your input.</li>
</ol>

How to Change the Y-Axis Values in Microsoft Excel Charts

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a32b4ab56e05a00fd6650/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Go to the Review tab in the ribbon and click Spelling, or simply press F7 on your keyboard.</li>
 <li>Excel highlights misspelled words one by one; choose a suggested correction or skip as needed.</li>
 <li>Once Excel has finished checking, it will display a message confirming the spell check is complete.</li>
</ol>

How to Check Spelling in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a32cfab56e05a00fd6886/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the cells that contain the format you wish to remove.</li>
 <li>After that, head over to the top menu bar and click the 'Clear' option under the Home tab.</li>
 <li>Select 'Clear Formats' from the list of options.</li>
 <li>After completing these steps, the format of the selected cells will be cleared and reverted to the original.</li>
</ol>

How to Clear Cell Formatting in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a32d2ab56e05a00fd68bb/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open Excel and go to File.</li>
 <li>Select Options.</li>
 <li>Select Save from the sidebar.</li>
 <li>Scroll to Cache Settings, click Delete Cache Files, optionally enable Delete files when closed, and adjust the cache duration as needed.</li>
</ol>

How to Clear MS Excel Cache

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3300ab56e05a00fd6dcb/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the rows you want to edit.</li>
 <li>After that, go to the top menu bar and select 'Format As Table' from the available options under the Home tab.</li>
 <li>Browse the format selections and choose one that perfectly alternates the row color.</li>
 <li>Subsequently, tap 'OK' to confirm your request.</li>
 <li>After completing these steps, the color the selected rows will be alternated based on your chosen format.</li>
</ol>

How to Color Every Other Row in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3302ab56e05a00fd6e30/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, locate and select the cells you wish to combine.</li>
 <li>After that, head over to the top menu bar and click 'Merge'.</li>
 <li>Finally, the selected cells will be combined into one.</li>
</ol>

How to Combine Cells in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3305ab56e05a00fd6e6a/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select the cell where you wish to combine the data and then type an 'Equals' (=) sign.</li>
 <li>After that, type the cell reference of the first data and insert an 'Ampersand' (&amp;) sign next to it.</li>
 <li>Subsequently, type the cell reference of the second data.</li>
 <li>Once done, click anywhere around the worksheet to run and apply the formula.</li>
 <li>After completing these steps, the data from the two selected cells will be combined into one.</li>
</ol>

How to Combine Microsoft Excel Data From Two Cells Into One

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3306ab56e05a00fd6e87/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select the files which you want to combine.</li>
 <li>Click "Date," and then select "Get Data."</li>
 <li>Choose "From File," and hit "From Excel Workbook."</li>
 <li>Select the specific file you would like to merge with the current one and press "Import."</li>
 <li>Choose the workbook sheet and then press "Transform Data."</li>
 <li>Then click the "Close and Load" button.</li>
 <li>You have now combined the two files in one.</li>
</ol>

How to combine microsoft excel spreadshe… | Dec 22 5:49 PM

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3313ab56e05a00fd7019/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the two columns you wish to compare.</li>
 <li>After that, select 'Conditional Formatting' from the available options under the Home tab.</li>
 <li>Hover your mouse cursor over the 'Highlight Cell Rules' and then choose 'Duplicate Values'.</li>
 <li>Following that, click the drop-down menu right below the 'Highlight Cells With' section and choose your preferred condition.</li>
 <li>Go over the provided options for 'Format Style' and choose one that suits your liking.</li>
 <li>Subsequently, tap 'Done' to proceed.</li>
 <li>After completing these steps, the cells will be highlighted based on your input. You can use them as your guide while comparing the two selected columns.</li>
</ol>

How to Compare Two Columns in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3322ab56e05a00fd71a2/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>On Microsoft Excel's main dashboard, find and open the existing file you wish to use.</li>
 <li>After that, go to the top menu bar and then click 'Insert'.</li>
 <li>Select 'Forms' from the available options.</li>
 <li>Subsequently, click 'New Form'.</li>
 <li>After completing these steps, the existing Excel form from your library will be connected to a new Microsoft Form. Simply tap 'Open Form' to access it and make your desired customizations.</li>
</ol>

How to Connect a Microsoft Form to an Existing Excel File

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3325ab56e05a00fd71e6/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Data'.</li>
 <li>Subsequently, tap 'Get Data (Power Query)'.</li>
 <li>Choose 'SharePoint Online List' from the available options.</li>
 <li>Finally, provide the site URL of the SharePoint list you wish to integrate. Once done, tap 'Sign In' to log into your Microsoft account and enable the connection.</li>
</ol>

How to Connect a SharePoint List to Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a341bab56e05a00fd88d6/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside the main dashboard of your Microsoft Forms, go to the top-right corner and click 'View Responses'.</li>
 <li>After that, click 'Open Results in Excel'.</li>
 <li>Tap 'Continue' to proceed.</li>
 <li>After completing these steps, the responses collected from your Microsoft Forms will be connected to a new Excel Online worksheet.</li>
</ol>

How to Connect Microsoft Forms Responses to Excel Online

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a341dab56e05a00fd8901/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside the main dashboard of Power Automate, navigate to the left-side panel and click 'Create'.</li>
 <li>Select 'Automated Cloud Flow' from the available options.</li>
 <li>After that, come up with a unique Flow Name and enter it into the provided input field.</li>
 <li>Next, search for 'Forms' and then choose the corresponding Trigger you prefer to use.</li>
 <li>Once done, tap 'Create' to proceed.</li>
 <li>Click the 'Trigger' tab afterwards to set up the parameters properly.</li>
 <li>Subsequently, click the 'Form ID' and choose the Microsoft form you prefer to use.</li>
 <li>Following that, click the 'Add' icon to configure the Action.</li>
 <li>Choose 'Excel Online' from the given options.</li>
 <li>Next, select the Action you wish to use.</li>
 <li>One by one, configure the parameters according to your liking. Simply provide your preferred Location, Document Library, File, and Name.</li>
 <li>Once done, tap 'Save' to save and activate your customized flow.</li>
 <li>After completing these steps, your Microsoft Forms will be integrated instantly with Microsoft Excel.</li>
</ol>

How to Connect Microsoft Forms to Excel Using Power Automate

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3447ab56e05a00fd8d29/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>On Power BI's main dashboard, head over to the left-side panel and click 'Create'.</li>
 <li>Choose 'Excel' from the list of options.</li>
 <li>After that, enter the file path of your SharePoint Excel file into the provided input field.</li>
 <li>Subsequently, configure the Connection Credentials based on your preferences.</li>
 <li>Finally, tap 'Next' to enable the connection and use the selected SharePoint Excel file as the data source for your Power BI's report output.</li>
</ol>

How to Connect Power BI to a SharePoint Excel File

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35acab56e05a00fda183/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Highlight the column(s) you want to convert to rows.</li>
 <li>Right-click and select Copy, or press <code>Ctrl + C</code>.</li>
 <li>Click on the cell where you want to paste the data as rows, right-click, and under Paste Options, select the Transpose icon (a clipboard with a rotating arrow).</li>
 <li>Your column data will now be converted to rows!</li>
</ol>

How to Convert Columns to Rows in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35acab56e05a00fda1c1/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Click 'External Data' on the ribbon.</li>
 <li>Select 'New Data Source'.</li>
 <li>Click 'From File' and select 'Excel'.</li>
 <li>Browse for the Excel file you want to import and click 'Browse'.</li>
 <li>Choose how to store the data. </li>
 <li>Click 'OK'.</li>
 <li>Select the sheet or range that contains the data.</li>
 <li>Click 'Next'.</li>
 <li>Review and adjust the fields such as set data types and rename columns.</li>
 <li>Click 'Next'.</li>
 <li>Select a primary key.</li>
 <li>Click 'Next' to proceed.</li>
 <li>Provide a name for the imported table.</li>
 <li>Review the summary and click 'Finish'. </li>
 <li>Open the new table in Access to ensure the data is correctly imported.</li>
</ol>

How to Convert Excel to Microsoft Access

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35b5ab56e05a00fda272/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Go to Microsoft 365 and scroll down to find the prebuilt macro function provided by Microsoft.</li>
 <li>Copy the code to your clipboard for later use.</li>
 <li>Go to your Excel and click File.</li>
 <li>Go to the Option tab.</li>
 <li>Go to Customize Ribbon, check Developer, and click OK.</li>
 <li></li>
 <li>In the VBA editor, click Insert &gt; Module to open a blank code window.</li>
 <li>Paste the copied code into the VBA editor, press Ctrl + S to save, and close the editor.</li>
 <li>In a blank cell, type: <code>=NumberText(A2)</code> (replace A2 with the cell holding the number), and then Enter.</li>
 <li>Now, numbers in the selected cells will be converted to their word equivalents.</li>
 <li>Drag the formula down or across the cells to apply it, converting numbers to text in each selected cell.</li>
</ol>

How to Convert Numbers into Words in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35b8ab56e05a00fda2b6/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select the cell that contains the true and false values you wish to edit.</li>
 <li>After that, head over to the ribbon section and click the formula bar.</li>
 <li>Enclose the formula in parentheses as shown in the example: (N3&gt;5000).</li>
 <li>Subsequently, add two dash lines (-) next to the equals sign. Follow this format: '=--(N3&gt;5000)'. Once done, press the enter key to run the newly revised formula.</li>
 <li>After completing these steps, the true and false values from the selected cells will be converted to 1 or 0.</li>
</ol>

How to Convert the True and False Values to 1 and 0 in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35cdab56e05a00fda4c5/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li><article>Inside your Microsoft Excel worksheet, find and select the cell that contains the content you wish to copy and paste.</article></li>
 <li>Right-click on the selection afterwards, then tap 'Copy'.</li>
 <li>Subsequently, right-click on the cell where you wish to paste the copied content.</li>
 <li>Tap 'Paste' to proceed.</li>
 <li>After completing these easy steps, the selected cell content will be copied and pasted to another cell or worksheet.</li>
</ol>

How to Copy and Paste Cell Content in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35d5ab56e05a00fda545/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file you want to edit on MS Excel.</li>
 <li>Highlight the cells you wish to copy.</li>
 <li>On the Excel ribbon click on "Format Painter."</li>
 <li>Select the cells where you want to apply the formatting.</li>
 <li>Edit the cell sizes desired.</li>
</ol>

How to copy conditional formatting microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35dbab56e05a00fda5c1/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select the cell with the formula (e.g., G3), then hover over its bottom-right corner until the cursor becomes a plus sign.</li>
 <li>Click, hold, and drag the cursor down through the rows where you want to copy the formula, then release the mouse button.</li>
 <li>Alternatively, you can double-click the left mouse button.</li>
 <li>Excel will automatically fill the formula down the column to match the adjacent data in the neighboring column.</li>
</ol>

How to Copy Formulas Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35f0ab56e05a00fda749/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select the cells containing colors, including the header row.</li>
 <li>Go to the Home tab.</li>
 <li>Click Sort &amp; Filter, and choose Filter.</li>
 <li>Click the filter dropdown, choose Filter by Color, and select your desired color.</li>
 <li>The bottom-left corner of Excel will display the count of visible cells.</li>
</ol>

How to Count Cells by Color in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35f2ab56e05a00fda764/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select the cell you wish to use and then type an 'Equals' (=) sign.</li>
 <li>After that, type 'Countif' and then select it from the suggested results.</li>
 <li>Enter the cell range containing the text values you wish to count.</li>
 <li>Subsequently, input a 'Comma' (,) to add conditions.</li>
 <li>Enter an 'Asterisk' (*) sign enclosed in quotation marks to specify that you're counting cells with text values.</li>
 <li>Once done, add a closing parenthesis and then tap 'Enter' or 'Return' to run the formula.</li>
 <li>After completing these steps, the number of cells with text values from the selected range will be displayed for viewing.</li>
</ol>

How to Count Cells with Text Values in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35f4ab56e05a00fda792/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select the cell where you intend to show the formula and then type an 'Equals' (=) sign.</li>
 <li>Type 'Len' afterwards, then select it from the suggested results.</li>
 <li>Subsequently, add the TRIM function. Simply type 'TRIM' and choose it from the suggested results.</li>
 <li>Select the cell containing the text you wish to count.</li>
 <li>Following that, end the first part of the formula with two closing parentheses.</li>
 <li>Type a 'Minus' (-) sign afterwards to proceed further.</li>
 <li>Enter another LEN function into your formula. Once again, type 'LEN' and select it from the suggested results.</li>
 <li>After that, add the Substitute function by simply typing 'Substitute' and choosing it from the suggested results.</li>
 <li>Once again, select the cell that contains the text you wish to count and type a 'Comma' (,).</li>
 <li>Add two 'Quotation Marks' with one space in between (" ") to denote a single space. Subsequently, enter a 'Comma' (,) one more time.</li>
 <li>Following that, add another pair of quotation marks. However, delete the spaces in between ("") to indicate that you're excluding the spaces from the word count. End the formula with two closing parentheses and insert '+1' at the very end.</li>
 <li>Once done, tap anywhere around your worksheet to run the formula and process the result.</li>
 <li>After completing these steps, the text from the selected cell will be counted accordingly.</li>
</ol>

How to Count the Words in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3601ab56e05a00fda859/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Highlight the range of cells containing your data, including the labels (e.g., A1:B4).</li>
 <li>Click on the "Insert" tab in the ribbon at the top, then select Bar Chart (it may also appear as "Column or Bar Chart").</li>
 <li>From the dropdown, select your preferred bar chart style.</li>
 <li>To switch the chart type, select the chart, go to the Chart Design tab, and click Change Chart Type on the right.</li>
 <li>Select the bar chart option, hover to preview it, and click OK to insert the chart.</li>
 <li>Now you can customize your bar chart as needed.</li>
</ol>

How to Create a Bar Chart in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a365eab56e05a00fdaf16/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the cells containing the dataset you wish to use.</li>
 <li>After that, go to the top navigation bar and click 'Insert'.</li>
 <li>Click the 'Insert Chart' menu to view the available selections.</li>
 <li>Following that, browse the provided options and select the chart you prefer to use.</li>
 <li>Head back to the top menu bar afterwards, then tap 'Chart'.</li>
 <li>Choose 'Select Data' from the provided options.</li>
 <li>Next, click the 'Data' tab if you wish to make a few adjustments related to the selected dataset. For instance, you can change the source or set up the y-axis and the x-axis.</li>
 <li>On the one hand, tap the 'Format' tab if you wish to change the technical formatting of the Chart Title, Legend, Horizontal Axis, Vertical Axis, and Series.</li>
 <li>After completing these steps, a chart will be created based on your input and preferred design.</li>
</ol>

How to Create a Chart in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3673ab56e05a00fdb1b5/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Navigate to your Confluence space and click "Create" to start a new page where your Excel data will live.</li>
 <li>Enter the title of your page.</li>
 <li>Simply drag and drop your Excel file onto the page, or copy your spreadsheet data and use the "/table" command to create a formatted Confluence table.</li>
 <li>Reuse by copying the page manually, or ask a space admin to publish it as a custom template.</li>
</ol>

How To Create A Confluence Template Based On Excel Spreadsheet

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a368fab56e05a00fdb54b/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, select the cell where you wish to run the custom formula.</li>
 <li>After that, type an 'Equals' (=) sign to indicate that your succeeding input is a formula.</li>
 <li>Type the name of the function you wish to use and then select it from the suggested results.</li>
 <li>Next, enter the cell reference or cell range and then end the formula with a closing parenthesis.</li>
 <li>Input an operator or separator if you want to add another condition.</li>
 <li>Subsequently, type the name of the function and then select it from the recommended matches.</li>
 <li>Add the cell range or cell reference you wish to use as the argument.</li>
 <li>Once done, insert a closing parenthesis to end the formula. If you want to add more condition, simply repeat the same series of steps.</li>
 <li>Finally, press the 'Enter' or 'Return' key to run the newly created formula and view the results.</li>
</ol>

How to Create a Custom Formula in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3711ab56e05a00fdc4a0/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the cells that contain the data you wish to use.</li>
 <li>Following that, navigate to the top menu bar and click 'Insert'.</li>
 <li>Tap the 'Insert Chart' menu to browse the chart collection.</li>
 <li>Subsequently, go to the Statistical section and select 'Histogram'.</li>
 <li>After completing these steps, a histogram chart will be created based on the selected data.</li>
</ol>

How to Create a Histogram Chart in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3750ab56e05a00fdca0b/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li><article>Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Developer'.</article></li>
 <li>Select 'Record Macro' from the available options.</li>
 <li>After that, provide all the required information based on your preferences. Add a unique Macro Name and Description. At the same time, specify the Storage and Shortcut Key you wish to use.</li>
 <li>Once done, tap 'OK' to proceed further.</li>
 <li>Start performing the specific action you wish to record as a macro.</li>
 <li>Finally, head back to the top menu bar and click 'Stop Recording'. At this point, the macro will be created and saved instantly.</li>
</ol>

How to Create a Macro in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3781ab56e05a00fdcf80/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Navigate to the top menu bar, then click the 'Insert' option under the Home tab.</li>
 <li>Following that, choose 'Insert Sheet' from the list of options.</li>
 <li>After completing these steps, a new worksheet will be created and added to your Microsoft Excel document.</li>
</ol>

How to Create a New Worksheet in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3794ab56e05a00fdd10b/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Go to the Insert tab and click the Pie Chart icon in the Charts group.</li>
 <li>Choose the type of pie chart you want (e.g., 2-D Pie, 3-D Pie, etc.).</li>
 <li>Right-click on the chart and select Add Data Labels.</li>
 <li>Customize the pie chart to suit your needs.</li>
</ol>

How to Create a Pie Chart in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3797ab56e05a00fdd134/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select the cells in your table or range.</li>
 <li>Click Insert, then select PivotTable or Recommended PivotTables.</li>
 <li>Decide where you want the PivotTable to appear, then click OK.</li>
 <li>Add the desired fields to your PivotTable.</li>
 <li>Drag fields to different areas to organize them as needed.</li>
 <li>Review your PivotTable and start analyzing your data efficiently!</li>
</ol>

How to Create a Pivot Table in MS Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a37bdab56e05a00fdd2e4/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open Power BI Desktop, click 'Black report'.</li>
 <li>Make sure to select 'Import data from Excel' as your data source.</li>
 <li>Browse and select your <code>.xlsx</code> file. Once done, click 'Open'.</li>
 <li>Power BI will show the list of tables/sheets in the file. Check the boxes for the ones you want to import.</li>
 <li>Click 'Load' to load your dataset from Excel.</li>
 <li>After loading, your Excel data is now part of your Power BI model.</li>
</ol>

How to Create a Power BI Report from Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a37fdab56e05a00fddb3e/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Organize your data in a table format with each column representing a different variable (e.g., Date, Sales, Employee Name).</li>
 <li>Select "Insert," and then click "Table."</li>
 <li>Bold the header row for emphasis and use Conditional Formatting to highlight specific data, such as sales over a certain threshold.</li>
 <li>Create a Pivot Table, select your data, go to "Insert" and click "Pivot Table," and drag fields into the Rows, Columns, Values, and Filters areas to organize and analyze the data.</li>
 <li>Use basic functions like =SUM() to add numbers or =AVERAGE() to find the average, and add more formulas as needed.</li>
 <li>Select your data, go to the "Insert," and choose a chart type (e.g., bar, line, or pie) to make your report visually appealing.</li>
 <li>Edit the report to make it detailed, organized, and visually appealing for clarity and impact.</li>
</ol>

How to create a report microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a382eab56e05a00fde092/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside the main dashboard of your SharePoint site, head over to the top navigation bar and click 'New'.</li>
 <li>Choose 'List' from the available options.</li>
 <li>After that, click 'From Excel'.</li>
 <li>Tap 'Upload File' and select the Excel Sheet you wish to use. Alternatively, you can scroll down to the section below it and choose an existing Excel file from your site library if there is any available.</li>
 <li>After that, choose the specific Table and Column you prefer to use. Once done, tap 'Next' to proceed.</li>
 <li>Add a unique list name and a corresponding description. Enter the details into their respective input fields.</li>
 <li>Finally, tap 'Create' to proceed.</li>
 <li>After completing these steps, the new SharePoint list will be created from the selected Excel file.</li>
</ol>

How to Create a SharePoint List From Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a38b2ab56e05a00fded8a/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open Excel on your Computer.</li>
 <li>Select "Blank workbook."</li>
 <li>Start editing the new Workbook you just created.</li>
</ol>

How to create a workbook in ms excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3904ab56e05a00fdf35d/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open Power BI Desktop. Click 'Home' and select 'Get data'.</li>
 <li>Select 'Excel workbook'.</li>
 <li>Click 'Load' to load your data set.</li>
 <li>In the 'Visualizations' pane, select the 'Table' icon.</li>
 <li>Add fields to the visual.</li>
 <li>Format the visual to look more like a worksheet.</li>
</ol>

How to Create an Excel Worksheet in Power BI

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a397dab56e05a00fdff33/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file in which you want to create the data entry form.</li>
 <li>Select the "Customize Quick Access Toolbar" button, and choose "More Commands."</li>
 <li>Find and select "All Commands."</li>
 <li>Scroll down and click "Form," and then select the "Add" button. You can finish by clicking the "OK" button on the bottom.</li>
 <li>Select any data on the cell and press "CTRL T."</li>
 <li>Click "OK."</li>
 <li>Select any data on the table you just created and click on the "Form" button on the quick access toolbar.</li>
 <li>You are now able to edit and view the data entry form you just create.</li>
</ol>

How to create data entry form in microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a398eab56e05a00fe011f/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open the file you want to create a dropdown list.</li>
 <li>Select the cells where you want the dropdown list to be displayed.</li>
 <li>On the Excel ribbon click on "Data," and select "Data Validation."</li>
 <li>On the Validation criteria select "List."</li>
 <li>Click on the up arrow.</li>
 <li>Select the cells you wish to appear on the dropdown list. Then click the down arrow. </li>
 <li>Select the appropriate label for each employee you want to categorize.</li>
</ol>

How to create drop down list in microsoft excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a39ccab56e05a00fe07bc/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Start a new Word file and navigate to the Mailings tab.</li>
 <li>Click Start Mail Merge &gt; Labels.</li>
 <li>Select the label type based on the brand and product number printed on your label sheet, then click OK.</li>
 <li>Click Select Recipients &gt; Use an Existing List.</li>
 <li>Locate your Excel file, and ensure the data is on the first sheet.</li>
 <li>Use Insert Merge Field to add fields like First Name, Last Name, Address, and City to the label template, ensuring proper spacing between fields.</li>
 <li>Click Update Labels to apply the format to all labels.</li>
 <li>Select Finish &amp; Merge &gt; Edit Individual Documents to preview and edit the labels.</li>
 <li>Specify the number of labels you want to print (e.g., 1–10) and click OK to print your labels.</li>
</ol>

How to Create Labels Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a39d7ab56e05a00fe0961/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>On a blank sheet, enter the headers and fields you want to include in your mark sheet.</li>
 <li>Input the data that you have for the table you just created.</li>
 <li>Calculate the total. In our case we do this by entering in the cell "=SUM (B2,C2,D2)," click on enter to finish.</li>
 <li>To calculate the percentage, type <code>=E3/300*100</code> in the cell, as shown in our example.</li>
 <li>Finish by dragging the bottom corner of the cell to automatically fill in the rest of the table.</li>
</ol>

How to create marksheet in ms excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3a0aab56e05a00fe0e6a/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Go to the Insert tab and click Get Add-ins in the Add-ins group.</li>
 <li>Search for a QR code generator, like "QR4Office," and click Add to install it.</li>
 <li>Open the QR code generator, type or paste the data (e.g., URL, text) you want encoded in the provided field.</li>
 <li>Customize the color, background, size and format of the QR code.</li>
 <li>Click Insert to add it to your Excel sheet.</li>
</ol>

How to Create QR Code in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3a20ab56e05a00fe10f0/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Open Excel and key in the necessary information and details about the employee. </li>
 <li>Fill in the details appropriately. </li>
 <li>Input the earnings and deduction of the employee.</li>
 <li>To calculate for the net pay as in our example type in "=b17-d17," then press enter. </li>
 <li>This will be the net pay for the employee on file.</li>
</ol>

How to create salary sheet in ms excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3a25ab56e05a00fe1142/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Go to Files to upload an Excel file.</li>
 <li>Click the ellipsis next to the file and select Make this a tab.</li>
 <li>Channel members can view and edit the file from the tab, with real-time activity shown for multiple users.</li>
</ol>

How to Create Shared Excel File in Microsoft Teams

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3a9eab56e05a00fe1bbb/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Inside your Microsoft Excel worksheet, find and select the text you wish to cross out.</li>
 <li>After that, head over to the top menu bar and then click the 'More Font Options' button.</li>
 <li>Choose 'Strikethrough' from the list of options.</li>
 <li>After completing these steps, the selected text on your Microsoft Excel worksheet will be crossed out immediately.</li>
</ol>

How to Cross Out the Text in Microsoft Excel

<LiveDemoIframe src={"https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3aa4ab56e05a00fe1c15/preview?step=1&embed"}/>

 
<h2>Guide</h2>

<ol>
 <li>Select "File."</li>
 <li>Click "Options."</li>
 <li>Select "Advance" then scroll and click "Edit Custom List."</li>
 <li>Click "NEW LIST" and select the arrow up button beside "Import."</li>
 <li>Select the cells you want to sort and click the arrow down.</li>
 <li>Tab on the button "Import."</li>
 <li>Select "Data."</li>
 <li>Click "Sort," choose the List you created, and press "OK."</li>
 <li>Select "OK" to finish.</li>
</ol>

LIVEDEMO

Showing tutorials from excel category

Tutorials