Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

restlessmoose23 said:I could really use some help here. I noticed how pricey a single package like this can be, and since I need enough for an entire office, I'm a bit lost. How does this actually work? Do I have to buy a separate license for every single computer, or is there some kind of bulk discount available if I order several at once?

Is there nothing free on the table? For instance, what about OpenOffice? 👍

Does anyone know if I need a constant internet connection to get anything done in Excel or Word? Like, if my Wi-Fi cuts out for a few hours, am I just stuck and unable to use the software? 🤷

EDIT: It looks like with Microsoft 365 Business Premium I don't actually need to be online since it includes the desktop apps, right? 🤷

analogtiger19 said:So, basically... if my internet goes down for a few hours, can I still use Office or am I just stuck? 🤷

Za Just a few seconds. You could've found that out yourself.

The speakers kept hitting on how reliable and top-tier Microsoft’s data centers actually are. They basically promised that users won't be dealing with any lost data—you know, unlike some of those other services out there that can't seem to keep things together. You can even work offline.Once you log in for the first time, all your data from your local machine just syncs right up to the cloud. Done.

Kyle Johnson2 said:You could have figured that out in a heartbeat.

Yeah, I updated my post to say I did. Thank God I did too, because your answer is only half right—it might work for certain versions of Microsoft 365, but it’s not a universal rule. 😛

Whatever, thanks anyway! 😬

Is there actually a way in Word 2010 to move specific pages from one document over to another? I'm not talking about just the usual copy/paste routine for the content itself—I mean moving an entire page as a single unit into a different file.

So, I'm messing around in Word 2003 and trying to draw two circles in some super specific spots on an A4 sheet, but I'm totally stuck. Any tips?
Basically, I need these circles centered horizontally on the page (like, perfectly aligned on the X axis) and sitting exactly 2 cm from both the top and bottom edges.
I want it to look just like this image here.

Sam Peterson6 said:The circles should be centered on the list (X coordinate) and sit about 0.8 inches from the top and bottom edges of the page.

Here's a starting point: circles with these dimensions—you'll have to mess around with the positioning and grouping settings yourself.

Kyle Johnson2 said:Here’s some circles with dimensions to get you started. As for the positioning and grouping stuff, just mess around with it yourself and see what sticks!

Oh man, I just clicked the link and it's giving me this:
The download link has been updated (error: #10).
You may now download the file.
If this error is persistent, please try to disable your
anti-virus program or add sendspace to your white
list.

Could use some help with this one...

I've got an Excel sheet set up with 40 columns and 1,500 rows, all filled with numbers ranging from 1 to 10.

Here's what I need to do:

a) Find the number that shows up the least often in the whole table.

b) Identify the 10 numbers that appear least frequently.

c) Figure out which number pops up most much in just the first 100 rows (so, the first 4,000 numbers)?

Should I be looking at a specific function, messing with filters, or maybe combining a few different things? Any ideas?

Sam Peterson6 said:Ooo shit, .......If this error is persistent, please try to disable your anti-virus program or add sendspace to your white list.

I don't have any issues downloading files even with my AV running.

mellowbear21 said:Not sure if I should use some specific function, maybe a filter, or just combine a few things together?

Check out this tutorial Most frequent and least frequent numbers

Sam Peterson6 said:I need to draw two circles in Word 2003 at very specific positions on an A4 sheet, and I have no clue how to pull this off. Any help would be appreciated.

First things first, let's set the margins. Set Top=2 and Botton=2. Once that's done, you need to enable the Drawing tool—go to View, then Tools, and check the box next to Drawing; that should pop it up in your toolbar down below. Now, grab the ellipse shape tool and just click-and-drag along the top margin line using your left mouse button. Right-click that ellipse, and a context menu will pop up; select Format AutoShape. On that tab, go to Size and type "12 cm" into both the height and width fields. (There, you've got yourself a circle with a 12 cm diameter). Then, staying on that same card, head over to Layout, check the box for Center, and that’ll snap your circle right into the middle of the page. Easy enough, right?
Now, you repeat the whole process for the inner circle, but with a slight tweak: open Format AutoShape again and set the dimensions to 4 cm (just like before), but this time, under Layout, go to Advanced. There, you can set the Horizontal absolute position to 6 cm in Column (right), and the Vertical absolute position to 3 in Line (right). Just make sure you check the box for Other or Center, alright?
And there you have it—two concentric circles with exact dimensions. If you want to move them, just hold down the CTRL key to select both, hit Copy and Paste, and then just drag them down toward the bottom of the page.
But wait, how do you actually know if your circle is sitting exactly on the top or bottom margin?
Go back to Tools, then View, and check the box for Text boundaries. That'll draw a little frame showing you exactly where your workspace ends and your margins begin. Align your circles against those boundaries, and once you're satisfied, just uncheck Text boundaries to hide the frame again.
As for reading the margin values on the ruler? Hold down the Alt key and hover your cursor over the ruler right where the blue and gray colors meet (that's your margin boundary). When the cursor turns into a double arrow, click your left mouse button while still holding Alt, and it'll show you the margin value. You can even drag it around with the mouse to adjust it on the fly.
It's a bit of a long-winded explanation, I know, but I'm pretty sure it'll get the job done.

Nice! You nailed that explanation. I finally got it working.
Thanks

So, I’ve got a list of numbers in an Excel column—all sitting somewhere between 30 and 40. Let's say they look like this: 31, 33, 39, 36, 32, 38, 35, 34, 37.

I know how to grab the absolute minimum using the MIN(A1:A9) function,

but what I really need to figure out is how to find the *next* smallest number right after that first one, without including the minimum itself.

For example, if my first formula spits out 31, I need a way to get the next lowest value from the remaining numbers (which would be 32 in this case).

Does anyone know which function can pull that off?

mellowbear21 said:but I'm trying to figure out how to grab the next minimum after that first one (without including the previous one itself)............What function should I be using here?

Try using the SMALL function.

Greetings,

I am looking for some assistance regarding Excel. Is it actually possible to configure a function where Excel generates random characters? Specifically, I want it to output only a "+" sign and a " " (space).

The goal is to have it randomly populate 20 columns with a mix of plus signs and empty fields.

Thank you.

Scott Wood2 said:Hey there!
I could use a hand with Excel. I'm trying to figure out if it's possible to make Excel spit out random characters—for example, I want it to randomly pick either a "+" or just a " " (a space).
Thanks!

=IF(RANDBETWEEN(0,1)=1;"+"," ")

☕

In
column D, I want to list the COLOR names based on how many times they show up in column C.
To be more specific, cell D1 should say GREEN (since it appears 25 times, just like in cell C1), then D2 should say WHITE (because it shows up 31 times per C2), and so on.

So, which function can help me reorganize these colors using column C as my guide?

mellowbear21 said:In column D, I'd love to see the actual COLOR names printed out based on how many times they show up in column C.

Wait, what’s the point of all this?! 🤷
Basically, what you’ve already got sitting in column C—and what you're trying to get in column D—is just columns A and B sorted by column B.

Jack Hayes said:So, what's the point of all this?! 🤷
What you ended up with in column C—and what you're actually looking for in column D—is basically just columns A and B sorted by column B.

Look, I totally get it. I only used that to keep things simple.
The real deal is that I need this for a list of about 10,000 numbers. I won't be looking at the whole set at once, but rather breaking it down into pieces—like the 10 smallest values or the top 50 most frequent ones.

mellowbear21 said:Basically, I'm looking for a function that can trigger a new color scheme based on what's in column C.

And what happens if, say, green and white end up having the exact same count? Is that even possible?
You should probably just upload a sample file for us to grab. Throw in some realistic data so we can actually see what you're dealing with—I bet it's way more complicated than this little example shows.