Back to Top

Tech, Web, Cloud & Cabling Services

Author Archives: Website Admin

iPhone 7: What business users need to know

Apple recently announced the latest version of its flagship smartphone. Here are the features and functions that will matter to professionals.

iphone7lineup

The iPhone 7 is officially here. At an Apple event in California on Wednesday (September 7, coincidentally), the phone was unveiled by Tim Cook and the crew amid a variety of Apple announcements.

The first mention of the new device came in a now-deleted tweet that read: “New cameras. Water-resistant. Stereo speakers. Longer battery life. This is 7.” Apple is known for being tight-lipped until the last possible second, so it was definitely a surprise.

The phone has a new design, featuring an aluminum body with almost non-existent seams and is available in gold, silver, rose gold, black, and Jet Black. The home button was also redesigned, with Force sensitivity and a new Taptic engine. It can also be programmed by third-party applications and customized as well.

The above tweet wasn’t a fluke. The new enclosure is both water and dust resistant, with IP67 protection standard.

The new, 12-megapixel iPhone 7 camera has image stabilization and a wider f1.8 aperture lens that is made up of six distinct layers. The sensor for the camera is faster and more efficient, and a quad-LED flash can help users take better photos. The iPhone 7+ gets a second 12MP camera to use as a telephoto lens.

A new image processor helps balance colors and tone in an image, among many other features. This could be helpful for small marketing departments, or businesses that rely on image content, to produce better photos.

The front camera is a 7MP FaceTime HD camera. This will be helpful for road warriors and remote workers alike, as it could provide a better experience for mobile video conferencing.

The new Retina HD display is now 25% brighter than previous generations. The iPhone 7 has stereo speakers with twice the volume and better quality sound. If you want to use headphones, the traditional auxiliary input jack is gone, and the Apple EarPods now connect via Lightning connector only. If you have traditional headphones, though, Apple will include an adapter in the box with the new iPhone 7 and 7+.

Apple also debuted a wireless version of its earbuds called AirPods. They use a W1 chip to enable “intelligent connection” and users can access Siri through the AirPods with a tap. The batteries provide five hours of listening per charge.

In terms of performance, the iPhone 7 has a new A10 Fusion 64-bit, four core processor. Using two high-efficient cores, tasks like checking email will take less battery power. It also has stronger graphics performance while consuming less power than previous models. Pro apps, like those from Adobe, can perform better on the device as well.

Storage-wise, the new iPhones will be available with 32GB, 128GB, or 256GB of space.

apple_watch_series_2

Apple also announced the Apple Watch Series 2. The watch is swim-proof, which is a fancy way of saying that it is water resistant up to 50 meters. Its second-generation SiP (system in a package) has a dual-core processor that’s up to 50% faster, and a stronger GPU for better graphics performance as well.

A new display is easier to read, and the more powerful hardware allows for more complex apps to be built for the device. Built-in GPS will be good for business travelers, and developers can take advantage of it to build more contextual apps. Of course, watchOS 3 came to preview back in June, but Apple was expected to bring a new version of the hardware for quite some time.

Real-time collaboration is coming to the iWork suite as well. Apple showcased the functionality by editing the slide deck live on stage. Of course, Google Docs and Office 365 have had similar functionality for some time, and iWork has struggled to gain traction in the enterprise, but it’s a welcome update.

Have questions?

Get answers from Microsofts Cloud Solutions Partner!
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LL C is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

Microsoft Surface Studio: The smart person’s guide

Everything you need to know about the Surface Studio, Microsoft’s new all-in-one PC designed to tempt professional artists and designers over to Windows.

microsoft-surface-studio

The Surface Studio is an all-in-one PC with premium specs, designed to wow professional artists, designers, architects and other creatives.

While the $2,999 price tag will deter most consumers, Microsoft seems to be targeting the Studio at design professionals, who would otherwise be using Apple Macs alongside specialist devices like Wacom’s Cintiq drawing tablet.

The Studio is a machine with a lot to recommend it, but one that could still be a leap too far for creatives already heavily invested in alternative tech.

Executive summary

  • What it is: The Surface Studio is a high-end, all-in-one PC aimed at being a drafting table and canvas for creatives.
  • Why it matters: The machine marks Microsoft’s first venture into designing desktop PCs and may put pressure on Apple and other manufacturers to crank up specs on competing machines.
  • Who it is for: Artists, designers, architects — creative professionals who want a machine that shows off their work at its best.
  • Why you should get it: For its super sleek, razor-sharp display that lets users draw straight onto the screen.
  • Why you shouldn’t get it: The price is too high or you’re a professional already heavily invested in alternative software and hardware.
  • How to get it: Pre-order online, although stock is limited according to Microsoft

What it is

An all-in-one, Windows 10 PC designed to dazzle users with its superlative display.

The screen, a 28-inch touchscreen LCD monitor, is ‘the thinnest in the world’ according to Microsoft, and sits on a counterbalanced hinge that makes it easy to push down onto the desk, and start drawing on with a digital pen.

The monitor’s 4K+ resolution and ability to display more than one billion colors, as well as to show drawings and documents at 1:1 scale with their paper equivalents, is designed to give professionals the ability to see how their creations would look in the real world.

Sketching on the screen with the Surface Pen is made easier when the Studio is used with the newly released Surface Dial, a brushed silver knob that can be rotated to select a new color when drawing on the screen or to turn the image.

Why it matters

From the point of view of artists and designers, the Studio offers a high-end computer built around their creative needs, which does away with having to use a separate drawing tablet and computer.

Even if creatives ignore the Surface Studio, its release is good news, likely to prompt incumbents like Apple and Wacom to spec up and cut the prices of new machines — in particular for the iMac, which the Studio has been compared to many times, despite the iMac lacking a touchscreen.

By following up the immaculately designed Surface Book laptop with a striking machine like the Surface Studio, Microsoft also appears to be trying to establish itself as a competitor to Apple on the design front.

Who it is for

Broadly, the Studio seems to be aimed at anyone who draws or designs for a living.

In launch videos, the Studio was seen being used by artists, architects and product designers.

The multi-purpose nature of the Studio, a machine that combines a Windows desktop PC with the functionality of a separate digital drawing tablet, such as the Cintiq 27 QHD Touch, will likely make the $2,999 price tag easier to swallow among those in the creative industries.

Why you should get it

If you draw or design for a living there are plenty of reasons why you might want the Studio. For example, there’s the quality of the display and the ease with which the Surface Pen draws on the screen. Microsoft describes this experience as virtually as fluid as drawing on paper. Then there’s the Studio’s significant graphical processing power, the ability to view documents and drawings actual size on screen and the ease with which you can switch push down the monitor and begin drawing.

Why you shouldn’t get it

Despite the Studio’s looks, its high price makes it hard to recommend as a consumer purchase, particularly when an iMac with a higher resolution, and only very slightly smaller screen, will cost less money.

Even professional creators are unlikely to abandon their current expensive setup for a Studio, as Mikako Kitagawa, principal research analyst with Gartner, pointed out.

“An all-in-one device is not the most cost-effective device, as the users pay for both the computing unit and monitor at the same time,” she said.

“Creative professionals have already invested heavily in hardware and software. For instance, many professional illustrators use a high-end drawing tablet and high-resolution monitor at the same time.”

If those same professionals exclusively use macOS, as is the case in some creative outlets, then the high cost of switching to Windows will also be a deterrent, she said.

There is also Microsoft’s odd decision not to include the $99 Surface Dial with the Studio, despite the peripheral featuring so heavily in demos of the machine, and being particularly useful for tasks like changing colors while drawing with the Surface Pen.

How to get it

The Surface Studio is available to pre-order from Microsoft, with prices starting at $2,999 and shipping starting from 12 December. Microsoft has warned the machine will be available in limited quantities.

Tech specs:

$2,999: 1TB drive; Intel Core i5 CPU; 8GB RAM; 2GB GPU

$3,499: 1TB drive; Intel Core i7 CPU; 16GB RAM; 2GB GPU

$4,199: 2TB drive; Intel Core i7 CPU; 32GB RAM; 4GB GPU

Display: 28″ PixelSense Display; 4500 x 3000 resolution; 192 DPI; Color settings: Adobe sRGB, DCI-P3 and Vivid Color Profiles; Touch: 10-point multi-touch; Aspect ratio: 3:2 TB drive; Intel Core i5 CPU; 8GB RAM; 2GB GPU

Processor: Quad-core 6th Gen Intel Core i5 or i7

Graphics: NVIDIA GeForce GTX 965M 2GB GPU GDDR5 memory or NVIDIA GeForce GTX 980M 4GB GPU GDDR5 memory

Storage: 1TB or 2TB ‘rapid hybrid drive’

Memory: 8GB, 16GB, or 32GB RAM

Wireless: 802.11ac Wi-Fi; Bluetooth 4.0; Xbox Wireless built-in3

Dimensions: Display: 25.09 x 17.27 x 0.44 in (637.35 x 438.90 x 11.4 mm); Base: 9.84 x 8.66 x 1.26 in (250.00 x 220.00 x 32.20 mm)

Weight: 21.07 lbs max (9.56 kg)

Connections: 4 USB 3.0; Full-size SD card reader (SDXC compatible); Mini Displayport; 3.5mm headset jack; Compatible with Surface Dial onscreen interaction

Cameras: 5.0MP front-facing camera with 1080p HD video

Audio: Dual microphones; Stereo 2.1 speakers with Dolby Audio Premium

Buttons: Volume and power

Surface Pen

Surface Keyboard

Surface Mouse

Power cord with grip-release cable

Security: TPM chip for enterprise security; Enterprise-grade protection with Windows Hello face sign-in

Have questions?

Get answers from Microsofts Cloud Solutions Partner!
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LL C is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

APPLE WARNS OF WI-FI HACK: Could wipe out iPhones, issues fix

If you use Wi-Fi on your iOS device, get this security update

The tech giant says there is a new cyber threat, but has taken steps to thwart the attack.  According to the reports, “Apple has now issued a critical security patch for all iOS devices and for Mac computers against a potential hack that could come remotely via Wi-Fi.”


The virus is being considered a potentially serious threat, so the company is urging users to install the updates to protect their devices.

The latest cyber threat is also a risk to Android device users, but Google has taken steps as well to block the virus.

“The vulnerability also has the potential to attack Android devices, but Google issued its own security patch earlier this month.”

Have questions?

Get answers from Microsofts Cloud Solutions Partner!
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LL C is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

Microsoft Office 2016: Lots of upgrade questions and some answers

Microsoft began rolling out Office 2016 for Windows on September 22. Since then, there have been a lot of questions around timing and installation techniques from those attempting to move to the latest version of Microsoft’s Office suite.

Office 2016

It turns out that not everyone has been able to upgrade to the latest release this week, in spite of Microsoft declaring the suite generally available. Instead, as many have discovered, the Office 2016 rollout is a staggered one, and one which has resulted in some OneDrive, Skype for Business and other app and service installation and compatibility issues.

While Microsoft officials did say a week ago that the company would be moving to a servicing/branch model with Office 2016 similar to the one the Windows 10 team is using, details on exactly how that would play out for Office users were scarce. But thanks to Microsoft pages and KB articles — we now know more.

Office 2016

It turns out anyone in the Office 365 First Release program was able to get the latest Office 2016 apps for Windows as of this week. The same is true of those on the existing Office 365 Small Business Premium, Business and/or Business Premium — but only for those who are buying new subscriptions, according to the chart from a Microsoft community answers post, embedded above. Automatic updates to Office 2016 for those on these three plans won’t begin until the fourth quarter of 2016..

Just to add a little more complexity to this already complex set of rules, Microsoft is in the midst of replacing its Office 365 Small Business, Small Business Premium and Midsize Busines plans with three new ones. The three: Office 365 Business, Business Essentials and Business Premium. Microsoft has pushed the suggested migration date kick-off for these new plans back from October 1 to December 1, 2015, The reason for the date change: “The renewal experience will be best for users who have the latest version of Office,” meaning Office 2016.

Those with Office 365 ProPlus SKUs — meaning Office 365 Enterprise, Midsize and Education — are on the Current Branch for Business. This means these users cannot upgrade to the new Office 2016 for Windows bits right now unless the administrators change the update branch to be used by some/all of their users to Current Branch.

“For Office 365 ProPlus subscribers, administrators can opt to upgrade by manually rolling out to their users with Office deployment tools available today, September 22. Automatic updates for Office 365 ProPlus customers will begin early next year,” a Microsoft spokesperson confirmed when I asked.

Here are some more links that might help those interested in making the move to Office 2016:

Microsoft made the Office 2016 for Windows release available to MSDN subscribers on September 22. Volume licensees will have access to the new release via the Volume License Servicing Center (VLSC) as of October 1.

DreamSpark users got access to Office 2016 on September 22. Microsoft Action Pack and MPN subscribers will get access on October 1. And Home Use Rights for Office 2016 for Windows and Mac, both, will be available as of October 7, according to Microsoft.

Have questions?

Get help from IT Experts/Microsofts Cloud Solutions Partner
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LLC is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

New Website Design – West Bay Construction, Inc.

The Website Design team of South Jersey Techies has been constantly working on developing great looking websites using the latest web technologies. The most recent website developed by our team is for West Bay Construction, Inc. located in Linwood, New Jersey. West Bay Construction, Inc. is a general contractor headquartered in beautiful Southern New Jersey. They have been providing prompt and professional contracting services to state, federal and local authorities for over 20 years. They are qualified to perform work at the State level for the NJDOT, NJ Turnpike Authority and NJ Transit. Additionally, they also perform work for the local counties, as well as municipal levels including work for local Boards of Education.

 

 

 

Have questions?

 

Our Web Design team is here to help. Call us at: 856-745-9990 or visit: https://southjerseytechies.net.

 

South Jersey Techies, LLC is a full Managed Web and IT Services Company located in Marlton, NJ providing IT Services, Managed IT Services, Website Design Services, Server Support, IT Consulting, VoIP Phones, Cloud Solutions Provider and much more. Contact Us Today.

IBM Watson is coming to the iPhone, and that’s big news for business users

Last Tuesday, IBM announced it will be combining its enterprise iOS mobile apps with IBM Watson for better decision-making and productivity.

watson

IBM Watson may be coming soon to an enterprise iOS app near you, the company announced at the IBM World of Watson 2016 event on October 25. In a first-of-its-kind move, IBM MobileFirst for iOS apps can now integrate Watson technology to enhance decision-making, productivity, and the employee experience.

With Watson’s cognitive and conversational capabilities, these enterprise apps will be able to understand, reason, and learn using data analytics, according to a press release.

“Apple and IBM set out more than two years ago to define the enterprise mobility market, ensuring that professionals could finally enjoy at work the same experience they’d come to expect as consumers,” said Mahmoud Naghshineh, general manager, Apple partnership at IBM, in a press release. “We are taking that to a whole new level by combining the power of Watson with the new speech framework of iOS 10. The combinations and possibilities are virtually endless.”

Watson is available for both IBM MobileFirst for iOS apps, as well as custom-built iOS apps from IBM, and will allow business users to integrate APIs based on their needs. Users will also have the ability to control apps with speech. This feature could be especially helpful for positions such as field technicians, who can verbally interact with an app like Find & Fix—inputting schedule changes, notifying dispatch, asking questions and tapping Watson’s knowledge reserves—while repairing equipment, according to the release.

“IBM Natural Language Processing, Watson Conversation and other Watson APIs have been optimized to work with the new iOS 10 speech framework,” the press release stated. “The combination of Watson, iOS and IBM services allows the apps to support conversational interaction, bringing deep insight to the end user so they can make more informed decisions.”

The new capabilities will be delivered through IBM Cloud for easy integration into apps, even those that are already in use in a business, the release stated.

IBM offered the following examples of how enterprises might use apps integrated with Watson:

  • Flight attendants using the Passenger+ app enhanced with Watson can gain a deeper view into a traveler’s personality to deliver more personal and relevant customer care while inflight. For example, if the app reveals a passenger is a strong brand advocate with a strong social footprint, the airline may choose to prioritize his or her requests.
  • Retail sales associates using Sales Assist can access data across different resources—social media, customer databases and product forums—for deeper insights into a customer’s unique preferences as well as the latest purchasing trends and popular products to assist customers in choosing the right item.
  • Financial advisors using Trusted Advice with deep learning technology from Watson gain highly targeted search and trend analysis into market history and happenings to optimize the investment recommendations made to individual clients.

“This is a digital assistant for the business—one that creates the next-generation professional experience tailored for enterprise processes,” Naghshineh said in the press release.

The partnership with Watson furthers Apple’s recent moves to increase business appeal. In recent years, Apple has inked deals with IBM, Cisco, SAP, and Deloitte to integrate iOS devices into the enterprise.

IBM is perhaps Apple’s highest-profile corporate partner, representing the world’s largest enterprise Mac deployment, with over 90,000 Macs currently used by workers. The company recently reported that it is rolling out Macs to employees at a rate of 1,300 per week—putting it on track to cross the 100,000 machine mark by the end of the year, as Jason Hiner reported.

The IBM Watson iOS integration also demonstrates how important cognitive computing and AI will be to the future of mobile, with the rise of specialized AI assistants in a variety of industries, and the release of the Google Pixel phone, enabled with Google Assistant.

The 3 big takeaways for readers

  1. IBM Watson will now power enterprise iOS apps with its cognitive and speech capabilities, the company announced at the IBM World of Watson event on Tuesday.
  2. Tapping Watson’s information reserves and language capabilities could help professionals in a variety of fields increase productivity and decision-making, the company stated.
  3. Integrating Watson into enterprise iOS apps is another move by Apple to increase its business use, following previous app partnerships with IBM, Cisco, SAP, and Deloitte.

Have questions?

Get answers from Microsofts Cloud Solutions Partner!
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LL C is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

New Website Design – Devikon Group, LLC

Developed by,
South Jersey Techies, LLC.

The Web Design team of South Jersey Techies has been constantly working on developing the best websites including easy mobile approach and the latest website developed by the team is Devikon Group, LLC.  At Devikon Custom Contracting, we’ve built our livelihoods on remodeling people’s homes. From the simple to the lavish, we’ve experienced it all and we can help you every step of the way. No job is too small or too big for our knowledgeable crews.

Devikon Group, LLC

Have questions?

Our Web Design team is here to help
Call us at: 856-745-9990 or visit: https://www.sjtechies.com

South Jersey Techies, LLC is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

 

Change the Processor Affinity setting in Windows 7 to gain a performance edge

Under specific circumstances and with careful tweaking, you can increase Windows 7’s performance using the Processor Affinity setting.

If you have a multi-core processor, chances are good that on the Performance tab in Windows Task Manager, you have noticed that the CPU Usage History graphs look about the same for each core, as shown in Figure A. The reason for this is that most applications you run these days have been designed with multi-core processors in mind and will work with the operating system to distribute their operations as evenly as possible across all the available cores.

Figure A

In most cases, you’ll notice that the CPU Usage History graphs look about the same for each core.

In most cases this even distribution provides you with the best performance possible. However, that’s not always going to be the case. For instance, older applications that were designed for single-core processors can behave irrationally — they may all of a sudden begin maxing out the CPU usage at 100 percent and appear to be locked up. In other circumstances, you might be able to achieve better overall performance from certain applications by configuring each of them to run on different processor cores.

Fortunately, Windows 7 allows you to configure applications to use only one, or several, of the processor cores in a multi-core system by using the Processor Affinity setting.

In this edition of the Windows Desktop Report, Iwe’ll show you two ways to change the Processor Affinity setting in Windows 7.

From Task Manager

Changing the Processor Affinity setting from within Task Manager is a pretty straightforward operation once you know how to do it. To launch Task Manger, you can use the keystroke combination [Ctrl] + [Shift] + [Esc] or you can simply right-click on the taskbar and select Task Manager from the context menu.

Once Task Manager is up and running, select the Applications tab, right-click on the application that you want to work with, and select the Go to Process command, as shown in Figure B. When you get to the Processes tab, right-click on the process and from that context menu, select the Set Affinity command, as shown in Figure C. (If the processes are jumping around, it may be hard to select the correct process, so you might just want to press the Application key or [Shift]+[F10].)

Figure B

Right-click on an application and select the Go to Process command.

Figure C

Right-click on the process and select the Set Affinity command.

After you select the Set Affinity command, you’ll see the Processor Affinity dialog box shown in Figure D. As you can see, the default setting is All Processors, which in the case of my example system are CPU 0 and CPU 1. At this point, you can clear the All Processors check box and then select the CPU on which you want the process to run.

Figure D

The Processor Affinity dialog box allows you to choose which processor(s) you want to use.

An example

To take a look at the effects of using the Set Affinity command, we launched two applications: Microsoft Security Essentials and Disk Defragmenter. Next we used the Set Affinity command to assign Microsoft Security Essentials to CPU 0 and Disk Defragmenter to CPU 1. We then started each application running — Microsoft Security Essentials performing a full scan and Disk Defragmenter defragging a 500GB disk.

Once each application began working, they started sucking up CPU time, so we went to the Performance tab in Windows Task Manager to look at the CPU Usage History graphs. When we did, we could see that each graph was showing different measurements, as shown in Figure E.

Figure E

Each of the CPU Usage History graphs shows different measurements.

To specifically see how each CPU core was faring, we launched Resource Monitor and selected the CPU tab. Again, we could see that each CPU core was showing different usage measurements, as shown in Figure F.

Figure F

Resource Monitor’s CPU tab specifically identifies each CPU core and its usage.

Now, of course, my example combination is purely for the sake of showing each CPU handling a separate process. However, there are instances where running Microsoft Security Essentials on a separate CPU core would be beneficial.

From a shortcut

Now if you find that running an application on a specific CPU core works well, you might want to use it again in the future. If so, chances are that you won’t want to have to go through the Task Manager each time. Fortunately you can create a shortcut to launch an application with a specific affinity setting.

For example, to launch Disk Defragmenter so that it runs only on CPU 0, you would create a shortcut with the following command line:

C:\Windows\System32\cmd.exe /C start /affinity 1 dfrgui.exe

To launch Disk Defragmenter on CPU 1, you would create a shortcut with the following command line:

C:\Windows\System32\cmd.exe /C start /affinity 2 dfrgui.exe

The number that follows the start /affinity command is called the affinity mask and is defined as a hexadecimal number. However, the CPU core number can be calculated more easily using binary numbers. For instance, the command

C:\Windows\System32\cmd.exe /C start /affinity 3 dfrgui.exe

will launch Disk Defragmenter on both CPU 0 and CPU 1. If you convert 3 into a binary number you will get 0011. Under the affinity mask system, processors are numbered from the right to left beginning with 0 and since there are 1’s in the first two places, this indicates CPU 0 and CPU 1.

Suppose you have a Quad core processor. If so and you use an affinity mask of 4, that will convert into binary 0100, which indicates CPU 2. If you use an affinity mask of 9, that will convert into binary 1001, which indicates CPU 0 and CPU 3.

For more information on the start /affinity command, open a Command Prompt window and type the command

start /?

Have questions?

Get answers from Microsofts Cloud Solutions Partner!
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LL C is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

Office 365 gets Six new Excel Functions

Microsoft made several new updates to Office 365 in February, including the addition of six useful functions for Excel.

EcxelOffice365

When it comes to general updates to Microsoft Office 365, February 2016 was a fairly significant month. Microsoft rolled out numerous improvements to Office 365, like better pen annotation integration, the ability to pin documents to the Start menu, a new feature that allows images to be inserted into documents directly from the camera, and the best—adding more functions to Excel.

Six new functions

Using, combining, and creating formulas in Microsoft Excel is where true Excel gurus separate themselves from the pretenders and wannabes. For an Excel aficionado, the satisfaction of creating the perfect nested formula is second to none when it comes to Excel coding. So when Microsoft adds six new functions to Excel in one month it is a very big deal.

Of course, while there is great satisfaction when you figure out the perfect formula, a certain amount of despair also goes with it—because now you have to apply that complicated nested formula over and over again. This is where the six new functions are supposed to help.

The first updated functions are TEXTJOIN and CONCAT, and they are replacements for the old concatenate function, which gave the user the power to join strings of separate text into one cell. This comes up with addresses all the time—a common task for spreadsheets since they were invented.

In the past, the formula would look something like this:

=CONCATENATE(A3, “, “, B3, “, “, C3,”, “, D3, “, “, E3)

With the new TEXTJOIN formula, the same process would look something like this:

=TEXTJOIN(“, “, TRUE, A3:E3)

This is just one example of how these new functions are designed to simplify users’ lives when it comes to advanced Excel tasks.

The next two new functions are IFS and SWITCH, which provide an alternative to using the infamous series of nested IF functions. The old IF function was the mainstay for Excel coders looking to apply logic to sets of data. You know what I mean: If this is larger than this, than this; but if it is larger than this but less than that, then this, etc. The more nested IF functions the more complicated the formula and the more likely you are to make a mistake.

The last two new functions are MAXIFS and MINIFS. They are designed to supplement the MAX and MIN functions by allowing users to apply conditions to the maximum and minimum calculations and thereby filter results. In the past you may have had to use the IF function to create your filtered conditions. These new functions eliminate the need and make your life just that much simpler.

Office365

Bottom line

When Microsoft began trying to convince us that subscribing to Office 365 was a better idea than repurchasing new versions every few years, the ability to update the productivity suite regularly at no extra cost was one of the main selling points. As the new six functions illustrate, that was not a false promise.

These functions are just the tip of the iceberg when it comes to Office 365 improvements. However, the problem with continuous updates to the software is that users have to try to keep up.

Even though there are some users out there who will keep using nested IF functions no matter what improvements come along, for example. But for the rest of us, it would seem to be worthwhile to pay attention to whatever improvements Microsoft rolls out each month. Because for better or worse, changes to Office 365 are going to keep coming.

Have questions?

Get answers from Microsofts Cloud Solutions Partner!
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LL C is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

Yammer is on the way to Office 365: Are you ready?

Microsoft is activating Yammer for every Office 365 subscription. But is this one collaboration tool too many?

On February 2, 2016, Kirk Koenigsbauer announced in the official Microsoft Office 365 blog that Yammer is now being activated for every eligible Office 365 subscription. In a nutshell, that means Yammer is going to be another app on the Office 365 app list unless an admin specifically turns off access. Your enterprise should plan accordingly.

Yammer

For those of you unfamiliar with the product, Yammer bills itself as an enterprise internal social network. It mixes the typical chat messenger application with collaboration tools available in Office 365.

Similar to the Delve tool we looked at last week, Yammer can serve as the central hub for team collaboration. From within a Yammer discussion, teams can set up meeting appointments using Outlook, switch to a full-fledged Skype for Business video meeting, and access OneDrive for Business to create collaborative documents.

The initial rollout of Yammer took place on February 2, 2016; the rest of the rollout will take place in stages. The next release is March 1, 2016, and the last is April 1, 2016. According to the blog post, the first wave is for “Office 365 customers with a business subscription who purchased fewer than 150 licenses that includes Yammer and who have zero or one custom domains for Yammer.”

The second wave is for “Office 365 customers with a business subscription who purchased fewer than 5,000 licenses that includes Yammer.” Customers with an education subscription are not included.

The final wave is for “remaining customers with a business subscription and all customers with an education subscription.” For subscribers who have never had a Yammer account, the rollout will take place last, in April. Alas, that is the wave I’ll have to wait for.

Collaboration

Yammer is the latest, and perhaps the last, major teamwork collaboration app to be added to Office 365. In Microsoft’s vision of a mobile-first, cloud-first enterprise, teams collaborate across distances using shared documents, video conferencing, and applications that tie it all together in one virtual location.

YammerForOffice365

With the addition of Yammer, Microsoft is offering several tools teams can use to manage and organize their collaboration activities. Teams can use Yammer, Delve, Groups, Sites, SharePoint, and OneNote to manage their shared conversations and documents across the enterprise. One of those tools should be able to satisfy even the most persnickety of teams.

Bottom line

But then again, that may be where we run into problems. One could argue that there are too many collaboration tools available in Microsoft Office 365. While all these wonderful choices may seem good at first glance, it is possible that subscribers may become overwhelmed.

Microsoft’s idea that teams can choose the best tool for them or for the project they are working on sounds all well and good, but it does still require someone to make an important initial decision. For some people, making a decision that will affect a project from start to finish can be a daunting task.

In the long run, it may be beneficial for organizations to establish guidelines for when each of the collaboration tools works best. They may even decide to block some of the tools from use altogether in favor of a recommended best practice.

Having myriad collaboration tools is generally a good thing, but it might help move things along if the enterprise establishes some well thought out guidelines.

Have questions?

Get answers from Microsofts Cloud Solutions Partner!
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LL C is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

CALL US NOW!