Microsoft Office

68K

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

spreadsheet with rules
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.
0
Build an E-Commerce Site with Angular 5
LVL 13
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

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 60

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
Power Tools in Excel
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 2

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
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
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.
2
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!
2
LVL 61

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.
1
OWASP: Threats Fundamentals
LVL 13
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

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
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
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.
2
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
C++ 11 Fundamentals
LVL 13
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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
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
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

Microsoft Office

68K

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.