Collaborate Disseminate
Microsoft Excel is a program that is used worldwide by many people to do calculations and store data, but did you know that you can change the cell background with VBA Editor in Excel instead of using the Fill color feature or the Conditional Formattin… Continue reading Change Cell Background Color in Excel with VBA Editor
The Draw tab in Office allows users to make drawings in documents or slides. The Draw tab in PowerPoint allows you to make sketches with pen, pencil, and highlighters; it also has features to convert shapes, text, and math numbers and symbols to ink; i… Continue reading How to use Draw tab in PowerPoint to draw on slides during a presentation
Did you know that you can use the VBA editor in Excel to navigate your worksheets by using the command button, which is a content control button? Content controls are individual controls that you can add and customize for use in templates, forms, and d… Continue reading How to navigate between Excel worksheets using Command button
Microsoft Excel is a program known to be advanced in creating charts, you can use predefined charts or create your own Excel charts for your presentation, but did you know that you can add a crayon effect to your charts to make them look like a sketch?… Continue reading How to create a Chart with Crayon effect in Excel
Bullets are black circle points but can also be any symbols you can use to highlight items in your list. Bullets can be alphabet letters and numbers, but did you know you can use the CHAR function to add bullets in an Excel spreadsheet? Functions in Ex… Continue reading How to create Bulleted List using CHAR function in Excel
A hyperlink is an HTML element that provides a link to a different location. A person can create a hyperlink to link to different documents, emails, and Websites. In Microsoft Excel, PowerPoint and Word, users can create hyperlinks anywhere on their sp… Continue reading How to modify Hyperlinks in Excel, Word and PowerPoint
Functions in Microsoft Excel are very important to users; it helps users perform calculations from basic to advance. Persons across the globe use Excel in Accounting, Engineering, and Marketing for the things it can do. Microsoft Excel also helps users… Continue reading How to use the EXP function in Microsoft Excel
Microsoft Word is a program used by many across the globe for its features to type and edit documents and even to do some small photo editing to create photos or bookmarks. In some cases, users would use Microsoft Word to mirror their text. In this tut… Continue reading How to reverse or mirror Text in Word
A Shape is a graphical representation of an object. In Microsoft Office programs, such as Word, PowerPoint, Excel, Publisher, and OneNote, people can use shapes to form an image. They also contain features to color the shapes and their outlines or even… Continue reading How to add Shapes in OneNote
The Excel GCD function is a Math and Trigonometry function, and its purpose is to return the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number 1 and number 2 without a remainder… Continue reading How to use Excel GCD function