HomeDreamz Tech Welcome to Dreamz Tech! Microsoft Office How to create a fun Fly In effect in PowerPoint https://www.techrepublic.com/article/how-to-create-a-fun-fly-in-effect-in-powerpoint/ 7 tips for working more efficiently with PowerPoint shapes https://www.techrepublic.com/article/7-tips-for-working-more-efficiently-with-powerpoint-shapes/ How to zoom in on small details in PowerPoint https://www.techrepublic.com/article/how-to-zoom-in-on-small-details-in-powerpoint/ 4 Tips to Make You more Efficient in Powerpoint https://www.techrepublic.com/article/4-tips-to-make-you-more-efficient-in-powerpoint/ How to create 3D arrows in PowerPoint https://www.techrepublic.com/article/how-to-create-3d-arrows-in-powerpoint/ How to resize text and images together on a PowerPoint slide https://www.techrepublic.com/article/how-to-resize-text-and-images-together-on-a-powerpoint-slide/ How to use vector graphics to create cool custom graphics in PowerPoint https://www.techrepublic.com/article/how-to-use-vector-graphics-to-create-cool-custom-graphics-in-powerpoint/ How to access folders and files shared with you from OneDrive https://www.techrepublic.com/article/how-to-access-folders-and-files-shared-with-you-from-onedrive/ How to create a dual-color circle in PowerPoint https://www.techrepublic.com/article/how-to-create-a-dual-color-circle-in-powerpoint/ How to use VBA to repurpose a built-in command in Word and Excel https://www.techrepublic.com/article/how-to-use-vba-to-repurpose-a-built-in-command-in-word-and-excel/ Microsoft Excel How to convert a birth date to an age without an expression using Microsoft Excel Power Query https://www.techrepublic.com/article/convert-date-birth-age-without-expression-power-query/ How to use a border to discern groups more easily in Microsoft Excel https://www.techrepublic.com/article/microsoft-excel-use-border-discern-groups/ How to use VBA to change the active cell color in an Excel sheet https://www.techrepublic.com/article/how-to-use-vba-to-change-the-active-cell-color-in-an-excel-sheet/ How to create a sorted unique list in an Excel spreadsheet https://www.techrepublic.com/article/how-to-create-a-sorted-unique-list-in-an-excel-spreadsheet/ How sparklines deal with non-numeric values in Excel https://www.techrepublic.com/article/how-sparklines-deal-with-non-numeric-values-in-excel/ How to avoid 3D formula pitfalls in Excel https://www.techrepublic.com/article/how-to-avoid-3d-formula-pitfalls-in-excel/ How to use the spill range in Excel https://www.techrepublic.com/article/how-to-use-the-spill-range-in-excel/ How to add a graphic watermark to a spreadsheet in Excel https://www.techrepublic.com/article/how-to-add-a-graphic-watermark-to-a-spreadsheet-in-excel/ How to use Microsoft 365’s dynamic array function SEQUENCE() to create a list of dates in Excel https://www.techrepublic.com/article/how-to-use-microsoft-365s-dynamic-array-function-sequence-to-create-a-list-of-dates-in-excel/ How to use the FILTER() dynamic array function in Excel https://www.techrepublic.com/article/how-to-use-the-filter-dynamic-array-function-in-excel/ How to generate random letters in Excel https://www.techrepublic.com/article/how-to-generate-random-letters-in-excel/ How to generate random numbers with no duplicates in Excel https://www.techrepublic.com/article/how-to-generate-random-numbers-with-no-duplicates-in-excel/ How to use the newish XLOOKUP() dynamic array function in Excel https://www.techrepublic.com/article/how-to-use-the-newish-xlookup-dynamic-array-function-in-excel/ 3 ways to quickly deal with blank cells in an Excel sheet https://www.techrepublic.com/article/3-ways-to-quickly-deal-with-blank-cells-in-an-excel-sheet/ How to use TODAY() to highlight fast-approaching dates in an Excel sheet https://www.techrepublic.com/article/how-to-use-today-to-highlight-fast-approaching-dates-in-an-excel-sheet/ 4 quick and easy ways to convert numbers stored as text to real numbers in Excel https://www.techrepublic.com/article/microsoft-excel-how-to-convert-numbers-stored-as-text-to-real-numbers/ How to quickly make Excel subtotals stand out from the data https://www.techrepublic.com/article/microsoft-excel-how-to-make-subtotals-stand-out-data/ How to calculate rank in an Excel sheet https://www.techrepublic.com/article/microsoft-excel-how-to-calculate-rank/ How to group time values by the hour in Excel https://www.techrepublic.com/article/microsoft-excel-group-time-values-by-hour/ 2 ways to display negative numbers in red in Microsoft Excel https://www.techrepublic.com/article/display-negative-numbers-red-microsoft-excel/ How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel https://www.techrepublic.com/article/how-to-use-bycol-and-byrowevaluate-data-across-columns-rows-in-excel/ How to use conditional formatting to make larger values more readable in Excel https://www.techrepublic.com/article/microsoft-excel-how-to-use-conditional-formatting-make-larger-values-more-readable/ How to create a YOY comparison chart using a PivotChart in Excel https://www.techrepublic.com/article/microsoft-excel-how-to-create-year-over-year-comparison-chart-pivotchart/ How to enter and display fractions in Excel https://www.techrepublic.com/article/enter-display-fractions-in-excel/ How to create a floating bar chart in Excel https://www.techrepublic.com/article/create-floating-bar-chart-excel/ Microsoft Word How to include the chapter number with a Word document’s page number https://www.techrepublic.com/article/how-to-include-the-chapter-number-with-a-word-documents-page-number/ How to add an appendix to a table of contents in Microsoft Word https://www.techrepublic.com/article/how-to-add-an-appendix-to-a-table-of-contents-in-microsoft-word/ How to fill text with a picture in Word https://www.techrepublic.com/article/how-to-fill-text-with-a-picture-in-word/ How to use VBA procedures for quick access to readability statistics in Word https://www.techrepublic.com/article/how-to-use-vba-procedures-for-quick-access-to-readability-statistics-in-word/ How to add an automated signature to a Microsoft Word document https://www.techrepublic.com/article/how-to-add-an-automated-signature-to-a-microsoft-word-document/ How to use the many text wrapping options in Microsoft Word https://www.techrepublic.com/article/how-to-use-the-many-text-wrapping-options-in-microsoft-word/ How to quickly insert contact information into a Word document https://www.techrepublic.com/article/how-to-quickly-insert-contact-information-into-a-word-document/ How to limit the number of characters in a search and replace only a specific character in Word https://www.techrepublic.com/article/how-to-limit-the-number-of-characters-in-a-search-and-replace-only-a-specific-character-in-word/ Two ways to quickly delete paragraphs in Microsoft Word https://www.techrepublic.com/article/two-ways-to-quickly-delete-paragraphs-in-microsoft-word/ How to keep lines and paragraphs together on the same page in Word https://www.techrepublic.com/article/how-to-keep-lines-and-paragraphs-together-on-the-same-page-in-word/ How to use check box content controls in a Word document https://www.techrepublic.com/article/how-to-use-check-box-content-controls-in-a-word-document/ How to keep lines and paragraphs together on the same page in Word https://www.techrepublic.com/article/how-to-keep-lines-and-paragraphs-together-on-the-same-page-in-word/ How to prevent text from wrapping in a Word document https://www.techrepublic.com/article/how-to-prevent-text-from-wrapping-in-a-word-document/ How to quickly delete multiple page breaks in a Word document https://www.techrepublic.com/article/how-to-quickly-delete-multiple-page-breaks-in-a-word-document/ How to find acronyms in a Word document https://www.techrepublic.com/article/how-to-find-acronyms-in-a-word-document/ How to use fields to create a conditional header or footer in a Word document https://www.techrepublic.com/article/how-to-use-fields-to-create-a-conditional-header-or-footer-in-a-word-document/ How to add sideheads to a document in Word https://www.techrepublic.com/article/how-to-add-sideheads-to-a-document-in-word/ How to Use Replace to Remove or Add Hard Returns in a Word Document https://www.techrepublic.com/article/how-to-use-replace-to-remove-or-add-hard-returns-in-a-word-document/ How to control a Word table's horizontal alignment https://www.techrepublic.com/article/how-to-control-a-word-tables-horizontal-alignment/ How to quickly add drawings and real connectors using the drawing canvas in Word https://www.techrepublic.com/article/how-to-quickly-add-drawings-and-real-connectors-using-the-drawing-canvas-in-word/ How to use a VBA procedure that deletes the current page in a Word document https://www.techrepublic.com/article/how-to-use-a-vba-procedure-that-deletes-the-current-page-in-a-word-document/ How to automate entering dates with VBA in a Word document https://www.techrepublic.com/article/how-to-automate-entering-dates-with-vba-in-a-word-document/ 3 ways to add color to the numbers in a numbered list in Word https://www.techrepublic.com/article/3-ways-to-add-color-to-the-numbers-in-a-numbered-list-in-word/ 3 ways to count the number of occurrences of a specific word or phrase in a Word document https://www.techrepublic.com/article/count-number-occurrences-specific-word-phrase-word-document/ How to inspect your Word documents for readability and compatibility https://www.techrepublic.com/article/how-to-inspect-your-word-documents-for-readability-and-compatibility/ How to remove tabs used to indent paragraphs in a Word document https://www.techrepublic.com/article/how-to-remove-tabs-used-to-indent-paragraphs-in-a-word-document/ How to use VBA to modify tables in Microsoft Word https://www.techrepublic.com/article/how-to-use-vba-to-modify-tables-in-microsoft-word/
