[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Office Productivity

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Share tech news, updates, or what's on your mind.

Sign up to Post

Need to combine OCR generate fields into meaningful values.

I have an OCR engine working well as it generates a space delimited text file. But the small fragment need to be combined into something meaningful as a form of post processing.

For example, the text on the page says:

VS DB DB Business Card - Retail

But in space delimited form, this is 7 fields.

I already have a finite list of about 25 possible strings, and can embed then in an array, such as

"VS DB CPS/Retail"
"VS DB DB Business Card - Retail"

so, I need to post-process the OCR generated file to be comma quote delimited, and use one of these pre-defined strings, when the OCR finds them.

What is a good paradigm for this?

Also, given this is OCR, there is a chance for a read error.

Thanks.
0
Fundamentals of JavaScript
LVL 12
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

MS Word Envelope Tool is failing

When I take a normal address and select Tools > Envelope

I get some strange view where only the left few characters in the address are shown, and the envelop is the wrong orientation.

Looks normal
Looks wrong
Why?
0
Using Office365 forms we capture data on issues that have happening in the business.
The issue is, that when we're reporting these issues we can only report as one clump of data,
we can't separate out the reports per month. So, last month's detail will be merged with this month's.

Is there any way of separating out the reports per month without having to export last month's data
& delete all form entries each month?
0
Finding my Sent folder in Outlook (Mac) v. 16.18?

I have used Outlook for months, but must have clicked something. Now, I can not find my Sent folder.

Is there an option to return the UI to the default?

I am not sure what changed, but it's hurting my productivity!

Thanks
0
Microsoft Office Picture Manager
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in 2013 or 2016. Now that Office 2019 is here, the bad news is that it is still missing, but the good news is that the same no-cost method that works to install it with Office 2013 and 2016 also works with 2019.
1
We have a programmer starting out that is giving his all, sitting from 4 to 8 hrs in his place working.  We would like to buy a chair more suitable for this.  A colleague recommended to bu a chair that people who play games all day buy.  So we wanted EE advice on buying a comfortable chair for prolong use.

(don't know what zone to place this question)
0
I'm sure this used to work but on the latest version of Office:mac 2016 (16.19 / 181001) the MkDir function appears to be broken.

Both of these lines will create a folder called "test", the second in the Office sandbox: (substitute "[USERNAME]" accordingly)

MkDir "/Users/[USERNAME]/Documents/test"
MkDir "/Users/[USERNAME]/Library/Group Containers/UBF8T346G9.Office/test"

Open in new window

But neither of them are accessible programmatically or via Finder:

Mac folder access error
As a workaround, I tried using this script with the VBA MacScript function below but it returns error 5 when used in VBA even though it works in the OSX ScriptEditor app:

tell application "Finder"
	set p to path to documents folder
	make new folder at p with properties {name:"ZIP"}
end tell

Open in new window


Public Sub MakeMacFolder()
  Dim tAppleScript As String
  
  tAppleScript = tAppleScript & "tell application ""Finder""" & vbCr
  tAppleScript = tAppleScript & "set p to path to documents folder" & vbCr
  tAppleScript = tAppleScript & "make new folder at p with properties {name:""test""}" & vbCr
  tAppleScript = tAppleScript & "end tell"
  
  MacScript tAppleScript
End Sub

Open in new window


What is wrong and is there a workaround for this?
0
Why does Power Point (Mac 2018 version) darken images?

When I run the presentation, all my images get darkened. And some become unusable.

Is this a setting i can turn off? I want the images to show exactly as they are in Power Point.

Thanks.
0
Setting up our first 'real' client on office 365 (others have been SOHO accounts - either new domains / starting from scratch or existing IMAP accounts.  but never more than 2 - 3 mailboxes).

Here we have 12 users on an SBS 2011 standard domain with the exchange running on the SBS 2010

They would like a proposal for moving to office 365.

Would anyone care to share their thinking on the things involved and the time involved below? Or does Microsoft offer info on this?

I would envision figuring the time is  a bit of a formula?  

Some fixed hours for setting up the office 365 tenant, changing the MX, SPF records, disabling exchange on the sbs box, and ____?  This would be the base work you'd do for setting up a domain that has 1 user or 100 users.... call that AccountSetupHours

Then there's time per mailbox to setup that specific user account on office 365, touch each desktop and each user's phone to change where outlook is pointing to (is there an easier way than just hitting each desk and each phone?  I am using Synnex as CSP for office 365 and they say for that small a number of users, there's a migrationwiz product but doesn't make sense to use that product).   Call that time PerUserSetupHours.  Figure this does NOT include migration of old data)

And they most likely would want it, but to keep it separate, migrating their old data as a separate item -  setup and running migrationwhiz (i never used it before), What else would go under this?  But …
0
Hello experts,
We are rolling out Office 365, and part of our roadmap is to introduce the Office client from Office 365 “aka Office ProPlus/Office 2016” on our client machines - VDI and some regular desktop. My question is how did your companies dealt.doing with the legacy Office (eg we currently have Office 2010)  on users desktops and VDIs, so users would move to the newest version? Any insights would be helpful!

Thanks!
0
CompTIA Security+
LVL 12
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

I guess I really don't know what I am doing.

Working on an SBS 2011 Standard machine on subnet 192.168.1.0.

There's a vpn to a remote location 192.168.2.0

A new laptop at the remote site with windows 10 / office 2016 keeps getting an error about the autodiscover.domain.com certificate.  It says the name on the security cert is invalid or does not batch the name of the site.

Clicking on view cert, it says it's issued to: domain.com   issued by let's encrypt authority x3 with valid date of 8/14/18 to 11/12/18

WE DO have a certifficate for the domain issued by comodo.  From a browser, if you type remote.domain.com/owa, you get to the owa page and it says it's secured with the comodo cert.

anyone know where the lets encrypt certificate is coming from?

Other laptops at that remote location are working fine for email.
0
Need a FREE survey web tool

I need free because of how I plan to deploy it to numerous businesses. But, I need some features also.

Mostly, I need the ability to export the questions, then import them into a different account.

Am i asking too much?

Thanks
0
Need a good cloud survey tool

I need a robust survey tool that enables me to develop a few "parent" surveys, but create an unlimited number of "child" surveys, which can inherit questions and answer, word for word, OR add and delete questions and answers.

Without a system to manage this, I see it could easily get way out of control, especially as customizations roll in.

I also need this survey to be anonymous so that clients can send my URL to their customer list without fear they will be losing their customer list.

I hope to get notifications when a survey has been completed.

What tool can you suggest?

Thanks.
0
We are using OneDrive for Business for Office 365. Get-ODStatus returns  StatusString: NotInstalled when OneDrive is clearly running.
0
Need a WiFi label printer

I do not like messing with Avery labels on a single sheet, passing it through my laser printer.

A sheet with 24 labels may need to pass through 24 times, causing the label to become dark. It just does not suit me.

I need standard label sizes and hope to set it up using WiFi and always loaded with blank labels, so I can just print.

What designs meet this need?

I expect to use Word to print the labels.
0
How do I use Mail Merge, Excel to Word?

I have a file with the info I need but need to create the Word template for this merge.

I also need to combine fields, like:

City, STATE ZIP

And since I have state names, like Florida, I hope I can map that to FL as part of the import feature.

Please provide some guidance or a little video that can help.

Thanks
0
Adding a signature image to Outlook emails?

I use Mac Outlook, 2018

How do I set the email signature? I have an image which contains it all.
0
in my company they want to implement express route since we have office 365 or use a wan balancer.

However according to what I read express route should be used with an optimization tool because express route helps on internet latency but connections are still bound by the inherent limitations of long-distance TCP connections and that Global SD-WANs are better candidates for cloud’s .


can someone help me clarify
0
One Note - Conflicts
Hi, we have a 15 tab excel spreadsheet within One Note that is shared by two people.
Even though we don't edit the same cells, and we try and close the spreadsheet when we aren't using it, we constantly get conflicts within One Note and end up losing work as we cant remember what has been changed.
One note does allow you to compare the spreadsheet with the conflict sheet, but as far as I can tell, doesn't tell you what's different. Its not practical for me to compare 15 sheets with loads of data in each.
Is there any way to prevent this or can One Note show the exact cell(s) that are conflicting (it obviously knows them to report in the first place)
many thanks
Rick
0
HTML5 and CSS3 Fundamentals
LVL 12
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Configuration progress while opening excel 2010 every time.

When I open the excel 2010 Professional plus on windows 10 Pro, I am getting Configuration progress screen which takes a while and then open the excel program.
I would need your technical support in isolating this error message.

Best Regards
Jawid Ahmad
0
Does anyone know what I need to change to get this VBA code to work in Excel for Mac? It works fine in Windows.

It is a show/hide toggle button for rows while the caption on the button changes as well. I used a form button (not ActiveX).

Sub HideDone()
Dim Shp As Shape
   
   Set Shp = ActiveSheet.Shapes(Application.Caller)
   If Shp.TextFrame.Characters.Text = "Hide Done" Then
      Shp.TextFrame.Characters.Text = "Show All"
      Range("A1").AutoFilter 10, "<>11. Published", xlAnd, "<>Cancelled"
   Else
      Shp.TextFrame.Characters.Text = "Hide Done"
      ActiveSheet.ShowAllData
   End If
End Sub

Open in new window


The message I get is
Run-time error 1004
Method 'TextFrame' of object 'Shape' failed

This code is highlighted in yellow
If Shp.TextFrame.Characters.Text = "Hide Done" Then
0
Need to make Word 2018 print a Booklet with 8 panels

I asked someone to create for me a Word template for the following booklet type:

http://gtsak.info/small-brochure-template/small-brochure-template-make-pocketmods-little-booklets-with-ms-word-3-steps-download/

I was given the following:

8-Field-Brochure-Template.docx

and was told it works fine on Word 2010.

InWord 2018 I do not see how to set to 8 pages...

Layout does not contain 8 pages
I see 6 or 9,,not 8.

Any idea why not?

Thanks.
0
Need a Word Template (Mac) for multi-fold booklet

I love the idea of using this little pocket booklet, but can not make this template in Word.

I assume the template would maintain the proper orientation, for example.

Can anyone dig one up for me?

http://gtsak.info/small-brochure-template/small-brochure-template-make-pocketmods-little-booklets-with-ms-word-3-steps-download/

Thanks.
0
we are in process of upgrading from office 2010 to office 2016

we have on premise office 2010 installed but all mailboxes are in office 365

we have E3 licenses.

we earlier went for .msi install and we want to  go same way for office 2016 also

i need to know what are the key difference between office 2010 and office 2016

also any article giving premium features for office 2016 as i need to give a small presentation

i am my self doing some search but just in case i get some more points from experts

thanks
0
Problem printing two half-pages on one side of the paper.

I am creating a flier that is 5.5 X 8.5, two sided, and wanted to use Word to force myself to make two halves on the page. That works and is done.

But, I am having trouble printing it. I want both sides on the single side, side-by-side, of a Letter sides page. Then I can flip the printed pages and pass is through the printer again, and print it a second time with the same Word document.

How do I do this?

I hope I do not need to lay this out again.

I would consider printing each page to a PDG then using Adobe Acrobat CC to merge into the two into one document.

Can anyone help explain my options?

Thanks.
0

Office Productivity

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.