Posts by Kyle Johnson2

driftingheron52 said:Anyone know a good program for making photo calendars??

Not being very clear here, buddy.
What kind of 2024 calendar are you trying to make?

Check this out.

Free online tool PDF2Word is out there

Henry Lewis37 said:how do I make charts like this in Excel,

That example you posted? That was made in actual graphic design software. Check this out: example

Excel isn't really built for heavy-duty 3D charts. If you want to get fancy with some 3D stuff and play with colors, you’re gonna have to put in the work using the tools on the Design, Layout, and Format tabs that pop up in Excel 2007 once you click the chart.

If you're looking for those super high-end, custom "pro" 3D charts, you need specialized software for that.

Just Google "free program to create 3D graphic charts"

casualranger2 said:What's the name of this font in Microsoft Word?

Can't you just play around with it a bit?
I'd say it's Verdan

Henry Lewis37 said:Anyone know anything about 😢

http://www.youtube.com/watch?v=B1pAvMjj4Ko

Jacob Bennett6 said:So, it's basically like if my known data points are X, Y, and Z.

So, I've got this massive list running from A1 down to A3600. Total headache. I have zero clue how many unique values—X, Y, Z, whatever—are actually in there, or even how many times they're repeating. Any ideas?

First you gotta pull all those unique values into their own column, then just sum them up.
Check out this tutorial:

- Gathering unique data.

Henry Lewis37 said:Link to file

Don't see the issue here. Column headers and row numbers were just hidden along with the gridlines. Here’s the file back
example-excel.xlsx

Henry Lewis37 said:like, you can't even double-click between A and B to get the cell size I want.

There’s a few reasons for that. You should've uploaded the file for download so we can actually see what's going on—right now it's just guesswork. Just wipe the sensitive info but keep the data length the same in those problematic columns/cells.

btw: might be some merged cells or weird formatting issues. Try switching everything back to General.

Joseph Fisher2 said:gotta ask a simple (hopefully) question

Nah, actually isn't that simple at all
If you aren't satisfied with what JohnC put down, we gotta dig deeper.

Looks like the table is missing pieces and doesn't show the full picture, so there might be follow-up issues here.
1. Is everything in that first column unique (no repeats)?
2. Does the result strictly have to be "Pero 900 Pero 300" or can it just be "Pero 900 300"?

Basically, we need to know if those first column values are all unique. If they are, this should work:

Option one:
Say your data is in range A1:D6 and results go in G1:I6. First, grab those UNIQUE data points. Column G gets the unique stuff from column A, and column H pulls from column B.
Drop this formula into cell I1 and drag it down.
Code:

Then, pop this into cell L1
Code:

The results should look like this:
Code:

If that doesn't cut it, then we try option two.

Again, grab the unique info from columns one and two and put them in G and H.
Put this in cell I1 and drag it down.
Code:

Now, put this in cell J1 and drag it down.
Code:

Finally, one more for cell L1:
Code:

Result should be:
Code:

northernraven5 said:need help ASAP with PowerPoint 2010.

This tutorial wasn't made in PowerPoint 2010, but should still get the job done.

- Animating text in PowerPoint

Douglas Miller60 said:how do I get all the text into the left Column? if there isn't any more text, just move it over so it fills both Columns :S

Looks like you've got some dead space hanging out behind that left paragraph.
1. Just pop your cursor at the end of the left paragraph and mash the DEL key until everything pulls back into the left Column.

2. If that’s being stubborn and you don't need to email the file digitally, just drop a table cell or a Text Box right under that left paragraph. Set the borders to invisible and just shove your text inside that box.

George Ortiz11 said:Since the time gaps between those years aren't even, I need to find a way to make the tick marks actually reflect that spacing.

If I'm following you right, check out these tutorials and see if any hit the mark. Look specifically for settings regarding major and minor gridlines (Axis formatting).

- Creating charts in Excel 2003
- Extra tips for Excel 2003 charts
- Creating charts in Excel 2007
- Changing OSI values on an Excel chart

Edward Gray9 said:How do I make Word automatically stretch my headings from one edge of the page to the other?
Do those bullets actually work? They need to look like a proper Table of Contents, like something you'd see in a college term paper.

We already covered this. Just go back and read the thread.

- Making content in Word 2003.
- Making content in Word 2007.

Mark Doyle17 said:I'm absolute trash at this stuff and could really use some help.

Here are the links. They’ve got step-by-step guides with screenshots so you can actually see how to pull this off. Put in some actual effort and learn something for once.
Until someone actually shows up to do your homework for you. 🙂

- Making labels in Word 2003.
- Making sticky labels in Word 2007.

Arthur Thompson8 said:from some sites, and they're dark colored

From what I can tell, you were looking for a photo with a dark background? The one you posted doesn't have a dark background at all. 😕
Ever thought about the fact that this image might be under copyright? You really ought to reach out to the creator for permission before using it, otherwise you might run into legal trouble down the road (unless the site you grabbed it from explicitly says it's FREE to use).

Arthur Thompson8 said:and if anyone knows how I can settle up with that guy, hit me up

For real, the artist is scouring the web and tracking down anyone using their work. 🤷
Maybe there are a few like that out there?

Arthur Thompson8 said:Basically, I'm looking for some help finding some sleek, dark modern vibes for my Meta profile pics. My brain is empty on ideas and I'm definitely no pro at this stuff.

Check out avatar icons HERE

Check out cover photos HERE

just links and stuff, nothing fancy 🙂

Nicholas Wells74 said:I wouldn't bother signing up for a course. Just figure out how to force Excel to start counting from whatever number you actually want, instead of just defaulting to 1.

Look, if the app or the file itself has restrictions, your hands are tied. You can't change the software's limits unless you can just toss in an extra column or manually type out the sequence you need.

Nicholas Wells74 said:I think you missed my point entirely... and which specific cells aren't letting us type anything?
I want to force Excel to start numbering from a specific value instead of just starting at 1.

Sorry, I'm not a mind reader—you didn't attach an example, so I have no clue what you're looking at.
btw: How exactly are you planning to enter numbers into a range if you don't even have permission to edit it?

Nicholas Wells74 said:I wish I could force Excel 2003 to stop starting at 1 and instead start counting from whatever number I actually want.

If I'm following you right, you just need to quickly create a numeric series in Excel. Check out this tutorial

Benjamin Long7 said:So, I'm looking for some help with two macros in Excel

Honestly, you don't even need VBA—you can just use Ctrl + F

Check this out. It’s got a bit of everything; might find what you're looking for here.

1. Find a specific word in a Worksheet (check the bottom of the tutorial)

1a. Find specific text within a Workbook

2. Hyperlinks in Excel