Posts by Kyle Johnson2

casualbear7 said:How do you make a chart in Word 2010? ................
Anyone got a tutorial?

Just look up some tutorials

- Charts in Excel 2003
- Charts in Excel 2007
- Charts in Excel 2010
- Chart in Excel 2010 (video)

Chloe Stewart29 said:fixed

Man, I love these types on forums—people who ask for help and then...
once they fix it themselves, they just ghost everyone. Like, "oh, nobody else needs this info."
Do these people seriously think they're the only ones who'll run into the same issue?div>

Larry Fox5 said:3) I need to calculate the departure time in the third column, but I'm stuck on how to build the formula.

It all comes down to how you handle the previous day, like @Walter Jackson48/">@@Walter Jackson48 mentioned.

Try this instead:

A1 Arrival
B1 Travel duration
C1 =A1+60-B1

btw: check out a tutorial on subtracting hours

casualbear7 said:I need to type out a fraction in Word 2010, but I'm totally lost in the interface. Specifically, right after this sign

watch this tutorial

- How to write a formula in Word 2003
- How to write a formula in Word 2007

Pretty sure it's the same deal, or at least close enough, in Word 2010

ironcanyon18 said:I need a sign about 5 feet long. Thinking about tracing the outline and then just hitting it with some spray paint on the wall.

You probably have Microsoft Publisher, too.
Just pick an A4-sized template to start with.
Drop in your text or image and print it out. You'll end up with a bunch of standard sheets. Tape them all together, trim the edges, stick 'em on the wall, and spray away.
Get creative





btw: check out a tutorial for Microsoft Publisher

rapidtinker12 said:Anyone got an Excel template for making invoices or proforma invoices?

You can totally build your own template to fit whatever you need. Once it's set up, just save it as a template and go from there. You can even automate the invoice numbering. Just tweak the service items to match what you're doing.
Check out this full invoice example and grab whatever parts work for you. Get creative. 🙂

- Full Excel invoice example

restlessdrifter12 said:I need two separate tables that aren't connected at all.

Just make a primary table first (1 row, 2 columns) and kill the borders.
Then, just nest a new table inside the first cell, and another one in the second.

Hope that does the trick. Peace.

restlessheron19 said:Can anyone help me out? Just need some basic guidelines

Alright, here’s the lowdown on using the IF function in Excel

feralgull99 said:Is there an easy way in Microsoft Word 2007 to whip up a table of figures?

Check it out, maybe this tutorial can help you out

- How to create a table of figures in Microsoft Word 2007

Patrick Sanders91 said:Didn't work

Man, what can I even say?
Just drop the file here for download so we can figure out what's broken (assuming it's not top secret), otherwise just keep tinkering

Patrick Sanders91 said:hey
writing a term paper and my Table of Contents is acting up like in the pic. help me out thanks

The issue is you haven't separated your headings from your body text, or they're both using the exact same style.
Go to page 12.
Put your cursor right after the heading and hit Enter. Highlight the next paragraph and set the Style to Normal, then Refresh TOC.
On page 14, just highlight the messy paragraph and Modify its style.

Chloe Adams6 said:I'm trying to figure out how to change the color, but not the page itself—just the background.

For Word 2007 check this link

George Harris2 said:URGENT URGENT URGENT Microsoft Office

Just get to work ASAP. Professors are always right, there's no arguing with them.

- Table of Contents (TOC)
- Page numbering in Microsoft Office
- Paragraph numbering in Microsoft Office

Walter Jackson48 said:If those numbers are sitting in column B from B1 to B10, just pop this into B11: =COUNT(B1🙂10;"=15"). It'll count every instance of 15 and whatever else you need.

Nah, that's not quite how it works.

The COUNT function uses =COUNT(value1;value2;value3...) or =COUNT(range), which isn't gonna get you what you're actually looking for.

You gotta use COUNTIF instead. The syntax is =COUNTIF(range;criteria)
where the "criteria" is the number of years—you can either type it straight into the formula or link it to a cell.

=COUNTIF(B1:B10;15)
=COUNTIF(B1:B10;E1)

Timothy Kim60 said:I seriously can't believe how buggy and just plain stupid this software is... it makes zero sense. Someone please just tell me one thing—how do I stop the first couple of pages (where my table of contents is) from being numbered, but have the rest start at page 1? Back in Word 2003, I figured out how to skip numbering the first page, even if it took me forever,

Honestly, I'd say you're either doing something wrong or the program is glitching out because of some setting somewhere.

It’d be helpful if you could upload the first 5 or 6 pages of the doc so we can see what's actually going on.

As for starting the page numbers later in Word, just check out this tutorial. It breaks everything down clearly.

- Page numbering from the third page in Word 2007

Timothy Kim60 said:Basically, half my footnote jumps to the next page, even though I've seen docs where footnotes take up more than half a page

Not being super clear here. Maybe toss up a screenshot of the issue? In the meantime, try running this VBA macro on the page—but seriously, do it on a copy of the doc first

Maria Hayes48 said:I'm still totally down for any suggestions or ideas regarding formulas! Any help is huge!

Let's give this a shot.
column A1 : A52 are the first numbers in your combinations
column B1 : B52 are the second numbers in your combinations
In cell C1, pop in the formula =A1&B1 and drag it down to row 52. Now you'll have combined combos (like: 1-1 becomes 11, 1-2 becomes 12, etc.)
In a column—let's say E—put your criteria, which are all your possible combinations (all 25 of them). So, from E1 to E25, just list: 11, 12, 13, 14, 15, 21, 22, 23, 24, 25, 31, 32, 33... all the way up to 55.
In cell F1, type =COUNTIF(C1:C52;E1) to count how many times those criteria from column E show up. Drag that down to match your list.
That way, you can see exactly how many of each combo you've got.

Timothy Kim60 said:Anyone know?

Just post the download link for that part of the doc so we can actually see what we're dealing with.

Thomas Gonzalez8 said:So, just making sure—do I need to drop these links into every single cell in those vertical columns?

Check out that link Tracking Football Scores in Excel—I laid everything out there step-by-step.
If you don't actually test it out, you're never gonna know 😉

restlessdrifter12 said:Still nothing. I plug in the formula and instead of getting an actual result, it just gives me... nothing. I can't see any content to rewrite! Send over the text you want me to work on.

Weird, right?
There's actually the exact same question over on another forum, and they even posted a file you can just download. Not trying to plug the other site or anything, though. Here's the file. Grab it here..



Need to turn that column of timestamps into actual time? Just use a formula.
=TIME(0, LEFT(E4, 2), RIGHT(E4, 2))
Format cells as Custom => mm : ss