Microsoft Office

64K

Solutions

41K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

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

Sign up to Post

Wireless Access in my Home Office

For background read my question:
https://www.experts-exchange.com/questions/29108066/Wireless-Range-Extenders.html
with Solution by my friend David Johnson.

I had for a long time worked on my kitchen table (we have a large enough kitchen) but I get involved in hour long Skype (MVP) and Adobe Connect (Volunteer work) conversations that get in the way of household activities.

So I went up to Staples (Office Depot) and got a desk and office chair. The desk is compact, glass top, two legs (one at each end) and is very decent quality. The chair is standard office, cushy leather and nice to sit at. This is all in my upstairs Den with a small TV and DVD player.

So at David's suggestion, I got a Ubiquiti Access Point. This has to be the best thing since sliced bread. Connect the LAN side of the POE injector into my Cisco RV325 VPN router and the POE side to the Ethernet cable that goes to the Den. Plug in the Ubiquiti and configure it and now I have a dual radio Access Point (2.4 GHz N and 5 GHz AC) upstairs and same downstairs with my Cisco RV134 wireless router.

Devices (ThinkPad and two iPhones) are absolutely transparent as they move around. Just one SSID for each band and the Ubiquiti looks after everything.

This is a very nice way to support another office in a residence.

Upstairs Office

0
Cloud Class® Course: MCSA MCSE Windows Server 2012
LVL 12
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Amazon is launching a new business where you can franchise a branded Amazon courier service:
https://logistics.amazon.com/

Startup cost is $10k

They estimate annual profit for a fleet size of 20-40 vans at $75k - $300k a year:
https://logistics.amazon.com/marketing/opportunity

Is this the "Uber"ization of the Post Office?
2
LVL 55

Expert Comment

by:Scott Fell, EE MVE
I saw that the other day too.  I think the vans turn out to be daily rentals from Enterprise. Managing 20 to 40 vans probably means managing 30 to 60 people, 12 hour shifts, 7 days a week.  If you are at the low end of $75K, that is a lot of work for that amount.
2
LVL 19

Author Comment

by:Lucas Bishop
Yeah, package/mail delivery is a real grind. My parents are retired postmasters, so I'm interested to hear their take.

I could see how this would be an interesting fit for someone with experience in managing a delivery/logistics model, to be able to work for themselves. At the same time, you would have no negotiating power with Amazon as far as payment per package/van. Seems like an extremely high risk scenario.

Seems like the only way you could step into this safely, is if you could look at the historic package volume for the geographic region you'd like to service.
0
SysTools Released SysTools Office 365 Export Version 4 With Archive Mailbox Migration

OFFICE-365-EXPORT.pngThe SysTools Office 365 Export migrates the Office 365 account data to PST, EML, MSG file format. It has also been updated with the feature to Migrate the Archive mailboxes from Office 365 to PST, EML, MSG file format with multiple filters for mails contacts, calendars.
For more information visit:
https://www.systoolsgroup.com/office-365/export/

                           

1
For those of you wondering what might be up and coming in Office, one way to stay on top of that is the office 365 road map page:  https://products.office.com/en-us/business/office-365-roadmap?filters=#abc

and checking the "In Development" section.  For those interested in Microsoft Access, you will find a new feature listed there:

"Access: New charts for modern data visualization
Introducing new charts to help you visualize data managed in Access in an appealing and modern way. Add any of the new eleven chart types, including a combo chart, to a form/report to visualize your data and make informed decisions."

Sounds like we are going to get a major new feature!   Of course, if your part of the Office Insider program, you'll be one of first to be able to check it out!
0
Exchange Admins,
Exchange Administrator of a O365 tenant that is using either DirSync or AADSync are no longer supported and may not work correctly. These tools are no longer supported as of April 2017, and after December 31, 2017 O365 team are not able to guarantee your connections from Windows Azure Active Directory Synchronization (DirSync) or Azure AD Sync work properly.  This may affect your ability to synchronize your local directory infrastructure with Office 365, and will result in users being unable to log in to their Office 365 services.

Recommended action
Azure Active Directory (AAD) Connect is the best way to connect your on-premises directory with Azure AD and Office 365.  Upgrade your sync functionality to the latest version of Azure AD Connect, which is the currently supported tool for syncing data to O365 cloud features.

Hope it helps.

Thanks
MAS
1
0
If I want to pursue a career as a Data Analyst and I have limited data analysis skills in addition to SQL, Python, HTML, CSS and Microsoft Office Suite experience, are there any certifications I could take to bolster my credentials as a Data Analyst?
1
How Mobility Is Modernizing Oil Field Services

Mobility solutions is what personnel working at oil fields need. But are they doing their bits to revolutionize the oil fields? We need technological advancements not just on the field but also the backend office which till now was abstained from newer ways of service deliveries that goes beyond the perspective to legitimize the modern uphold.

Get more info: https://goo.gl/BkFtBt 
0
Microsoft has added a page to their Office Templates which provides templates for five types of Access databases (Asset Tracking, Contacts, Students, Event Management, and Task Management).  I have not had a chance to review these databases, but this is the first move we have seen in quite some time to add anything "Access" to Office marketing, and is good news.

Please download these templates and encourage others to do so.  If we generate enough traffic, maybe we will be able to get additional templates on the website.

0
Kernel Data Recovery released Express Edition of Kernel Migrator for Exchange

The new Express Edition tool 1.jpg has an exciting feature to migrate single or multiple mailboxes from Exchange to Exchange. Exchange to Office 365, Office 365 to Exchange and Office 365 to Office 365 platforms. Another excellent feature of this Exchange Migrator – Express Edition tool is that it has no need of MS Outlook installation. It supports all versions Exchange Server. To know more about the software; visit: https://www.nucleustechnologies.com/exchange-migration/express-edition.html
0
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

I am sharing an Office 365 Calendar using a Security Group. When the calendar was initially shared, it sent invitation emails to the group members. How do I manage invitations when I add someone to the group? It doesn't appear to do it automatically.
0
LVL 36

Expert Comment

by:Rob Henson
djstewart - you have created a post here. You will get better results if you raise a question. Use the big blue button at the top of the screen or this link:
https://www.experts-exchange.com/askQuestion.jsp
0

Author Comment

by:djstewartnc
Thanks Rob. First time in since they changed the format .... still fumbling my way around.

Will do.

David
0
gSuite help is still terrible.

I have several comments about how using paid support for Office 365 is far superior to the experience using gSuite including my comment on this article from 2015.

Yesterday's call to gSuite support reconfirms.  Problem is a user wants to have access to Android apps on his new Google Pixelbook. Going to settings on the Pixelbook to enable the feature is grayed out.  A call to Pixelbook support confirmed the issue is the user is a member of a business gSuite account and there is a feature that has to be turned on.  I was directed to call into gSuite. Calling gSuite support is about as helpful as talking to my 2 year old niece. The gSuite tech acted as if he had no knowledge of a Pixelbook. I had to explain several times it was a product of his own company. Even going down the Chromebook route didn't help. He could simply point to turning on a feature that was already set. Otherwise, I would have to call the Pixelbook Support.

I have called into office 365 support for many issues. Sometimes the issue went beyond the scope of what the tech should have helped for their own silo, but they still were able to spend 30 to 60 minutes on the phone to solve the issue with great patience and product knowledge.

After the sale support many times goes unnoticed or untested.  When evaluating a service or software, I will call in…
2
LVL 55

Author Comment

by:Scott Fell, EE MVE
Thanks for the nudge Andrew.  Perhaps I will do just that.
0
LVL 19

Expert Comment

by:Andrew Leniart
Please do Scott. I'll be more than happy to edit and get it published for you.

I think a lot of people may benefit from your experiences, and it may just be the push Google needs to provide some decent support.
0
I came across the issue discussed in this article https://www.experts-exchange.com/questions/29026898/outlook-email-not-working.html and what I did,  from control panal/uninstall progrem I selected office. clicked on change [not uninstall] and choose repair, this solved the issue
0

Microsoft Patch Tuesday December 2017 updates


Microsoft Patch Tuesday December 2017 is here, with a list of 34 critical security updates & 2 key fixes, for 7 products. Since the vacation isn't two far, make sure all the patches are updated in your network and have a happy vacation. Adobe also has released its security update

Key fixes:

  1. CVE-2017-11940
  2. CVE-2017-11937

Adobe:

APSB17-42

Potential impact for 34 security updates:

  • Remote code execution
  • Elevation of privilege
  • Information disclosure
  • Spoofing
  • Security feature bypass

Products:

  • Microsoft Exchange Server
  • ChakraCore
  • Microsoft Windows
  • Microsoft Edge
  • Internet Explorer
  • Microsoft Malware Protection Engine
  • Microsoft Office Services and Web Apps
  • Microsoft Office

You can read a complete report on https://goo.gl/mwbq1Q
1
Google just kickstarted the augmented reality stickers war - if you have a Pixel phone start sending AR stickers of Star Wars characters sitting in your office!

http://mashable.com/2017/12/11/google-launches-ar-stickers-pixel-phones/#pYlFdfU_nPqL
1
Excel cannot open the file because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. DDPE/Windows 10/ Office 2016
0
LVL 26

Expert Comment

by:Brian B
You have entered this as a post, but it looks like you are asking for help. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the page, or this link: https://www.experts-exchange.com/askQuestion.jsp

If you do ask a question, please post the link to it back here so others can find your question and help you more quickly.

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
I was just at a conference on Business Email Compromise (BEC).  various ISACs, Symantec, the FBI and the CIA presented.  It was very informative and here are a few things that were mentioned

  • Watch out for fraudulent scams involving IRS returns
  • Put 2FA in place everywhere you can and put a 2 factor policy in place for wire transfers
  • If you believe your GMAIL account may have been compromised, or just wish to keep an eye on it, there is a link on the bottom of the page to see the last 10 logins (although I don't see this in inbox, maybe it is only in gmail).
  • Set your out of Office messages to be internal only - or force this using rules
  • Use something like
  • DMARC

These were just some of the points made, but they were good ones.
2
This is a copy of part of the article located here:
http://www.tomshardware.com/news/how-to-fight-fcc-net-neutrality,36017.html

net neutrality
vote takes place 12/14/17:


Even so, it is the work of but a moment, so we all may as well do it. Go to www.fcc.gov/ecfs/filings/express, and under Proceeding, enter 17-108 (the dystopian-named “Restoring Internet Freedom” order). Fill in the form very, very, very carefully, ensure you get an email confirmation, and submit.

Your voice will be louder, as it were, with a phone call. Call the FCC and leave a message letting the agency know that you want to keep net neutrality as it is. Dial 1-888-225-5322, and be polite, patient, and persistent. You want Option 1, Option 4, Option 2, Option 0. Enter a complaint on proceeding 17-108.

Here’s a sample script: “Hi, my name is ___, and I live in [city], [state]. I’m registering a complaint about the proposed repeal of net neutrality, because it will hurt American consumers, reduce internet access, and restrict the open flow of information. I strongly oppose the undoing of net neutrality, which is at the core of proceeding 17-108. Thank you.”

Then call your members of Congress. The FCC commission is appointed and makes these decisions, but Congress can pressure the agency to do the right thing, and it can also put forward legislation to make net neutrality law instead of just policy. Find your congresscritter at https://contactingcongress.org/, and call the local office …
1
Introducing Cloud Class® training courses
LVL 12
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Announces the release of Kernel Migrator for Exchange

Kernel Data Recovery announces the release of Kernel Migrator for Exchange, a complete solution for Exchange/Office 365 migrations. As per the company sources, the tool can perform a swift migration of mailboxes from Exchange/Office 365 to another Exchange or Office 365. The tool can also be used for public folder migration. This tool works with on-premises, hosted, hybrid, & cloud Exchange deployments for both intra-forest and cross-forest migrations. This tool is unique in many ways as it has features for pre-migration analysis, real-time alerts, web console based reports, and post-migration co-existence between the source & destination environments. The company describes it as an in-house migration solution for all Exchange administrators.
0
USB Microscope Comes in Handy
I considered making this an article, but this seemed to be the better way to do this.

The intro image  shows a USB microscope (~$30.00) and one of the pictures it took.  It is especially interesting because I didn't really think this would be of much use.  I just liked the idea of it.  I had the "toy" sitting in my office for only 4 days before I really needed to use it.  One of my users came to me with a MacBook Pro that no longer started, at all.  Under normal circumstances, meaning if it was a windows based computer, I would take it apart and see what the problem was.  There was a problem with that.  Since it was a MAC computer, I didn't have the correct wrench to unscrew the chassis.  I took my USB microscope, pictured above, and took a picture of the screw hole, also pictured, which I then sent out to my colleagues within the institution (a medical college) to see if anyone had a screwdriver to fit this screw.  


It took about 2 hours before I received a response that someone indeed did have the correct tool and would either be willing to lend it to me or do the job themselves.  
1
LVL 64

Expert Comment

by:☠ MASQ ☠
I so hope it wasn't someone in orthopaedics and you had to send it back to be resterilised afterwards! :)
0
LVL 31

Author Comment

by:Thomas Zucker-Scharff
Nope. :-)
0
0
Hi Friends,

Just a short note to explain why those of you who have been following me may be curious as to why I suddenly disappeared from EE all of a sudden and apparently started ignoring all of your messages for the last couple of months.

Without going into too much detail, I've basically been in and out of hospital with a rather serious condition. My last stint in hospital was 4 1/2 weeks and I'm finally now home again on a "Hospital in the Home" program where district nurses regularly visit my home and I go back into the hospital once a week for doctors reviews.

The situation I'm in isn't about to change real soon, but I'm confident I'll beat it eventually  :-)

So that's my story gang.. My apologies for the lack of replies and if I do seem to disappear, please know it has nothing to do with Experts Exchange forums, which I continue to thoroughly enjoy.

Best..

Andrew
3
LVL 104

Expert Comment

by:John
I continue to wish you well and think of you every time someone posts in here. I hope that the outcome is now brighter for you.
1

Expert Comment

by:Jerry D.
Sending you positive thoughts and best wishes. Be well!!
1
Skype-a-ThonSkype-a-Thon is a global learning event that makes it possible for students to virtually travel around the world and connect beyond the classroom.
Join us this year — on November 28-29 — as we aim to travel 10 million virtual miles to make new friends, open hearts and open minds in order to create a kinder, more compassionate world!  
https://education.microsoft.com/skypeathon

Have a look at Microsoft Education website, there are many free courses and you can have more fun there. I am sure you can gain more with Microsoft as they are really generous and you do not need to be a Premium Member to attend any course.
0
Passed the 70-347 exam yesterday, earning me the MCSA for Office 365.

The 70-347 is definitely the most difficult exam that I've done in recent years.

MCSA
6
LVL 22

Author Comment

by:David Atkin
Thanks MAS :D
0

Expert Comment

by:AYODELE ADEGOKE
Congrats David.

Kindly share materials used to ag.adegoke04@gmail.com. I will really appreciate.
0

Microsoft Office

64K

Solutions

41K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.