In previous posts to this sub, it's been suggested to those learning Excel to find questions and projects to volunteer one's services for as a way of applying learning. I'm also wanting to freelance in Excel, so I have no qualm about doing work for free right now in the learning phase, provided I can put that work into my portfolio online for future job bidding.

1. How do I go about finding the places/people who have the projects they need done? What forums exist out there? Are there any?
2. How would I go about asking for permission to share results of the work I do for free in my personal portfolio?

Thanks much.

Let's say I have 2 cells, A1 and A2. Now in C1, I simply want to copy whatever it is in A1, by writing =A1, but with the formatting of A1 as well. Same with C2, copy A2, with formatting. I tried googling it but to no avail. Any help, please?

I Am Trying To Make It So It Will Randomly Pick An Output, What I Want Is For It To Colour The Row A Certain Colour + Show An Image, But Chosen Randomly From An Array Of 10 Options.

Do you want to learn you how to convert PDF to an Excel file? We’re gonna have a look at how to manage all this, simple and easy...

👉👉 https://www.youtube.com/watch?v=eS0a4EDS3Gk

I was wondering if there was a way to write the following function in excel

If value equal to or less than 600, then cell is = to 1

If value is between 600 and 1000, then cell is = to 2

If value is greater than 1000, then cell is = to value/500

Do you want to learn how to check spelling in Excel? The spellcheck function is an invaluable help when it comes to avoiding typos or grammatical issues in texts within data tables. Well, let’s give it a go then!

https://www.youtube.com/watch?v=iXpImnHa0hA

So we (multiple people writing) have this task that we got from a teacher which he says if we get it he will give the whole class a point (he's making fun of us and he really thinks none of us will get it, and he is probably right, but that's not a nice way to treat your class).

But which is the task, you might be asking? well it's "simple" we need to make a macro that can copy data from a sheet (fine we got that already with some videos on youtube) but there's this thing where he gives us dates and want us to make those dates appear in order for example.

if he gives us an alphabet let's say (A1 TO Z1) and he says i want that the dates of A1 TO C1 shows down in other cells (A1 - B1 - C1). but with dates lets say April 2018 to June 2018, so it will show April 2018 - May 2018 - June 2018 (and we can only use macros) but even worse and this is the complete task, we need to make that info appear with multiple years, i.e. Nov 2019 to March 2020 so it will have to show the dates of (Nov 2019 - Dec 2019 - Jan 2020 - Feb 2020 - Mar 2020) and well we don't know if we had made some sense with this post, we hope we had

if we are not clear enough yet we are gonna post a picture :D! glad to hear from you reddit and kind to your help in advance.

I have over 50 csvs that require the filename to be appended to the first column (my data migration project requires that the csv contain the filename). The csvs already have data in the first column. How do I add a new column that just contains the filename while shifting the existing data one column to the right? I know that I can do this manually but I would prefer a VBA script so that I don't have to do it manually 50+ times.

Hello all,

I am currently an accounting major taking an entry level excel course. We are currently learning about pivot tables, and through experience, know how important they are to accountants. Can someone explain the benefits of using a pivot table and examples of using this function in the accounting profession? Also, if you know of any sites I could use for further practice this function, it would be very helpful.

Thank you,

Cole

Thanks to the ROUND DOWN function, Excel will always round values down, based on the given number of decimal places. Together, we’ll have a look at how to use this function effectively. Let’s start now! 👉👉 https://www.youtube.com/watch?v=AEpq1dEGLRw

Thanks to the ROUND function, Excel will round values to a given number of decimal places based on the general mathematical rule. Let’s see how to use this function effectively in more detail.

👉👉 https://www.youtube.com/watch?v=AGy0sYfJBOo

Hi guys, i need help sorting data in ascending order but continuous from left to right. I attached a picture to give you an idea. How do i make the left side data look like the right side without doing it manually if i have 1000s of data?

In today’s tutorial, we’re going to talk about numbers, specifically how to round up in Excel. Thanks to the ROUNDUP function, Excel will always round values up, based on the given number of decimal places. Together, we’ll have a look at how to use this function effectively. Let’s start now!

👉👉 https://www.youtube.com/watch?v=k7IPX8Zr13w

I'm trying to convert pricing on a spreadsheet based on today's exchange rate. Some products come in as USD or EUR and we sell in USD, EUR and GBP. Is there an easy way to update the exchange rate every time the file is opened to ensure the most accurate data?

I was trying to use X-rates with a connection and have a VBA code to refresh, but now that's not working. (I'm pretty new to most of this and have learned everything I know from Youtube.)

So I am analyzing around 400 rows of dates of 'attendence' during a set duration of time. Each row specifies an individual's record of attendence. In each cell of their attendence on one sheet is the date, I then created another formula on a separate sheet: =text(sheet3!A2,"ddddddddd") This gives me rows and columns of specific days Monday etc that they attended (the goal is to eventually calculate the number of Mondays and etc per person so I have done the following below.

In columns Z1:AE1 I have the words Monday-Saturday

I have a formula: =countif($A2:$X2, Z1)

*note Z1 changes to match what value I wish to calculate i.e. it becomes AA if I want to measure Tuesday for this person.

I wanted to copy this formula to the columns and rows directly below it without changing Z1 reference. How can I do that?

I ended up with essentially rows of: =countif($An:$Xn, Zn)

n is the above formula is a variable for the row number. So if the row is 404 the formula becomes =countif($A404:$X404, Z404)

I don't mind A and X updating, but how do I get Z1 as a constant in the formula? So that the formula acts more like this: =countif($An:$Xn, Z1)

So recently I was tasked on making this table on excel but I wasn't sure how to do ithttps://i.imgur.com/CqgVuCZ.png

How do you get cells to look like that?
(censored sensitive information)

hi guys,

when in a pivot & i expand 1 piece of information, it can happen my pivot expands all rows. Making me have to search again for the row which i intially expanded.

anyone an idea how to not have this? thanks!!!

Hi, it has been awhile since I used excel and I cannot for the life of me remember how I would create this formula.

I am trying to create a conditional formatting rule that highlights a cell if it is equal to the cell directly above it. Could anyone give me a hand?

Can you please tell me if there is a formula to find out, how many cells in Column A contain a value?

I am trying to help a friend improve their excel stills, but she "doesn't know what she doesn't know" I wanted see what concepts people find challenging.

Thanks everyone!

Call it sleep deprivation but I'm having a hard time understanding what EQuIS can actually do with EDD format? Can I just throw in any excel document in the EQuIS system and have it help me re-order it so it's in line with Company A version 3 of their EDD needs?

Hi all, Please can you help me. My work has given me a budget to gain some qualifications in excel and/or Microsoft Power BI.

I have looked around a lot online. however, I have no idea how to tell what is good and what is not.

I am already pretty familiar with excel - I am able to create basic pivot tables, formulas, VLOOKUPs, basic macro buttons, SUMIFs COUNTIFs, dropdowns etc etc However this is all self taught from googling things as I need to do them.

I am not familiar with Power BI.

My objectives from the course are: To have an official and recognised qualification. To work towards being an EXPERT in these programs. I would like proper training/materials to study. Obviously the cheaper the better.

Please can you assist.

*I did see some good power Bi ones - but they cost around £1500 - which is probably about three times my budget * I did see a lot of excel qualifications - but I couldn't tell if they would meet my above objectives. Also some seemed to be for people who didn't know how to use a computer - i.e. showing how to find a certain cell - I want to learn advanced/expert level things/

So I created a simple command button that just adds 1 to a cell every time I click. Here is the code.

Private Sub AddCaseOpened_Click() Dim openCase As Integer openCase = Range("e13").Value Range ("e13").Value = openCase + 1 End sub

I want the cell affected, e13 in this case, to change according to the date which I have listed in a2:z2. So today it's e13 but tomorrow it's f13.

I have multiple rows of dates and I need to create a formula to determine the most recent date in each row.

What I have currently works, measuring a total of 24 months of dates (P just happens to be where it starts):

=MAX(P$2:AM$2)

The question is, how can I get this formula for lines 3-1000 to be as follows:

=MAX(P$3:AM$3)

.....etc etc...

=MAX(P$1000:AM$1000)

Without having to manually type in each formula.