Microsoft Office

67K

Solutions

42K

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

Rename the worksheets
Excel is a great tool for business and we use it very often in our daily jobs. Sometimes we have been inherited a spreadsheet with a lot of data in which it makes us difficult to search such info. In this case, we need to think of a way to find or tag our data.
0
Ensure Business Longevity with As-A-Service
Ensure Business Longevity with As-A-Service

Using the as-a-service approach for your business model allows you to grow your revenue stream with new practice areas, without forcing you to part ways with existing clients just because they don’t fit the mold of your new service offerings.

Microsoft Office 365 Security
Today we are going to make Microsoft clients aware of tricks and tips used by Cybercriminals to bypass Microsoft Office 365 tenants. Read this post carefully to help you achieve an unbreakable security level in your Exchange Online accounts.
2
Summary of Bill Paying Spreadsheet
How to use a bill paying spreadsheet created by yours truly. Also a little background. The download is available towards the bottom of the article and is named Pay-Bills.xltm. Feel free to use, or, as you wish. Provided as is.
1
Dropdown lists in Excel
Do you want to increase the data integrity of your Excel worksheets? Do you input something repeatedly? Would it be handy to pick the item from a predetermined (by you) list? READ ON!
1
LVL 58

Expert Comment

by:Martin Liss
Comment Utility
I don't mean to be argumentative but can you explain your reasoning?
0
LVL 32

Author Comment

by:Thomas Zucker-Scharff
Comment Utility
Sure. The purpose of a database is to enter data once and have it displayed in many different ways and also relate that data to other areas of the relationship db (using tables and queries).  When you use a dropdown list in excel, you are basically using it like a simple database.   Di why not use a db like access? It is as easy to use as excel.
1
Deploying a Microsoft Access application in a normal Windows environment is not difficult but takes a few steps. The method and script provided here will - literally - turn the process into a one-click process for the user, even in a Citrix environment.
1
For years I have used Outlook and managed my email with hundreds of rules, Here is how I have started to manage the rules.
0
Having trouble Moving from MS Exchange server 2003 to Office 365? Read from this article to get a detailed overview of the whole migration process using different methods.
1
Enroll in these five web development courses: RESTful Services: Data, JAX-RS and Jersey, RESTful Services: Fundamentals, Selenium Fundamentals, Bootstrap 3.1: Fundamentals, and Perl Fundamentals. Then learn to perform data analysis in Microsoft Excel to measure your success.
1
LVL 5

Administrative Comment

by:Stacy Richard
Comment Utility
Published for Nicole
0
Recover Exchange Mailbox from Public EDB File
Now Recover Exchange Mailbox from Public EDB File (pub.edb) of 2010 / 2007 environment via Exchange Recovery Tools. Also, recover public folder mailbox Exchange 2013 / 2016 & restore into Exchange Server again details such as emails, contacts details and Calendar details.
0
Repair Corrupt Outlook PST file
Does your PST file get corrupted? Looking for a solution to quick fix corrupt PST file of Outlook 2016, 2013, 2010, 2007? Read this post to learn about some tips & tricks to repair corrupt PST file in Outlook.
0
Python 3 Fundamentals
LVL 13
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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
Add Additional SMTP Proxy Addresses
A quick guide on adding multiple SMTP proxy addresses to Users for Office 365
0
Google Maps Distance
Many applications need to compute the road distance between two addresses. Numerous websites perform this function, but to build this feature into your application, you must use an API to call these features via the internet. This article discusses how I did so by using Google Maps API and VBA.
1
backup Office 365 mailbox
In this article, we have come up with a step by step procedure to migrate Office 365 data to Zoho Mail using SysTools Office 365 Backup and Zoho Mail Migration Wizard.
0
Charts are easy to insert manually but sometimes we need to automate the chart insertion and most of the people find it difficult to control the chart creation and its properties via VBA In this article, we will learn about how we can use VBA to insert a Chart and manage its appearance.
10
LVL 1

Expert Comment

by:agwalsh
Comment Utility
I could see how this could be really useful if you were regularly entering charts - would save a lot of time :-)
1
LVL 4

Expert Comment

by:Skylar-Barlow
Comment Utility
Great work!
1
G Suite to O 365
Switching from G suite to Office 365? Here are the top 5 reasons you need know for G Suite to Office 365 migration, comparing all the possible factors of both Google Apps and Exchange Online.
0
Office 365 eDiscovery Export to PST Tool
Are you trying to export PST from Office 365 using the eDiscovery export tool but failed? Let’s try an alternate solution to export Office 365 mailbox to PST format without using eDiscovery. You will get Office 365 data into PST format in just a few clicks using the Office 365 Export Tool.
0
How many times have you tried using Office InterOp to manage various custom properties? If you have ever tried it then you will see the article image very appropriate. After spending hours trying to solve a question I finally gave up on Office InterOp and took an easier way out - OpenXML SDK.
0
Summary: The article lists the effective methods on how to deal with Outlook PST File Locked By another Process error. Read on to learn the important ways to resolve.
0
CompTIA Security+
LVL 13
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.

Benefits of Office 365
Know the 5 most critical benefits of Microsoft Office 365 Exchange online for business, enterprise, education, and students. Also, be aware of Office 365 Challenges and how to backup data safely.
0
While it's a fact that PST file corruption is the root cause of a majority of Outlook errors, in this post we’ve listed all the signs that can help you make sure if the real reason behind your troubled Outlook is a corrupted PST.
1
If you're a Microsoft Exchange Administrator then you surely know what is OST and PST and must have worked in an environment where you had to deal with both OST and PST.
1
Migrate Outlook PST to Office 356 Cloud
Are you among those users who need to move email from Outlook to Office 365 or Exchange Online? Are you facing an issue in importing Outlook PST files or does not have an idea how to migrate PST file to Office 365? Then you will get an exact solution for all the queries in this blog.
0
LVL 12

Expert Comment

by:Senior IT System Engineer
Comment Utility
Hi,
Is it possible to import the .PST directly into the Users Archived mailbox so it doesn't counted towards the quota ?
0
LVL 12

Author Comment

by:Clark Kent
Comment Utility
Yes, it is possible by Office365Import Tool. For more info: https://www.office365import.com/
0
Migrate Outlook PST to Office 356 Cloud
Know how to migrate Outlook PST files to Office 365 Exchange Online using Microsoft Azure AzCopy tool. Simply, you have to download Azure AzCopy tool and use Office 365 Import service to move Outlook PST to Office 365 webmail by Network upload manually.
0

Expert Comment

by:Rods
Comment Utility
I wonder if there is any import of .PST can be performed via azcopy?
0
Office 365 Mailbox Backup and Restore
This article covers the things you should know about Email backup in Office 365. Backing up emails is the most crucial part that generally neglected by users.
0

Microsoft Office

67K

Solutions

42K

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.