Microsoft Office

69K

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.

How to create a "CatchAll" mailbox account using a Shared O365 mailbox and a "Dynamic Distribution Lists" to exclude the internal results.
0
The block of six octets of a MAC address represents a lot of challenges when it comes to reading, formatting, parsing, validation, and lookup of vendor information. The functions presented here let you read, generate, format, store, list, and report MAC addresses and derived BSSIDs for most tasks.
3
This article addresses the need, sometimes extreme, for a legend that may not be easy to create, depending on the features of conditional formatting you have used. Almost all spreadsheets need some sort of legend.
1
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order. But how to rank dupes? Five methods exist, and they can all be implemented in pure SQL or using VBA.
2
Using a Vlookup with one of Excel's random number functions to create randomized columns of data from pre-defined lists.
1
As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcatRelated and similar functions. Further, it offers better read-out of Multi-Value fields.
1
LVL 61

Author Comment

by:Gustav Brock
crystal, if you are interested in other examples using a collection as cache, you can study my RowNumber function here:

Sequential Rows in Microsoft Access
1
LVL 25
thank you, Gustav, I will ... saved the link to look at later ~
0
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
Learn about Power Excel add-ons and how to use them. Power Pivot. Get and transform (Power Query).Power View.3D Map (Power Map).Extra Power BI.Power summary video (Spanish)
0
LVL 3

Author Comment

by:►Yolanda Cuesta Excel Contabilidad TIC
Hi Andrew, thanks a lot for your help, I think that the article is much better now.
Best,
Yolanda Cuesta
0
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
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.
2
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!
2
LVL 63

Expert Comment

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

Author Comment

by:Thomas Zucker-Scharff
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.
2
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 7

Administrative Comment

by:Stacy Richard
Published for Nicole
1
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
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.
2
A quick guide on adding multiple SMTP proxy addresses to Users for Office 365
0
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
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
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
Great work!
1
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
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

Microsoft Office

69K

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.