SoftwareFiesta

Some of the common reasons for “ The document is locked for editing by another user ” error are as follows: Microsoft Excel isn’t closed properly and, therefore, didn’t erase the owner file. The second request of the Excel file is active in the background with the doc already open. The Excel doc is shared […]

Excel is part of the Microsoft Office “suite” of programs which, while it isn’t that expensive to purchase, is still an unnecessary cost for many of today’s fledgling businesses. When you boil it down, Microsoft Excel is simply a spreadsheet program, for which there are many alternatives. Even better, many of those alternatives are free! […]

Automatic: the default option that tells Excel to refresh the calculation any time information in the formula’s data range is edited. Automatic Except for Data Tables: also tells Excel to recalculate any formulas if the data in the formula’s cells changes. Manual: turns off auto-calculations in Excel so you’ll have to calculate manually. How to […]

In Excel, you can now import, refresh and analyze data from PDF documents. To use this feature, go to the Data tab > Get Data > From Files > From PDF. Starting in Excel 2016, you use Get & Transform to connect to external data and perform advanced queries. You could be asking “Can you […]

How to Create a Bar Graph Select the cells containing the data you want to show in your graph. (Cells A1 to C5 in this example.) From the ribbon, navigate to the Insert tab. In the Charts section, click on Insert Column or Bar Chart. This will open a menu of the available column and […]

To open a CSV file in Excel: Open a new Excel document in Excel → New: Navigate to Data tab: Choose From Text: Locate and select the CSV file that you want to edit and choose Get Data: From the newly-opened window choose Delimited, then click Next: More items. Can you open a CSV file […]

How to Create a Macro in Excel Create a Macro . With Excel VBA you can automate tasks in Excel by writing Right click anywhere on the ribbon, and then click Customize the Ribbon. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary). Check the Developer check […]

Select cell B5.. Expand the selection to the current region (using Ctrl + Shift + 8)Type Alt + O to select the Format menu. Type C to select Column .. Type A to select Autofit. Select one or more cells you want to use as a basis for filling additional cells. Drag the fill handle […]

Excel AVERAGE function – things to remember! As you’ve just seen, using the AVERAGE function in Excel is easy. However, it does have a few specificities that you need to be aware of. Cells with zero values (0) are included in the average. Cells containing text strings, Boolean values of TRUE and FALSE, and empty […]

Accessing Microsoft Excel and other core Office programs is free via the web, and all you’ll need is a Microsoft account. Head over to Office. Com and create an account, or log into one that you already have. Once you’re logged into your Microsoft account on office. Com you’ll find yourself presented with this screen:. […]