”These interactive guides show you where your favorite menu and toolbar commands are located in Office 2010-13. Just click the command or button that you want to find, and the guide will show you its location in the 2010-13 version of the program.”Office.Microsoft.com
"If no end-user customization is required (including report modifications), you may choose to distribute these Access solutions so that they run without requiring a full installation of Access."
”You should use the real Administrator account very sparingly - never make it your default modus operandi! Please note that you use this technique at your own risk.”TechRepublic
"Color is used to highlight how the gun moves and how the gun reveals itself, short visual noun-verb sentences that indicate the key signs that help detectives to spot someone carrying a hidden handgun. Thus the color usually has a distinct substantive point and is not just used to depict surfaces or to decorate the news."
"Microsoft Access does not restrict the use of special characters such as a number sign (#), a period (.), or a quotation mark (") in the database object names or in the database field names. However, if you do use the special characters, you may experience unexpected errors.
" To work around this problem, do not use special characters. If you must use special characters in query expressions, enclose the special characters in brackets ([]). For example, if you want to use the greater than sign (>), use [>]."Special Characters
"Proximity Functions" is a set of MS Access modules, forms and controls that you can use to easily add professional functionality to your MS Access application without programming. By simply importing a few modules, then copying and pasting one control next to a text control on your form you can add Windows-standard file open/save dialogs, folder browse dialogs, color selection dialogs, a fantastic calendar date picker dialog, and more.
37signals is here to help. In these pages you'll find dozens of ideas for improving the holiday customer experience at your site. Each idea is accompanied by examples taken from top retail sites (we've visited hundreds of sites over the past two holiday seasons seeking smart techniques).
"The purpose of LT Technologies, Inc. is to link technology with teaching in order to maximize student achievement in the classroom."Spreadsheets
". . . did you know that when you set a shape's action setting to launch a program, you can pass command line switches to that program?"
"Sometimes, you want to crop around an image with a complex shape. Most people do this in Adobe Photoshop or another image-editing program, but you can do it in PowerPoint if you don't have or know another program"Read more:
"Discover the only worldwide, performance-based certification program that validates the skills needed to get the most out of Microsoft Office and Windows Vista. Whether you want to stand out in the job market, improve your performance, or better prepare your students to enter the workforce, the Microsoft Certification program can help you attain the valuable expertise you need—and businesses rely on—to succeed."Microsoft Certification
"Some of them are pretty decent alternatives, not only for those who are not willing to spend the big bucks, but also for those who need some specific tasks done, like resizing a batch of picture without needing to run the almighty Photoshop."
". . . a new add-in named RDBMail for Excel/Outlook 2007-2016Code to send mail from Excel
RDBMail
The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options.
You have the option to send as workbook or PDF for every mail option."
"MIStupid.com is The Online Knowledge Magazine that publishes information that everyone should know, wants to know, or forgot.A few of the lessons include:
MIStupid.com was created in 2001 by Greg Renza with the desire to eradicate the world's stupidity."
"Microsoft IT created Work Smart productivity guides (previously Everyday Productivity Education (EPE) guides) to bridge the gap between technology and users. Work Smart guides provide employees with scenario-based, best-use productivity aids on Microsoft products and technologies. As more Work Smart guides are published, Microsoft IT expects to see more consistent, productive, and cost-effective use of products and technologies across the company."
". . . know what range is selected at any given time. You can look at the Name Box, but that only show the active cell."
"We have heard a few of you have missed the ALT D shortcut to open an object in design. As you know, ALT in ribbon apps now allows you to access ribbon shortcuts. Next time you want to open an object in design view, try Control Enter."Navigation pane tip
"Fold3 helps you find and share historic documents. We are able to bring you many never-before-seen historic documents through our unique partnerships with The National Archives, the Library of Congress and other institutions.
Our patented digitization process is helping bring other collections to life on the web everyday.
But Fold3 is more than just a dusty, digital archive online. We provide you the tools to share your historical passions and connect with others."
"(Jerry is) an all-American schlub . . . He has turned these degradations into an animated Web site appropriately named ItsJerryTime.com, on which he battles a cast of tormentors that includes the Meal Moth, his landlord and an alleged telephone conspiracy perpetrated by a duo of old ladies" Wall Street Journal
"PowerPoint Heaven is a PowerPoint entertainment portal for PowerPoint animations, games, artworks, showcases, animation templates and tutorials. The focus of this site is to maximize the use of Microsoft PowerPoint and go beyond its capability. Our goal is to show users that PowerPoint is not simply a presentation tool, but is also capable on leveraging into other areas such as creating games, artworks and animations."
"The story of vocalist Melody Gardot is as remarkable as any who perseveres against abject adversity. Born in New Jersey in 1985, she took up piano and played as a youngster on the nightclub scene of Philadelphia, influenced by jazz, folk, rock and pop musics. At age 19 she was a fashion student at the Community College of Philadelphia. But, on a fateful day, while riding her bicycle, the driver of a Jeep made an illegal turn, hurdling into Gardot and leaving her in the street for dead. Hospitalized for months with multiple head injuries and pelvic fractures, her love for music was the best therapy she could receive.
Her music could be described as a cross between Laura Nyro, Joni Mitchell, Eva Cassidy, and Shania Twain, but goes deeper than mere pop convention. ~ Michael G. Nastos, All Music Guide"
"Instead of telling your users to go out to Microsoft.com and do a search, put hyperlinks to the printer-friendly version of tip sheets and articles on your company's main portal page. Providing links to information you know they need will help you cover the training bases. And presenting the links on an internal web site they already use will show your users that it's okay to go outside of their four firewalls to learn something new. Include your favorite hyperlink in your signature line so it goes out in every e-mail you send."
"Your computer could fry if you don't keep it clean," says Jonathon Millman, chief technology officer for Hooplah Interactive.Here are some suggestions for Winter/Spring/Summer/Fall cleaning:
Dust clogs the vents behind your computer, which causes your CPU to heat up—and heat is the biggest cause of component failure in computers. Regular cleaning could save you costly maintenance fees down the road.
"Before you even open up PowerPoint, sit down and really think about the day of your presentation. What is the real purpose of your talk? Why is it that you were ask to speak? What does the audience expect? In your opinion, what are the most important parts of your topic for the audience to take away from your, say, 50-minute presentation?
Remember, even if you've been asked to share information, rarely is the mere transfer of information a satisfactory objective from the point of view of the audience. After all, the audience could always just read your book (or article, handout, etc.) if information transfer were the only purpose of the meeting, seminar, or formal presentation."
"The main intent of these tutorials is to guide frequent users of Microsoft Access through the transition of earlier versions to the new 2007 edition. Throughout the different tutorials . . . topics from program specifications through features added, dropped, or unchanged as well as demonstrating implementations of subjects discussed."
"ANVSOFT Flash Slide Show Maker is a Flash album creator that will help you build animated photo slideshows with SWF file as the output format."
. . . you can view your days and weeks in increments of 5 minutes, 60 minutes, and a variety of periods in between. You can adjust the view of your calendar according to your work week and work day; for instance, you can display Sunday through Thursday and show a normal day as being 11 in the morning to 7 in the evening if you like. Use different color schemes, and show more or less detail in your calendar.
"Excel doesn't have an easy way to append multiple text files into one worksheet through the user interface. From time to time I hear customers asking how to do this in an easy way. Do you have to use Access or VB code to solve this problem? No. There's a way to do it in Excel by using a simple SQL statement in the connection string."Use a text file:
"You can merge Microsoft Office Access 2007+ data with a Word 2007+ document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data."MailMerge Access-Word
"If you want to leave your Task Manager showing on your desktop for a period of time, it can be nice to hide the title bar and gain that space for displaying more information. To do this, simply double-click on the empty area to the right of the tabs. Once it has switched views, you can switch back quickly by double-clicking anywhere on the border."
"Ever wonder why some text seems easier to read than others? A few basic formatting changes can make reading text much easier. Factors like line spacing, font choice, font size and margins are key to legibility. "
"Signatures can be created in different formats and it can contain various elements. A basic signature will have just the sender’s name. Along with the name you can include acknowledgments like "Thank you", "Yours Lovingly", etc. Official or business signatures will have company name, contact number, company address, website URL, etc. Company logo or any other relevant graphic can also be used. Any text in the signature can be hyperlinked. Sometimes electronic business card or scanned signature is also used. The text of the signature can be formatted to make it more attractive. Occasionally signature will also contain disclaimer blocks like stating, "If you are not the intended recipient of the e-mail then you should delete the e-mail".
After completing this course you will be able to:Office.Microsoft.com/Training
Accomplish tasks by using sequential shortcut keys, known as Key Tips, shown on the Ribbon.
Navigate around the Ribbon using the TAB key and arrow keys.
Accomplish tasks by using key combinations — keys you press at the same time - exactly as you've done in previous versions of Office.
@echo off echo. echo Purging the print queue . . . net stop Spooler echo Deleting all print jobs . . . ping localhost -n 4 > nul del /q %SystemRoot%\system32\spool\printers\*.* net start Spooler echo Done! ping localhost -n 4 > nul
"Have you ever been asked to fill out a form in a word processor, only to discover that when you attempted to enter information, the lines on the form moved all over the page? Not to mention that the form was difficult and time-consuming to fill out? Most people don't realize that you can easily create professional-looking forms in Word."
"If the datasheet data for the category axis contains date number formatting, Microsoft Graph automatically uses a special type of axis in your chart called a time-scale axis.
A time-scale axis shows a blank category for dates for which you have no data. If you do not want to see these gaps — for example, if you have data for 1-Jan, 15-Jan, 3-Feb, 12-Feb, and 2-Mar, and you want to plot the days next to each other - you can change the time-scale axis to a standard category axis.
On the Chart menu, click Chart Options, click the Axes tab, and then click Category under Category (X) axis."
"If you wish to check your synchronization settings, look for the clock at the bottom right and double click on the time to bring up your time settings.
- You can adjust your local time and date by hand on the first tab,
- you can adjust your time zone location on the second,
- and on the third, labeled Internet Time, you can view your current atomic clock sync settings."
"The audio portions of the WWV and WWVH broadcasts can also be heard by telephone.
The time announcements are normally delayed by less than 30 ms when using land lines from within the continental United States, and the stability (delay variation) is generally 1 ms.
When mobile phones are used, the delays are often more than 100 ms due to the multiple access methods used to share cell channels.
In rare instances when the telephone connection is made by satellite, the time is delayed by 250 to 500 ms.
To hear these broadcasts, dial (303) 499-7111 for WWV (Colorado), and (808) 335-4363 for WWVH (Hawaii). Callers are disconnected after 2 minutes. These are not toll-free numbers; callers outside the local calling area are charged for the call at regular long-distance rates.
Montreal, 1997. Lullaby Baxter is waiting tables at Jello Bar. Coaxed on stage for an impromptu number, she sings Billie Holiday's signature song "Lover Man (Oh, Where Can You Be?)". This, her first public performance since grade school, brings down the house.
She buys a green guitar and learns "Leaving On A Jet Plane". Someone at the Laundromat says, "Anyway, try writing songs."
" Fair use is a copyright principle based on the belief that the public is entitled to freely use portions of copyrighted materials for purposes of commentary and criticism. For example, if you wish to criticize a novelist, you should have the freedom to quote a portion of the novelist's work without asking permission. Absent this freedom, copyright owners could stifle any negative comments about their work.
Unfortunately, if the copyright owner disagrees with your fair use interpretation, the dispute will have to be resolved by courts or arbitration. If it's not a fair use, then you are infringing upon the rights of the copyright owner and may be liable for damages."
Sub ListFields() Dim dbs As DATABASE Dim dbfield As Field Dim tdf As TableDef Set dbs = CurrentDb Set tdf = dbs.TableDefs!NAMEOFYOURTABLE Debug.Print "" Debug.Print "Name of table: "; tdf.Name Debug.Print "" For Each dbfield In tdf.Fields Debug.Print dbfield.Name Next dbfield End Sub
"A link is a formula that gets data from a cell in another workbook. When you open a workbook that contains links (a linking workbook), Microsoft Excel reads in the latest data from the source workbook or workbooks (updates the links).
Use links when you want to maintain information in a single workbook, but also use the information in other workbooks. For example, if your product prices change frequently, you might keep a master price list.
Other workbooks that use the price data in calculations, such as purchase orders, inventory valuations, or sales estimates, can create links to the price list workbook so calculations always use current prices. When prices change, you only have to enter the new prices in one place."
"C:\Program Files\Internet Explorer\iexplore.exe" nohome
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Tips]
"This macro outline allows the user to use Word's "Send To PowerPoint" feature, then run this macro to get notes from MS Word to PowerPoint as notes. The macro allows you to set the text level you want to become the notes."
The fire is the wrong place for other holiday detritus as well - der Tannenbaum, for example.
My assistant Una had an Uncle Bob, a manly man who felt throwing the Christmas tree away was a waste of good firewood. So he tossed it in the fireplace - gave him a nice warm glow.
- Unfortunately
- what was glowing was the roof, presumably ignited by embers.
- Fortunately
- the fire was small and anybody with a hose could have put it out.
- Unfortunately
- the hose was frozen solid and the fire department had trouble getting the nearest hydrant to work.
- Fortunately
- the firefighters were able to throw a ladder up against the house and put out the fire with a chemical extinguisher. They then hacked off a small hunk of charred roof with axes, peered into the crawl space, and declared the fire out.
- Unfortunately,
- having by now found an operational hydrant, the firemen declared they needed to hose down the roof "as policy," sending a torrent of water through the hole and collapsing the living room ceiling.
- Really unfortunately,
- the house that all this happened in belonged not to Uncle Bob but his in-laws. Bob bought them an RV and matters were pronounced square, but it was a lesson he won't soon forget, and neither should you.
" Email is a quick, cheap and easy means of communication. This makes email a great business tool, but at the same time a potential threat for employers. Email threats such as confidentiality breaches, legal liability, lost productivity and damage to reputation cost companies millions of dollars each year.
How can a company protect itself from these threats? The first step in securing your company is to create an email usage policy. After you have created your email policy you must make sure it is actually implemented. This can be done by giving regular trainings and by monitoring employees' email using email security software. "
This hilarious clock is the perfect accessory for any Excel power user. Each numeral has been replaced with a suitable Excel function that will evaluate to that numeral.
We've used one function from as many function categories as possible to really provide a broad range of functions.
=FACT(3) - The FACT() function returns the Factorial of a number. The Factorial of 10 is 10x9x8x7x6x5x4x3x2x1. This function is great for statisticians calculating combinations and permutations. In our case, the Factorial of 3 is 3x2x1 or 6
=Row()works just fine.
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")
=ADDRESS(row_num,column_num,abs_num)
SUBSTITUTE(text,old_text,new_text)
"Sometime before the year 3,000, Microsoft will hopefully increase the number of columns in Excel (Hey, I can dream can't I). The challenge before you is to write a function that converts a column number to its letter equivalent assuming columns go to ZZZZ. That’s about 450,000 columns - maybe more than I need."
