Master the advanced techniques required to protect network resources from external threats with the IT Cyber Security bundle. Built around industry best-practice guidelines, the IT Cyber Security bundle consists of three in-depth courses.
Articles & Videos
A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
I want to create a spreadsheet that only has a few drop-down boxes or text fields where a person can select their name from the list, enter their data and have it automatically added to the sheet that…
I have an excel workbook with 50+ worksheets.
I need to consolidate all those 50+ sheets into another sheet on the same workbook.
Something like Sheet 2 copied data under sheet 1, then sheet…
I need to reorder data on the attached spreadsheet. I need the Date and Amounts from View 1 to line up and look like View 2
View 2 has a date per record and the cumulative hours next to the date, …
So I have this Excel spreadsheet with formulas pulling values from a couple sheets.
The ISSUE :( is that the table is not "dynamically" populating adjacent rows with related data…
Any help welcomed as totally stumped on this Exc el conundrum.
I'm trying to concatenate values from the Details tab into [Column H] values of [Column A]
For instance, if you …
Hi Guys, on the attachment, I have a macro which copies and pastes Values the sheet "ECB calc" to an attachment in Outlook and sends it .
However, when the recipient opens the attachment, there is …
How to calculate number of weeks in a month in Excel 2013? Below is the Excel table that I am using.
I have a summary worksheet in excel I am trying to create, it is to be generated from a much more detailed server inventory worksheet. Within the inventory worksheet called 1-inventory I have a server…
I am working on a project with many userforms with a wide range of controls (listboxes, textboxes, MonthView etc.) using Windows 10.
Once data has been added to the worksheet, the formula bar keep…
I have a data set which has got 190 Products arranged in Columns, and 4 Rows, which show the Value % Change over 4 different time duration respectively.
I need to do 2 tasks in this w…
I have a data set which has got Two Columns, named - Product and Value % Change, respectively.
I am looking for some DIFFERENT METHODS which could be used for Ranking this data from 1…
I have a table of absences which is populated through a userform, I would like to be able to add command buttons or toggles to the userform to be able to search the records and edit or delete them. I …
I have a big Excel worksheet with Name & Contact information entered. It probably has close to 2,500 records.
I want to transfer all the sheet tabs into a new worksheet without certain columns and w…
I was wondering if anyone could help me with creating an array formula in Excel. I am trying to do a lookup on a value and sum the costs all in one cell. Attached is a workbook that has a sim…
I created an organization chart in Visio 2010 from an Excel spreadsheet.
It shows the top level, but not the second level.
I have searched on the web, Visio Help, and tried just about everything men…
I have a list on Shipments that I need to match Description from list in Surcharges sheet.
Does not matter the order.
Column A = Date
Column B = Category
Column D = Cost
I'd like to get a total cost of a given category in a given month. This is to itemize some expected expenses in a budget in order to better pre…
I'm looking to fix this formula so that it works as follows in google sheets:
Regex expression: \(.*?\)
Input: Jessica (M4KYYF)
Expected output: M4KYYF
Actual output: (M4KYYF)
I'm looking for a solution to integrate a PostgreSQL database in my google docs spreadsheet.
My database consists of about 20 or so tables, some with several thousand rows.
The database is const…
I've included a spreadsheet that has some manually entered data on a few rows. I've included text boxes on the spreadsheet with details concerning my needs for formulas.
I may be trying to get an …
Spreadsheet is attached with needed raw data already shown. Notes concerning formulas are in a text box on the spreadsheet.
Would like to accomplish the needed tasks with IF STATEMENT, if possible…
Could you please have a look to the example in the attached file, basically there is a sheet named 'ProducedQty':
from where I would need an Excel formula in the B column of shee…
Greetings to all;
First of all many thanks for the time to read my question, I've been reviewed in the forum but I have not had capable to find something similar, I have the following table:
6,800 points this week
2,800 points this week
2,000 points this week
1,800 points this week
Subodh Tiwari (Neeraj)
Kanpur University, Uttar Pradesh, India
1,800 points this week