| Nr |
Title
|
Description |
Used |
PH | |
|---|---|---|---|---|---|
1
|
|
Pro tip: Sort table data in a Word document - TechRepublic | Sorting isn't a common task for Word users, so it might seem like a foreign idea. Susan Harkins shows you how to quickly sort table data. | ||
|
2
|
|
Bookmax.net Bookmarks | |||
|
3
|
|
Pro tip: Use Excel´s conditional formatting to highlight holidays - TechRepublic | Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature. | Dec 10, 2014 | |
|
4
|
|
Six been-around-the-block tips for working more efficiently in Excel - TechRepublic | Just because a tip has been used for a long time doesn't mean it isn't new to you. Learn a few of Susan Harkins' old but reliable tips for working more efficiently in Excel. | ||
|
5
|
|
How to Remove Duplicate Rows in Excel | |||
|
6
|
|
Office Q&A: Find and Replace tricks, disappearing margins, and accommodating graphics - TechRepublic | Susan Harkins helps a few readers find simple Office solutions, including how to perform some Find and Replace tricks, create disappearing margins, and accommodate graphics. | ||
|
7
|
|
How to group an Access report on the fly - TechRepublic | You don't need specialized VBA skills to add intuitive click events that regroup Access reports on the fly. Susan Harkins explains. | ||
|
8
|
|
Beginner: How to Create and Manage Tasks in Outlook 2013 | |||
|
9
|
|
Pro tip: Add a UserForm to aid data entry in Excel - TechRepublic | Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how. | Jan 01, 2015 | |
|
10
|
|
The top 15 function keys for Word, Excel and Outlook | Master these key combos and shave hours off your projects. | ||
|
11
|
|
How to add an index to a Word document using index tags - TechRepublic | Susan Harkins explains how to add an index to a Word document using index tags. | ||
|
12
|
|
5 essential tips for creating Excel macros | PCWorld | Get the most out of this powerful Excel feature with some simple rules that will make recording and using macros a cinch. | ||
|
13
|
|
Microsoft OneNote tutorial: Everything you need to know to start taking notes | Microsoft’s purple paper eater may just help restore your sanity when you’re fighting digital clutter. | ||
|
14
|
|
Ciberdúvidas da Língua Portuguesa | |||
|
15
|
|
Acrobat Pro, PDF Pack, Export PDF & More | Acrobat Document Solutions | Adobe Document Solutions make it simple to help you get more done every day, and lets you easily create, edit, send, and sign, documents in from anywhere. | ||
|
16
|
|
5 PowerPoint Tips You Need To Know | Ethos3 - A Presentation Design Agency | Learn to use PowerPoint like a presentation professional with these video tutorials featured below. Each video is loaded with PowerPoint hacks that will give | ||
|
17
|
|
Four useful Excel filtering behaviors - TechRepublic | Excel's filtering feature is helpful, but add a bit of creativity and it becomes much more. Susan Harkins explains. | ||
|
18
|
|
How to manage Word styles like a pro - TechRepublic | Stop avoiding Word styles. Instead, learn how to manage them, so you can put them to work for you. | ||
|
19
|
|
How to Turn Off Automatic Numbered Lists in Word 2013 | |||
|
20
|
|
How to Turn Off Automatic Numbered Lists in Word 2013 | |||
|
21
|
|
How to Disable Hyperlinks in Word 2013 | |||
|
22
|
|
Your Excel formulas cheat sheet: 15 tips for calculations and common tasks | PCWorld | Save this for the spreadsheet jocks in your office--we'd bet even the experts don't know all of these formula tips. | ||
|
23
|
|
One Note tips | |||
|
24
|
|
Random time values, conditional formatting, and a PivotTable solution | May 06, 2015 | ||
|
25
|
|
How to use Excel´s Subtotal feature - TechRepublic | Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data. | ||
|
26
|
|
How to Add a Second Time Zone to Your Calendar in Outlook | |||
|
27
|
|
How to Set the Advanced Properties of a Word Document | |||
|
28
|
|
How to use Excel´s Goal Seek analysis tool - TechRepublic | Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals. | ||
|
29
|
|
Essential add-ons for Google Sheets: Workflows, advanced find and replace, mail merge | PCWorld | Try these tools to help manage document approvals, find hidden data, personalize bulk emails, and more. | ||
|
30
|
|
Word macros: Three examples to automate your documents | PCWorld | Use these step-by-instructions to turn complex procedures into one-click wonders. | ||
|
31
|
|
How to use OneNote to share notebooks, lists and more | PCWorld | Now that all Windows users have Microsoft accounts, sharing notes with family and colleagues is easy to set up. | ||
|
32
|
|
Filter data even faster with a custom filter technique in Excel - TechRepublic | Excel's built-in Filter feature is helpful but sometimes awkward to use. A customized feature is often easier. Susan Harkins explains. | ||
|
33
|
|
How to Find Section Breaks in a Word Document | |||
|
34
|
|
Word timesaving tips: Random text, quick definitions, formatting tricks and more | PCWorld | Make it easier to format and read long Microsoft Word documents (and shorter ones) with these tips. | ||
|
35
|
|
Create a quick and effective dashboard using Excel´s PivotChart and Slicer objects - TechRepublic | Learn how you can combine PivotChart and Slicer objects to create an easy-to-use and dynamic data summarization. | ||
|
36
|
|
How to Add a Macro to the Quick Access Toolbar in Office | |||
|
37
|
|
Master sorting basics in Excel - TechRepublic | Learning Excel's sort basics gives you a firm foundation for implementing more complex sorting tasks. | ||
|
38
|
|
Use PowerPoint´s push transition to connect related slides - TechRepublic | Combine a visual ribbon and PowerPoint's push transition to pull slides into view. This illustrated walk-through, with demo files, will show you how. | ||
|
39
|
|
ASAP Utilities for Excel - Practical Tricks to Save Hours in Excel with ASAP Utilities | Examples and tutorials that show you how ASAP Utilities will save you time and makes YOU rock in Excel. | ||
|
40
|
|
Office Q&A: Two Excel list solutions - TechRepublic | In this month's Office Q&A, we offer two list solutions that offer dynamic capabilities when combined with Excel's Table object. | ||
|
41
|
|
5 essential Google Docs and Sheets add-ons | PCWorld | Translate text, purge spreadsheets of duplicate data, and more with these helpers. | ||
|
42
|
|
Increase your productivity with Office and SharePoint add-ins - TechRepublic | Office and SharePoint add-ins give you all kinds of specialized functionality--and it only takes few quick clicks to take advantage of them. | ||
|
43
|
|
How to Manually Create Compound Characters in Word | |||
|
44
|
|
How to turn Google Chrome into a Microsoft Office-loving browser | PCWorld | A Chrome extension from Microsoft makes life easier for Office Online users. | ||
|
45
|
|
Box, Dropbox users can now edit Office documents together in real time | PCWorld | Business users who rely on cloud storage providers such as Dropbox and Box now have some improved tools in their collaboration arsenal, thanks to a set of integrations that Microsoft announced Wednesday. | ||
|
46
|
|
How to Center Text Vertically on the Page in Microsoft Word | |||
|
47
|
|
How to Open Certain Workbooks Automatically When You Start Excel | |||
|
48
|
|
How to Quickly Insert Blocks of Text in Microsoft Word with AutoText | |||
|
49
|
|
How to Add Shortcut Keys to AutoText Entries in Word | |||
|
50
|
|
Seven tips to tap into Word´s AutoText power - TechRepublic | Word's AutoText feature is like AutoCorrect on steroids. Once you master a few tricks and shortcuts, you'll wonder how you ever got along without it. | ||
|
51
|
|
How to Insert the Contents of One Word Document into Another | |||
|
52
|
|
10 Things: How to use Word templates effectively - TechRepublic | Word templates can simplify your work and make you more productive. These tips will help you get the maximum benefit with the least effort. | ||
|
53
|
|
Get the most out of your Excel PivotTables with these handy tips - TechRepublic | Once you tap into the power and flexibility of PivotTables, you'll be able to summarize data in the most clear and meaningful ways. Here are several techniques that will help. | ||
|
54
|
|
Office Q&A: A dynamic lookup solution for matching partial lists to a master list in Excel - TechRepublic | When you need to accommodate an existing worksheet structure, the easiest solution isn't always possible. Susan Harkins shows a member how to get around this limitation. | ||
|
55
|
|
How to Nest a Table Within a Table in Word | |||
|
56
|
|
Migrating Outlook pst-data to Outlook.com - MSOutlook.info | I’m currently using Outlook with a POP3 account but I’d like to switch over to an Outlook.com account. I’ve set Outlook.com to download all the new mail for my old POP3 account (actually, I’ve set my old account to forward to Outlook.com as this appears to be faster) and configured my Outlook.com account in Outlook. This all works great and as expected. How do I migrate all the mails which I had already downloaded via POP3 into an Outlook pst-file to my Outlook.com mailbox? | ||
|
57
|
|
Take advantage of these free online Office resources - TechRepublic | In celebration of the holiday season, Susan Harkins shares her favorite free Office resources. | ||
|
58
|
|
Excel 2016 charts: How to use the new Pareto, Histogram, and Waterfall formats | PCWorld | Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships. | ||
|
59
|
|
How to Customize and Use the Status Bar in Excel | |||
|
60
|
|
How to Combine Images into One PDF File in Windows | |||
|
61
|
|
Office Q&A: Simple solutions for Outlook, Excel, and Word - TechRepublic | In this month's Office Q&A column, Susan Harkins shows three readers simple solutions to problems that aren't as big as they seem. | ||
|
62
|
|
How to Rename a Bookmark in Microsoft Word Using a Free Add-in | |||
|
63
|
|
How to use Excel´s Data Validation feature to prevent data entry mistakes - TechRepublic | Your application is only as strong as your data. Learn how to restrict input values using Excel's Data Validation feature. | ||
|
64
|
|
How to Indent an Entire Table in Microsoft Word | |||
|
65
|
|
Word tutorial: Clean up a messy document´s formats and styles using macros | PCWorld | You have a long, messy Word document, with a bunch of formats and styles that are just plain wrong. With Word macros, you can fix them all by recording each fix and running them as much as you need. We'll show you how. | ||
|
66
|
|
How to See All of the Named Cell Ranges in an Excel Workbook | |||
|
67
|
|
Excel pro tips: How to create, define, and use Named Ranges | PCWorld | Working with ranges in Excel can speed up your formulas and macros, or help you navigate through your spreadsheets. It’s also a more efficient way to manage processes within your worksheets. Here's how to set them up. | ||
|
68
|
|
How to Work with Microsoft Office Files in Google Drive | |||
|
69
|
|
How to Reduce the Size of Microsoft Office Documents That Contain Images | |||
|
70
|
|
How to Type Ampersands (&) in Excel’s Headers and Footers | |||
|
71
|
|
How to Convert a Google Docs Document to Microsoft Office Format | |||
|
72
|
|
How to Use Notepad to Create a Dated Log or Journal File | |||
|
73
|
|
Excel pro tips: Importing and parsing data | PCWorld | When data dumps into your spreadsheet and it's a big mess, you'll know what to do. Here's how to use text functions to join and separate data at will. | ||
|
74
|
|
Word pro tips: Use Wildcards for faster, more accurate search-and-replace results | PCWorld | Wildcards work in Word much like they do in Scrabble or Poker, representing whatever you need to find or change in a document. Here's how the basic wildcard features work and what you can do with them. | ||
|
75
|
|
Eight quick tips for working efficiently in Outlook´s Calendar window - TechRepublic | Sometimes the simplest tricks save you the most time. Here are eight easy-to-implement shortcuts that will put a lot of power at your fingertips. | ||
|
76
|
|
How to make Google Drive apps look and work more like Microsoft Office | PCWorld | Here are a few dials you can turn to get Google Docs, Sheets, and Slides to perform a little more closely to their Office counterparts. | ||
|
77
|
|
How to use Word´s Outline view to quickly sort long lists - TechRepublic | Sorting a long list of terms manually in Word can be tedious in the extreme, but you can tackle the task quickly if you know how to harness the power of the Outline view. | ||
|
78
|
|
Excel power tips: 3 handy ways to tame hyperlinks | PCWorld | Excel does its best to handle hyperlinks, even though they're ungainly in spreadsheets. Here are tricks you'll need to keep them under control. | ||
|
79
|
|
How to Send Documents as a Single Zip File With Windows | Need to send a bunch of docs? Here's how to compress multiple documents in a single zip file and email it conveniently with Windows. | ||
|
80
|
|
5 Google Sheets add-ons that supercharge your data | PCWorld | Create QR codes, customize Google Maps, and eliminate inefficiencies with these extensions. | ||
|
81
|
|
How to Change the Default “Insert Picture” Location in Microsoft Word | |||
|
82
|
|
Excel: 5 timesaving power tips | PCWorld | There's no such thing as too fast in Excel. These power tips help with formulas, and filling and fixing spreadsheet data. | ||
|
83
|
|
How to Easily Change the Case on Text in Microsoft Word | |||
|
84
|
|
4 essential Android add-ons for Google Docs and Sheets | PCWorld | Create mobile apps, e-sign documents, and more right from your phone with these third-party enhancements. | ||
|
85
|
|
How to Perform Simple Calculations in Microsoft Word | |||
|
86
|
|
How to Insert the Current Month and Year in a Word Document That Automatically Updates | |||
|
87
|
|
Excel formula tips: How to troubleshoot by tracing dependents and precedents | PCWorld | In Excel, when you need to debug a complex web of formulas, you need to trace dependent and precedent formulas. Here's how they work. | ||
|
88
|
|
An Excel conditional format that expands with grouped data - TechRepublic | By adding a helper column and a simple conditional format rule, you can apply an alternating band scheme that expands to accommodate a group. | ||
|
89
|
|
How to Format the Numbers or Bullets in a List in Microsoft Word | |||
|
90
|
|
How to Change the Alignment of the Numbers in a Numbered List in Microsoft Word | |||
|
91
|
|
Office Q&A: Function flow, Outlook Bcc behaviors, and entering formatted text - TechRepublic | Our October Q&A demonstrates three easy-to-implement Office solutions. | ||
|
92
|
|
Excel tips: 6 slick shortcuts, handy functions and random-number generators | PCWorld | You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers. | ||
|
93
|
|
10 timesaving Excel tricks you might not know about - TechRepublic | Mastering these simple shortcuts will help speed your work in Excel. | ||
|
94
|
|
How to create Motion Paths in PowerPoint | PCWorld | Building motion into PowerPoint slideshows makes them come alive like no static images could ever hope to do. Here's our step-by-step guide through all the features and options. | ||
|
95
|
|
Three ways to expose formatting inconsistencies in a Word document - TechRepublic | Whether you're sharing new documents or revamping old ones, these three tools can reveal troublesome formatting problems. | ||
|
96
|
|
Excel Date & Time functions tutorial: EDATE, YEARFRAC, EOMONTH, NETWORKDAYS.INTL | PCWorld | We delve into the Excel Date & Time functions EDATE, YEARFRAC, EOMONTH, and NETWORKDAYS.INT. All are handy for going back and forth in time on retirement dates, expiration dates and more. | ||
|
97
|
|
The best OneNote 2016 tips: 10 ways anyone can get organized | PCWorld | Microsoft’s OneNote is a surprisingly versatile tool for jotting down and organizing notes, random facts and more. These tips will help you make the most of its features. | ||
|
98
|
|
Office Q&A: Three simple problems with quick solutions - TechRepublic | In this month's column, Susan Harkins sheds light on one Outlook problem and two Word frustrations--and explains the easiest way to resolve them. | ||
|
99
|
|
How to turn a Word table cell into a picture placeholder - TechRepublic | Limiting a picture to a specific size and position is as simple as resetting a few cell properties in a Word table. | ||
|
100
|
|
PowerPoint tips from Duarte´s Five Rules Presentation | PCWorld | Duarte's Five Rules is a classic PowerPoint presentation that can make you an instant expert. Study the slides and read these tips to learn more. | ||
|
101
|
|
How to make Word custom bullet points to enhance your documents | PCWorld | Word's built-in bullet points can give boring reports a bit of bling, but you can do even more by creating custom bullets from an image file. Here's how. | ||
|
102
|
|
Seven time-saving Replace tricks for changing Word formatting - TechRepublic | Don't waste precious time formatting individual words and paragraphs when Word's Find and Replace feature will do it for you. | ||
|
103
|
|
How to Create Custom Keyboard Shortcuts with AutoHotkey | |||
|
104
|
|
Unleash the power of Excel´s AutoSum tool - TechRepublic | You know AutoSum is a helpful tool, but it's more flexible and valuable than you might realize. This walk-through introduces a variety of timesaving tricks. | ||
|
105
|
|
How to Remove a Password From a PDF File | |||
|
106
|
|
Word newsletter tutorial: Using page layout features for professional results | PCWorld | Word makes it easy to create a newsletter using the Page Layout tools. Make columns and multipage layouts, add images and more. Here's how. | ||
|
107
|
|
Excel´s IF statement made easy | PCWorld | If you can decide what to have for lunch, you already understand Excel's IF logic--you just need to understand the format. | ||
|
108
|
|
Word resume tips: Using style sheets, shapes and text boxes for a professional look | PCWorld | Updating your résumé means more than refreshing the information. We'll show you how to use style sheets, shapes, and text boxes to create a modern, professional layout. | ||
|
109
|
|
Seven tips for working with Office shapes - TechRepublic | Use these seven tips to create quick and effective impact when using shapes to enhance your Office documents. | ||
|
110
|
|
7 Excel tips for huge spreadsheets: Split Screen, Freeze Panes, Format Painter and more | PCWorld | The bigger and uglier your Excel spreadsheet gets, the more you need these tips to handle the data with as little hassle as possible. | ||
|
111
|
|
Understanding Excel´s conditional formatting rules can help prevent unintended results - TechRepublic | Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules. | ||
|
112
|
|
Excel tutorial: How to import and parse complicated data | PCWorld | Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how. | ||
|
113
|
|
Excel tutorial: How to import and parse complicated data | PCWorld | Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how. | ||
|
114
|
|
Google Slides: 3 Chrome extensions for better presentations | PCWorld | Enhance Google Slides with a few choice Chrome extensions. The ones here can auto-create photo slides, turn text to speech and more. | ||
|
115
|
|
Two ways to generate a list of tables in a Word document - TechRepublic | Documenting tables and figures in a Word document is easy using Word's built-in referencing feature--and there's more than one way to get the job done. | ||
|
116
|
|
How to create a pivot table in Microsoft Excel - TechRepublic | Using a pivot table can increase your productivity in Excel. Here are two simple ways to create one. | ||
|
117
|
|
Microsoft OneNote add-ins and tools | OneNote becomes even more powerful at organizing your life when it's connected to the right add-ins and services. Save everything from meeting notes to recipes and even emails to your digital notebook. | ||
|
118
|
|
10 time-saving tips to speed your work in Excel - TechRepublic | No matter how long you've been using Excel, you're probably putting more effort than necessary into some common tasks. | ||
|
119
|
|
Video: How to find duplicates in an Excel spreadsheet - TechRepublic | Need to locate and filter out duplicate data from an Excel document? Here's how to do it. | ||
|
120
|
|
Microsoft Word´s desktop publishing tools | Better graphics, better features, more options | ||
|
121
|
|
10 time-saving tips to speed your work in Word - TechRepublic | Even seasoned Word experts can become more efficient by learning an unfamiliar trick or two. See if these features and shortcuts shave a bit of time off your daily tasks. | ||
|
122
|
|
Office Q&A: Reclaim old options and quickly find related messages - TechRepublic | This month, Susan Harkins shows you how to reclaim old Word tools and access related messages using Outlook search folders. | ||
|
123
|
|
Two ways to speed up Excel macros - TechRepublic | When it comes to executing actions and performing tasks, faster is always better. Learn two tricks that will make your Excel macros more efficient. | ||
|
124
|
|
Three quick sorting tips for Access and Excel - TechRepublic | Access and Excel support similar built-in sorting features that eliminate the need for customized sorting tools. Whether you're a developer or a casual user, these features will save you time. | ||
|
125
|
|
Convert a notebook to a different format in OneNote 2016 for Windows - OneNote | If you’re using an older version of OneNote, you may be prompted to upgrade to the latest version. It’s a good idea to upgrade because you’ll have access to all the latest features. | ||
|
126
|
|
How to Convert a PDF File Into an Editable Text Document | Adobe’s PDF standard is handy whenever you need to distribute some information and be sure that it’s seen the same way by all recipients. But PDF files are also infamously tough to edit. | ||
|
127
|
|
The Best Ways to Scan a Document Using Your Phone or Tablet | Sure, a dedicated scanner is still great to have if you frequently need to scan a large handful of documents, but using your phone also works great if you only have a couple documents to scan every now and then. Here’s what we recommend for Android and iOS. | ||
|
128
|
|
Five ways to take advantage of Excel list features - TechRepublic | Using the right features, creating and managing lists in Excel is easy. Use these five flexible techniques to work more productively. | ||
|
129
|
|
Eight ways Word´s built-in styles can save you a ton of time - TechRepublic | Word's built-in styles are integrated into many useful features, like footnotes, numbered lists, and header and footer text. Here's a quick look at how to use these styles to save time. | ||
|
130
|
|
Create, Edit and View Microsoft Word Documents for Free | An article detailing how to view, edit and create Microsoft Word documents for free including DOC and DOCX file formats on multiple operating systems. | ||
|
131
|
|
6 Free PDF Password Remover Tools | A list of the best free PDF password remover tools for Windows, plus free PDF password crackers and recovery programs for both user and owner passwords. | ||
|
132
|
|
How to add a custom priority field to Outlook tasks - TechRepublic | Prioritizing tasks can add helpful insight to your routine. If the built-in Low, Normal, and High options aren't enough, build your own custom priority field. | ||
|
133
|
|
Five readers add value to 2017 Office articles - TechRepublic | In this brief recap, Susan Harkins shares some of the best tips she learned from readers this year. | ||
|
134
|
|
Juntar PDF - Combinar Seus Arquivos PDF On-Line e Grátis | Sem limite de arquivos, sem marcas d'água - Ferramenta grátis e bonita para combinar seus arquivos PDF exatamente do jeito que você quer. | ||
|
135
|
|
Merge PDF - Combine PDF files online for free | No file limit, no ad watermarks - a free and beautiful tool to combine your PDF files exactly the way you want it. | ||
|
136
|
|
How to Add Sideheads and Pull Quotes to Microsoft Word Documents | Sideheads (where a document’s subheads appear out to the side of the text) and pull quotes are really just two specific uses for text boxes in Microsoft Word. Here’s how to set them up. | ||
|
137
|
|
Five 5 Free Tools You Can Use to Create, Sign, and Edit PDFs Online | Use these PDF tools to find, create, edit, and sign PDF files online. These easy to use tools include search tools, PDF editors, and a PDF merge tool. | ||
|
138
|
|
Zamzar - video converter, audio converter, image converter, eBook converter | Free online video converter, audio converter, image converter, eBook converter. No download or account required. | ||
|
139
|
|
Want Microsoft Office for Free? Here are 7 Legit Options | How to get Microsoft Office for free. Try a Microsoft Office free trial or get it through your employer or school, as well as other great options. | ||
|
140
|
|
5 Google Sheets Features You Should Know | You’re probably familiar with the basics of Google Sheets, but Google’s spreadsheet offering boasts loads of features that aren’t obvious at first glance. Here are some of our favorites. | ||
|
141
|
|
How to Create, Edit, and View Microsoft Word Documents for Free | There was a time when you had to have Microsoft Office installed to create, edit, or even view a Microsoft Word document. Thankfully, that’s no longer the case. There are a number of free alternatives for working with those Word documents people occasionally send you. | ||
|
142
|
|
Guidelines and examples of array formulas - Office Support | An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum every nth value in a range of values. | ||
|
143
|
|
Live Feed · ejslage@gmail.com | |||
|
144
|
|
Getting the most from OneNote, part I: A hidden Office gem - TechRepublic | The more information you put into OneNote the more useful it is. You can tag, flag, recognize, record and search just about anything. | ||
|
145
|
|
Office Q&A: Excel referencing, Word field codes, and a table trick - TechRepublic | This month, Susan Harkins presents some easy solutions for a few problems that only seem big. | ||
|
146
|
|
How to Use Google Sheets Functions | Use functions to harness the power of Google Sheets. Here's what functions are, how they work in Google Spreadsheets, and some function examples. | ||
|
147
|
|
5 Free Spreadsheet Programs | This list of the best free spreadsheet programs will save you a ton of money on spreadsheet software and give you all the features you're looking for. | ||
|
148
|
|
Google Forms | |||
|
149
|
|
5 Best Free Online Database Creators | Create a database with these free online database creators. These tools are totally free and are adequate for small web-based applications. | ||
|
150
|
|
Copy an Excel sheet from one workbook to another - TechRepublic | Susan Harkins shows you two quick ways to copy data from one Excel workbook to another. | ||
|
151
|
|
The Best Google Sheets Add-Ons | Google Sheets add-ons work similarly to browser extensions. They are third-party apps you install to Sheets to gain additional features. Some add-ons increase productivity, and some add more extensive capabilities. Here’s how to get started. | ||
|
152
|
|
What are Pivot Tables in Google Sheets, and How Do I Use Them | Pivot tables let you analyze large amounts of data and narrow down large data sets to see the relationships between data points. Google Sheets uses pivot tables to summarize your data, making it easier to understand all the information contained in your spreadsheet. | ||
|
153
|
|
What is an Electronic Signature? | Learn how to create and use a digital signature. Our top four picks for the best software, so you don't have to print and scan and waste paper. | ||
|
154
|
|
How to Convert a PDF to Google Doc Format | Here's how to convert a PDF file into a Google Doc for editing, emailing, and sharing. It's straightforward and easy to do. | ||
|
155
|
|
Atalhos de teclado para carateres internacionais - Suporte do Office | Saiba mais sobre atalhos de teclado para carateres internacionais no Word e no Outlook. | ||
|
156
|
|
How to Unlock Read-Only PowerPoint Presentations | If you want unrestricted editorial rights to a read-only PowerPoint presentation, then you have to unlock it. The good news is that you can open it in a few simple clicks. Here’s how. | ||
|
157
|
|
How to Add Google Keep Notes to Google Docs | Google lets you add notes, lists, and images from Google Keep directly into your Google Docs and Slides. Use existing notes or create a new one and add it on the fly without ever leaving your file. Here’s how. | ||
|
158
|
|
How to Troubleshoot Word Startup Problems | Microsoft Office is constantly working to improve its software. Still, there might be times when Word just refuses to start. Here are a few ways you can get Word up and running again. | ||
|
159
|
|
How to work with long documents in Microsoft Word - TechRepublic | Follow these tips on how to easily navigate and manage lengthy documents in Word by taking advantage of key features. | ||
|
160
|
|
How to Make a Graph in Google Sheets | A data-heavy spreadsheet can be difficult to read through and process. If you’re using Google Sheets, adding graphs to your spreadsheet can help you present this information differently for easier reading. Here’s how you can add graphs to your spreadsheet. | ||
|
161
|
|
How to Use Text Shortcuts in Google Docs | The Automatic substitution feature in Google Docs is a simple way to create text shortcuts for words or sentences you regularly use in your documents. Here’s how you can save time and effort with this handy tool. | ||
|
162
|
|
How to Concatenate Data from Multiple Cells in Google Sheets | In Google Sheets, if you want to link data from multiple cells together, you don’t have to merge them. You can use the CONCAT, CONCATENATE, and JOIN functions to combine them in one cell. | ||
|
163
|
|
How to Wrap Text Around Images in Google Docs | If you want to insert an image or object into a document, it’s relatively simple. However, positioning and getting them to stay where you want can be frustrating. The wrap text feature in Google Docs makes all of this more manageable. | ||
|
164
|
|
How to Use the QUERY Function in Google Sheets | If you need to manipulate data in Google Sheets, the QUERY function can help! It brings powerful, database-style searching to your spreadsheet, so you can look up and filter your data in any format you like. We’ll walk you through how to use it. | ||
|
165
|
|
20 Excel tips every user should master - TechRepublic | Whether you are a Microsoft Excel beginner or an advanced user, you'll benefit from these step-by-step tutorials. | ||
|
166
|
|
How to Create and Use AutoText Entries in Word | Creating and using custom AutoText entries for frequently used phrases is a great way to speed up the content creation process in Microsoft Word. And the good news is you can set up these time-savers in just a few clicks! | ||
|
167
|
|
How to Use Cell Values for Excel Chart Labels | Make your chart labels in Microsoft Excel dynamic by linking them to cell values. When the data changes, the chart labels automatically update. In this article, we explore how to make both your chart title and the chart data labels dynamic. | ||
|
168
|
|
How to Compare Documents in Google Docs | You can already see what’s changed in a file by reviewing the revision history in a Google Docs file, but now you can also do the same to two separate documents. Here’s how to use the Compare Documents tool. | ||
|
169
|
|
How to assign a keyboard shortcut to blocks of content for easy input in Word - TechRepublic | If you have several pre-defined blocks of content in Microsoft Word, you can avoid the busy Quick Parts gallery by assigning keyboard shortcuts. | ||
|
170
|
|
How to Use Google Docs Brochure Template | Brochures have many uses in business and outside it. With the Google Docs brochure template, you can quickly put together a brochure that you can collaborate on, print, and share. | ||
|
171
|
|
How to use Excel´s PivotTable tool to turn data into meaningful information - TechRepublic | A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use! | ||
|
172
|
|
9 Google Docs Add-Ons That’ll Help You Create Better Documents – Review Geek | Google Docs has become just as popular and well-known as Microsoft Word, with the added advantage of being totally free. It’s also beloved thanks to the myriad of add-ons you can integrate with the app for additional functionality, like adding diagrams, citations, or photos. | ||
|
173
|
|
How to Open a PST File in Microsoft Outlook | If you want to retrieve a single email from a backup file, importing that whole file of emails into Outlook is time-consuming overkill. Here’s how to open a PST file in Microsoft Outlook and browse the contents, no importing needed. | ||
|
174
|
|
How to Create and Use Sections in Microsoft Word | Inserting a Section Break in a Word document gives you a number of ways to split up large walls of text. This feature is useful not just for breaking up text by pages but also for multi-column layouts. | ||
|
175
|
|
How to Create and Use a Table in Microsoft Excel | Analyzing related portions of data is easier if you create and use a table in Microsoft Excel. A table allows you to segregate data on a single sheet that you can then manage separately from the rest. Here’s how to create and use tables in Excel. | ||
|
176
|
|
How to Transpose Excel Data from Rows to Columns (or Vice Versa) | If you started to enter data in a vertical arrangement (columns) and then decided it would be better in a horizontal one (rows), Excel has you covered. We’ll look at three ways to transpose data in Excel. | ||
|
177
|
|
How to Use the TRIM Function in Microsoft Excel | When you copy text into Microsoft Excel, it can occasionally come with characters you’d prefer to see removed, such as unnecessary spaces. Rather than remove these manually, you can use the TRIM function to do it for you. | ||
|
178
|
|
How to Use Excel’s “Quick Analysis” to Visualize Data | Creating a chart in Excel is neither easy nor intuitive for inexperienced users. Luckily, there’s a feature called Quick Analysis that can create charts, tables, and more with just a click. | ||
|
179
|
|
How to Change the Default Date Format in Google Sheets | If you need to work with another date format in Google Sheets, it’s easy to change your Sheet’s default format to match the standard in any location. Here’s how. | ||
|
180
|
|
How to Remove Empty Lines from a Word Document | Manually removing extra blank lines from a Microsoft Word document is tedious. Luckily, a feature built into Word can remove all empty lines at once. Here’s how to do it. | ||
|
181
|
|
How to Use Multiple Page Orientations at Once in Google Docs | When you’re creating a document that could benefit from both portrait and landscape page orientations, consider Google Docs. You can mix both views throughout your document for the perfect format. | ||
|
182
|
|
How to Add a Dotted Line in a Microsoft Word Document | Microsoft Word makes it easy to add a dotted line as a separator in your documents, and there are multiple ways to do it. We’ll show you how in this guide. | ||
|
183
|
|
83 Excel tips every user should master - TechRepublic | Whether you are a Microsoft Excel beginner or an advanced user, you'll benefit from these step-by-step tutorials. | ||
|
184
|
|
How to Rename Columns or Rows in Google Sheets | If you’re creating a Google Sheets spreadsheet for others to use, you can make it easier to refer to certain sections of data by renaming columns or rows using named ranges. Here’s how. | ||
|
185
|
|
83 Excel tips every user should master - TechRepublic | Whether you are a Microsoft Excel beginner or an advanced user, you'll benefit from these step-by-step tutorials. | ||
|
186
|
|
Microsoft Excel: How to use Power Query to display a list of duplicate values or records - TechRepublic | Highlighting or even deleting duplicate records in Excel is simple but listing them isn't as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records. | ||
|
187
|
|
83 Excel tips every user should master - TechRepublic | Whether you are a Microsoft Excel beginner or an advanced user, you'll benefit from these step-by-step tutorials. | ||
|
188
|
|
How to use the FILTER() dynamic array function in Excel - TechRepublic | Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done. | ||
|
189
|
|
How to return the top or bottom n records without a filter or PivotTable in Excel - TechRepublic | There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever. | ||
|
190
|
|
How to use the FILTER() dynamic array function in Excel - TechRepublic | Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done. | ||
|
191
|
|
How to create a custom sort when a regular sort won´t do in Excel - TechRepublic | Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how. | ||
|
192
|
|
How to use the newish XLOOKUP() dynamic array function in Excel - TechRepublic | Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP(). | ||
|
193
|
|
How to use the newish XLOOKUP() dynamic array function in Excel - TechRepublic | Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP(). | ||
|
194
|
|
3 ways to quickly deal with blank cells in an Excel sheet - TechRepublic | Filling blanks isn't difficult at all if you apply one of these three tips. They're quick and easy! | ||
|
195
|
|
How to sort data by multiple columns in Excel - TechRepublic | Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how. | ||
|
196
|
|
How to highlight details for better insight with sparkline charts in Excel - TechRepublic | Sparklines are in-cell charts in Microsoft Excel that are easy to create and extremely helpful, but they can be more insightful with just a few specific settings. | ||
|
197
|
|
How to use check box content controls in a Word document - TechRepublic | Check boxes offer a simple visual way to denote state: on or off, true or false, and so on, and they're easier to use than ever before! | ||
|
198
|
|
How to generate random text using the RANDARRAY() function in Excel - TechRepublic | Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. | ||
|
199
|
|
How to add sideheads to a document in Word - TechRepublic | Positioning headings in the left margin of a Microsoft Word document isn't an intuitive task, but doing so will really help them stand out. | ||
|
200
|
|
How to control a Word table´s horizontal alignment - TechRepublic | When inserting a table in a Word document, you can stick with the default alignment or change it in any number of ways. | ||
|
201
|
|
How to add a graphic watermark to a spreadsheet in Excel - TechRepublic | You may already know you can add a watermark to a Word document, but you might not know that you can also add a watermark to an Excel sheet. Here's how. | ||
|
202
|
|
How to control a Word table´s horizontal alignment - TechRepublic | When inserting a table in a Word document, you can stick with the default alignment or change it in any number of ways. | ||
|
203
|
|
How to use the spill range in Excel - TechRepublic | Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions. | ||
|
204
|
|
How to use the spill range in Excel | TechRepublic | Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions. | ||
|
205
|
|
How to use conditional formatting to compare values from row to row, or not, in Excel | TechRepublic | A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would. | ||
|
206
|
|
How to generate random numbers with no duplicates in Excel | TechRepublic | Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how. | ||
|
207
|
|
4 quick and easy ways to convert numbers stored as text to real numbers in Excel | TechRepublic | Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work. | ||
|
208
|
|
How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel | TechRepublic | Learn a seemingly tricky way to extract data from your Microsoft Excel spreadsheet. | ||
|
209
|
|
How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel | TechRepublic | Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work. | ||
|
210
|
|
How to use wildcards with the XLOOKUP() function in Excel | TechRepublic | Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. | ||
|
211
|
|
How to quickly make Excel subtotals stand out from the data | TechRepublic | Microsoft Excel’s Subtotal feature is a great tool, but you can make the results even better by customizing the format. | ||
|
212
|
|
How to start page numbers after the first few pages in a Word document | TechRepublic | Removing pages numbers from a few but not all pages in a Microsoft Word can be difficult if you don’t know about section breaks. This Word tutorial shows how to efficiently start page numbers somewhere after the first few pages. | ||
|
213
|
|
How to use conditional formatting to make larger values more readable in Excel | TechRepublic | Reporting lots of large values in Excel is probably a good thing, but if you want them to be readable, try this easy technique. | ||
|
214
|
|
How to calculate rank in an Excel sheet | TechRepublic | Microsoft Excel will rank whatever you want automatically. Susan Harkins will show you how. | ||
|
215
|
|
How to add a page-numbering scheme to a document’s front matter in Word | TechRepublic | Adding page numbers to a Word document is a simple task, but additional requirements can complicate things. Learn how to format the page numbers in a Word document’s front matter differently from the rest. | ||
|
216
|
|
How to enter and display fractions in Excel | TechRepublic | Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values. | ||
|
217
|
|
How to calculate a conditional running total using a PivotTable in Excel | TechRepublic | At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how. | ||
|
218
|
|
Why Microsoft Lists is the new Excel | TechRepublic | |||
|
219
|
|
How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel | TechRepublic | |||
|
220
|
|
These new Excel features for working with text and lists will save you time | TechRepublic | |||
|
221
|
|
How to use UNIQUE() to populate a dropdown in Microsoft Excel | TechRepublic | |||
|
222
|
|
How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart | TechRepublic | |||
|
223
|
|
How to enter mathematical equations into a Microsoft Word document | TechRepublic | |||
|
224
|
|
How to use a timeline to filter multiple PivotCharts in Microsoft Excel | TechRepublic | |||
|
225
|
|
How to align content to the left and right on the same line in a Word document | TechRepublic | |||
|
226
|
|
How to shorten references using the hashtag symbol in Microsoft Excel | TechRepublic | |||
|
227
|
|
How to turn delimited content into a list in Word | TechRepublic | |||
|
228
|
|
How to add chapter numbers by modifying an existing heading style in a Word document | TechRepublic | |||
|
229
|
|
How to quickly rearrange pages in Microsoft Word | TechRepublic | |||
|
230
|
|
How to quickly import a .txt or .csv file into Microsoft Excel | |||
|
231
|
|
How to use a custom document property to repeat content in Microsoft Word | TechRepublic | |||
|
232
|
|
How to add conditional formatting a Microsoft Excel PivotTable without expressions | TechRepublic | |||
|
233
|
|
How to use hidden text to make one document do the work of two in Microsoft Word | TechRepublic | |||
|
234
|
|
How to update textbox content controls in Word using a dropdown content control | |||
|
235
|
|
How to Use and Create Cell Styles in Microsoft Excel | There are many ways to format your Excel spreadsheets. From automatic conditional formatting to simple copying from another cell, we take shortcuts to format our sheets quickly. Another wonderful feature for formatting in Microsoft Excel is a Cell Style. | ||
|
236
|
|
How to Use and Customize a Theme in Google Sheets | If you want to add consistency and an attractive appearance to your spreadsheet, consider using a theme. In Google Sheets, you can select a premade theme as well as customize one to fit your style. | ||
|
237
|
|
How to Number or Label Equations in Microsoft Word | If the document you’re creating includes equations, you might plan to number or label them. For both standard and nonstandard formatting, we’ll show you how to add numbers and labels to equations in Microsoft Word. | ||
|
238
|
|
How to Remove Section and Page Breaks in Microsoft Word | Section breaks and page breaks are great formatting features in Microsoft Word, but they can sometimes cause issues, such as creating too much white space. Here’s how you can quickly remove them on Windows 10 and Mac. | ||
|
239
|
|
How to Use Conditional Formatting to Find Duplicate Data in Excel | Whether you obtain data from an external source or have someone performing data entry, mistakes can happen. If you’re concerned that you may have duplicate data in Microsoft Excel, you can find out quickly with conditional formatting. | ||
|
240
|
|
How to Keep Lines of Text Together in Google Docs | No matter what type of document you’re writing, there are certain things you should try to avoid. This includes dangling lines at the beginning or end of the page. In Google Docs, you can easily keep lines of text together. | ||
|
241
|
|
How to Add Formulas to Tables in Microsoft Word | In reports, proposals, and similar documents, tables provide structured ways to display data. If you have Excel data, you can embed it in your Word document. But if not, you can create a table directly in Word and include quick formulas. | ||
|
242
|
|
How to Apply a Color Scale Based on Values in Google Sheets | Sometimes, adding color effects to a spreadsheet can be a terrific way to complement your data. If you are displaying a range of values like sales totals, for example, you can use color scales in Google Sheets. | ||
|
243
|
|
How to Create a Dependent Drop-Down List in Microsoft Excel | Does using a drop-down list in Microsoft Excel make data entry easier for you or your co-workers? If you said yes and want to go a step further, you can create a dependent drop-down list just as easily. | ||
|
244
|
|
How to Highlight Blanks or Errors in Google Sheets | When you have a Google Sheets spreadsheet full of data, it can be difficult to see certain cells at a glance. If you have empty cells where you expect data or errors generated from formulas, you can automatically highlight them. | ||
|
245
|
|
How to Add a Drop-Down List to a Word Document | A drop-down list in a Microsoft Word document lets people select from a predefined items list. Adding this drop-down list is fairly easy, and we’ll show you how to do it. | ||
|
246
|
|
How to Lock an Image’s Position in Google Docs | Laying out a document with both text and images can sometimes be a challenge. To make this task a bit easier, you can lock an image into a fixed position in Google Docs. | ||
|
247
|
|
How to Use the Analyze Data Feature in Microsoft Excel | One of the most common tasks people perform aside from adding data to a spreadsheet is analyzing it. But did you know that Microsoft Excel has a built-in feature specifically for this? It’s called Analyze Data, and it can help you see trends, patterns, rankings, and more. | ||
|
248
|
|
Change Page Orientation mid Microsoft Word Document | TechRepublic | |||
|
249
|
|
Change Formats Using Replace or Style in Microsoft Word | TechRepublic | |||
|
250
|
|
Use TEXTAFTER() and TEXTBEFORE() in Microsoft Excel | TechRepublic | |||
|
251
|
|
Get a List of Excel Sheet Names with Power Query | TechRepublic | |||
|
252
|
|
How to Execute a VBA Sub Procedure in Microsoft Excel | TechRepublic | |||
|
253
|
|
Apply New Styles to an Old Document in Microsoft Word | TechRepublic | |||
|
254
|
|
Excel guide: Hiding everything besides your workspace | |||
|
255
|
|
How to add color to a drop-down list in Excel | TechRepublic | |||
|
256
|
|
How to copy an Excel sheet from one workbook to another |
ejslage@gmail.com