EXCEL 2007/2010 - Time Saving Tips & Tricks - tutorial

1. Introduction
2. Controlling the Worksheet View 
3. Quickly View ALL Sheets in a Workbook
4. Viewing Worksheets in Multiple Windows
5. Splitting the Worksheet Window into Panes
6. Keeping Column or Row headings in view using Freeze Panes 
7. View All Open Workbooks
8. Hiding and Un-hiding a Worksheet
9. Hide & Un-hide Columns & Rows
10. Working With Ranges
11. Enter same data in multiple cells at once
12. Selecting Ranges: Keyboard or Mouse
13. Selecting Nonadjacent Ranges
14. Repeating Row and Column Labels on each page
15. Using Page Break Preview
16. Changing Text Alignment & Text Angle in a Cell 
17. Horizontal & Vertical Alignment Options 
18. Displaying text at an angle 
19. Wrapping or Shrinking text to fit the cell 
20. Merging Cells into One Cell
21. Text Functions
22. Convert Text to Columns
23. Change Format of Text List 
24. Other Cool Stuff to know 
25. Easy Fractions 
26. Instant Zoom 
27. Conditional Formatting 
28. Insert a Cell Comment (Note)
29. Quickly view Average, Sum, Count Information for a set of data 
30. Use AutoFill to quickly complete a data pattern 
31. Copy visible data in a spreadsheet with hidden columns or rows 

How to use Microsoft Excel 2007 - tutorial

Microsoft Office Excel is a powerful tool used to create and format spreadsheets. Spreadsheets allow information to be organized in rows and tables and analyzed with automatic mathematics. Spreadsheets are commonly be used to perform many different types of calculations.

In this tutorial, learn how to:

Navigate Cells
Manipulate Data
Use Formulas and Functions
Create Charts and Tables
Contents

Getting Started
Data and Formulas
Charts
Pivot table
Trouble-shooting
Printing

Microsoft Word 2010 - tutorial

Table of Contents

• Objectives for Word 2010 Concepts
• Objectives for Microsoft Word 2010 Document Layout
• Objectives for Microsoft Word 2010 Mail Merge and Forms
• Word 2010 Components
• Ribbon and Tabs
• Word 2010 and Compatibility
• Plan Your Document Layout
• Set Up the Document Layout – Page Layout Tab
• View a Document – View Tab
• Save a Document – File Tab 
• Cut, Copy and Paste – Home Tab
• Format a Document – Home Tab
• Insert an Image – Insert Tab
• Format a Table – Table Tools Tab
• Add Columns – Page Layout Tab
• Apply a Text Style – Home Tab
• Apply the Format Painter – Home Tab
• Insert a Table of Contents – Reference Tab
• Data Source Document 
• Insert a Screenshot – Insert Tab

Thanks to people (like you?) Who share their knowledge, you can discover the extent of our being selected to easily learn without spending a fortune! Microsoft Word 2010. is available for free by its author. But also many other tutorials are accessible just as easily!

Excel 2010 Advanced - tutorial

Table of contents

Introduction
section 1 advanced worksheet functions
section 2 views, scenarios, goal seek, solver
section 3 using excel to manage lists
section 4 charts
section 5 templates 
section 6 drawing and formatting
section 7 excel tools

It is time to learn, all for free! To get here, nothing more simple, the Internet in search of the best courses and tutorials Excel searched for example Excel 2010 Advanced ...

Thanks to people (like you?) Who share their knowledge, you can discover the extent of our being selected to easily learn without spending a fortune! Excel 2010 Advanced. is available for free by its author. But also many other tutorials are accessible just as easily!

Computer PDF guide you and allow you to save on your studies.

- Excel 2010 Advanced. help on the contact form if problems

Computer PDF is also courses for training in Excel 2007, 2010, 2013, 2016, charts, PivotTables and PivotCharts, Formulas, Data and Statistics, Pivot Tables, VLOOKUP, and IF functions and many others IT.

You should come see our Excel documents. You will find your happiness without trouble !

The latest news and especially the best tutorials on your favorite topics, that is why Computer PDF is number 1 for courses and tutorials for download in pdf files - Excel 2010 Advanced. and Excel!

Advanced Microsoft Excel 2013 - tutorial

Microsoft Excel is program designed to efficiently manage spreadsheets and analyze data. It contains both basic and advanced features that anyone can learn. Once some basic features are known, learning the advanced tools becomes easy. This lesson is composed of some advanced Excel features. It assumes basic prior knowledge of Excel, and it is expected that the objectives from AT Step’s Excel Essentials are known. This lesson will talk about the advanced customization and formatting features that allow for easier data manipulation and organization.
Objectives
1)  Learn how to Customize the Interface
2)  Advanced Formatting: Custom Lists, Cell Groups, and Transposing Tables
3)  Learn how to Reference Across Sheets
4)  Advanced Formulas and Using Data Ranges
5)  Using Data Validation 
Thanks to people (like you?) Who share their knowledge, you can discover the extent of our being selected to easily learn without spending a fortune! Advanced Microsoft Excel 2013. is available for free by its author. But also many other tutorials are accessible just as easily!

Computer PDF guide you and allow you to save on your studies.
- Advanced Microsoft Excel 2013. help on the contact form if problems

Computer PDF is also courses for training in Excel 2007, 2010, 2013, 2016, charts, PivotTables and PivotCharts, Formulas, Data and Statistics, Pivot Tables, VLOOKUP, and IF functions and many others IT.
You should come see our Excel documents. You will find your happiness without trouble !

The latest news and especially the best tutorials on your favorite topics, that is why Computer PDF is number 1 for courses and tutorials for download in pdf files - Advanced Microsoft Excel 2013. and Excel!

How To Make A Pendrive Bootable Using CMD

Click Start -> All Programs -> Accessories and right-click on Command Prompt. Select Run As Administrator. Of course, you need to be able to authenticate as the administrator on the PC you’re using.
For Windows 8/8.1/10 alternative shortcut to access cmd as admin is to simply press windows key + x and it will pop up a menu in the left side of the screen and you can access run as administrator from there.

Partitioning The Disk

1

TYPE :  DISKPART

This will open ups the Partitioning Application >

2

TYPE :  LIST DISK

Figure out which of the drives listed is your USB drive, and note the number. It’s crucial you get this right, or you’re going to end up losing data on other drives.

Now type the following series of commands below :

Let me clarify you > Here, my disk is number '1".means that is my pendrive and Disk '0" means my Hard Drive .Don’t confuse this with PARTITION 1. That number does not change, even if your disk is 3. So use only one usb at a time to avoid confusion.

3

SELECT DISK 1

CLEAN

CREATE PARTITION PRIMARY

SELECT PARTITION 1

ACTIVE

FORMAT FS=NTFS 

( Here you have to wait for nearly 30 mins to complete upto 100% and then only enter the below commands )

ASSIGN

EXIT

4

MAKE IT BOOTABLE :

When you’re done, put in your installation DVD if you haven’t already. Note down which drive letter your USB disk and Windows installation DVD are located at.

Go back to you command prompt box and type assuming letter  "D"  is your DVD Drive  and example "X" is your USB Drive.

5

 TYPE >       D:/BOOT/BOOTSECT.EXE /NT60 X:

This will basically make your USB drive bootable.

6

COPY EVERYTHING 

The final step can be done from My Computer. Just open up the installation DVD highlight everything and drag it to your USB Drive.

Now you should be all set – just insert the USB disk into your new PC, and enter the BIOS to adjust the boot order, or choose the option during start up which says Choose Boot Device.

How to clear an unknown BIOS or CMOS password

Sometimes, users encounter a password prompt at boot or the BIOS or CMOS setup is locked (as can be seen in the image below). If you do not know the BIOS password, you'll need to clear it. The following sections contain instructions on how to do so using multiple methods.

Clear using jumper (recommended)

Caution: When working inside a computer, be sure you're aware of the potential damage that can be caused by ESD.
Computer jumperOn the computer motherboard locate the BIOS clear or password jumper or dip switch and change its position. This jumper is often labeled CLEAR, CLEAR CMOS, JCMOS1, CLR, CLRPWD, PASSWD, PASSWORD, PSWD or PWD. To clear, remove the jumper from the two pins currently covers the replace it over the other two. An example of the various jumper positions may be seen in the image to the right. Some computers may also clear the password by keeping the jumper open (one or no pins covered).
What if I can't locate the CMOS password jumper?
The following list details the general locations for the CMOS jumper. It's important to realize that most motherboards have dozens of different jumpers, so you need to make sure you're changing the correct one. If you are unable to find the password jumper, consult your motherboard's documentation by looking in the manual or downloading it from the manufacturer's website.
On the edge of the motherboard - Most jumpers are located on the side of the motherboard for easy accessibility; verify by looking at all visible edges of the motherboard.
By the CMOS battery - Some manufactures place the jumper to clear the CMOS or BIOS password by the CMOS battery itself.
By the processor - Some manufactures place the jumpers by the CPU of the computer.
Under the keyboard or bottom of laptop - If you are working on a laptop, the location of the dip switch can be under the keyboard or on the bottom of the laptop. It is usually located in a compartment such as the one that contains memory. (Laptops almost always use dip switches, not jumpers.)
Once the appropriate jumper or dips switch has been located and toggled, the password should be cleared. Turn your machine on to verify that the password has bee reset. Once cleared, turn the computer off and return the jumper or dip switch to its original position.
CMOS batteryRemoving the CMOS battery like the one shown in the picture causes the system to lose all CMOS settings; including the password. To do this, locate and remove the CMOS battery from the motherboard for at least five minutes, then replace the battery and turn the computer back on.
Generic passwords

Try using generic CMOS passwords. It should be noted that many of these default passwords are for older motherboards and no longer work with newer machines.
Jump the CMOS solder beads
Older computers, especially older laptops, don't have jumpers or dip switches. They require the user to jump a pair of solder beads on a circuit board. The identification and location of these solder beads can vary and if not available in computer documentation, is only obtainable through the computer manufacturer.
If you've identified the solder beads, they can be jumped by placing a flat-head screwdriver over the two beads and leaving it on those beads while turning on the computer. Once the computer has booted, turn it off and then remove the screwdriver.

What are the F1 through F12 keys?

Commonly known as function keys on a computer keyboard, F1 through F12 may have a variety of different uses or no use at all. The operating system installed on the computer and the software program currently open can change how each of these keys operate. A program is capable of not only using each of the function keys, but also combining the function keys with the ALT or CTRL key. For example, Microsoft Windows users can press ALT + F4 to close the program currently active.
Note: Some keyboards include additional functions on the function keys, which can be activated by pressing the FN key, usually located near the CTRL key, and the appropriate function key. The additional functions available with the use of the FN key will differ depending on the type and brand of keyboard being used. Please check your computer's documentation or manufacturer's website for specific details on which features are available on your keyboard function keys with the use of the FN key.
Tip: Some computers may automatically enable the FN key for accessing the special functions on the F1 through F12 keys. You may be able to turn off the FN key by accessing the keyboard settings in the Control Panel.
If your keyboard does not have a row of function keys, they are probably set up as secondary functions on other keys. Some laptop keyboards are set up this way to save space. They can be activated by pressing another key plus the key with the secondary F key functionality.
Below is a listing of some of the more common functions of the functions keys for Microsoft Windows and Microsoft applications, as well as some for Mac OS. As mentioned above, not all programs support these function keys and the function keys on your keyboard may perform different tasks then those mentioned below.
Tip: If you are looking for specific shortcut keys and function key examples, please visit our shortcut key page.
F1
Almost always used as the help key, almost every program opens a help screen when this key is pressed.
Enter CMOS Setup.
Windows Key + F1 would open the Microsoft Windows help and support center.
Open the Task Pane.
F2
In Windows renames a highlighted icon, file, or folder in all versions of Windows.
Alt + Ctrl + F2 opens document window in Microsoft Word.
Ctrl + F2 displays the print preview window in Microsoft Word.
Quickly rename a selected file or folder.
Enter CMOS Setup.
F3
Often opens a search feature for many programs including Microsoft Windows when at the Windows Desktop.
In MS-DOS or Windows command line F3 will repeat the last command.
Shift + F3 will change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.
Windows Key + F3 opens the Advanced find window in Microsoft Outlook.
Open Mission Control on an Apple computer running Mac OS X.
F4
Open find window in Windows.
Open the address bar in Windows Explorer and Internet Explorer.
Repeat the last action performed (Word 2000+).
Alt + F4 closes the program window currently active in Microsoft Windows.
Ctrl + F4 closes the open window within the current active window in Microsoft Windows.
F5
In all modern Internet browsers, pressing F5 will refresh or reload the page or document window.
Open the find, replace, and go to window in Microsoft Word.
Starts a slideshow in PowerPoint.
F6
Move the cursor to the address bar in Internet Explorer, Mozilla Firefox, and most other Internet browsers.
Ctrl + Shift + F6 opens to another open Microsoft Word document.
Reduce laptop speaker volume (on some laptops).
F7
Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.
Shift + F7 runs a Thesaurus check on the word highlighted.
Turns on Caret browsing in Mozilla Firefox.
Increase laptop speaker volume (on some laptops).
F8
Function key used to enter the Windows startup menu, commonly used to access Windows Safe Mode.
Used by some computers to access the Windows recovery system, but may require a Windows installation CD.
Displays a thumbnail image for all workspaces in Mac OS.
F9
Refresh document in Microsoft Word.
Send and receive e-mail in Microsoft Outlook.
Opens the Measurements toolbar in Quark 5.0.
Reduce laptop screen brightness (on some laptops).
With Mac OS 10.3 or later, displays a thumbnail for each window in a single workspace.
Using the Fn key and F9 at the same time opens Mission Control on an Apple computer running Mac OS X.
F10
In Microsoft Windows activates the menu bar of an open application.
Shift + F10 is the same as right-clicking on a highlighted icon, file, or Internet link.
Access the hidden recovery partition on Compaq, HP, and Sony computers.
Enter CMOS Setup on some computers.
Increase laptop screen brightness (on some laptops)
With Mac OS 10.3 or later, shows all open Windows for the active program.
F11
Enter and exit full screen mode in all modern Internet browsers.
Ctrl + F11 as computer is starting to access the hidden recovery partition on many Dell computers.
Access the hidden recovery partition on eMachines, Gateway, and Lenovo computers.
With Mac OS 10.4 or later, hides all open windows and shows the Desktop.
F12
Open the Save as window in Microsoft Word.
Ctrl + F12 opens a document In Word.
Shift + F12 saves the Microsoft Word document (like Ctrl + S).
Ctrl + Shift + F12 prints a document in Microsoft Word.
Preview a page in Microsoft Expression Web.
Open Firebug or browser debug tool.
With an Apple running Mac OS 10.4 or later, F12 shows or hides the Dashboard.
Access the list of bootable devices on a computer at startup, allowing you to select a different device to boot from (hard drive, CD or DVD drive, floppy drive, USB drive, and network).

Hidden iPhone Features That Are Really, Truly Hidden

Each of the tips that follow below, however, are completely hidden. There is no indication that these functions exist in iOS, and i guarantee that most users don’t know about them. In fact, we also guarantee that even the savviest iPhone owners among you will find at least one or two things you didn’t already know. In fact, ran this list past a friend who works at Apple and there were a few things that even he didn’t know.
Well, in this piece we’re going to find out  about 25 hidden features that are really, truly hidden. As in, you could look through your iPhone from now until the end of time and you wouldn’t find any of these tricks unless you know what you’re looking for.
Enjoy.
Redial: In the Phone app, press the green call button on the keypad screen to make the last dialed number appear.

Clear cache: Make your iPhone run faster by clearing out the cache in several of Apple’s apps using a secret trick. In the App Store, Podcasts, Music, Game Center and Phone apps, tap on any single tab icon at the bottom of the screen 10 times in a row.

Make TouchID work faster: Save the same fingerprint multiple times as different entries and TouchID will work much faster. This is especially useful on older phones like the iPhone 6 and iPhone 5s.

Spotlight conversions: It’s even easier for iPhone users — just open Spotlight and type something like “20 euros in GBP,” and it will instantly perform the conversion.

Spotlight math: Want to do a quick math problem? No need to open the Calculator app, just pull down to open Spotlight and type it right there.

Delete numbers in the Calculator: Speaking of the Calculator, you can delete single digits when you tap the wrong number by swiping left or right on the screen where the numbers appear.

Clear RAM to make your phone run faster: Hold down the power button until you see “Slide to power off,” then let go and hold down the home button until the screen goes blank and your home screen reappears.

Burst mode: Hold down the camera’s shutter button to shoot in burst mode.

Remote shutter: Use the volume up or down button on your headphones to snap a photo in the Camera app.

Turn the flashlight off: How many times have you turned your flashlight on and wished that you didn’t have to swipe open the Control Panel again to shut it off? We’ll save you a step: simply swipe up on the camera icon on your lock screen and the flashlight will turn off.

3D Touch while drawing: All of the drawing tools and the eraser are pressure sensitive in the Notes app.

Close multiple apps at once: Double-tap the home button to open the app switcher and you can use two, even three fingers to slide multiple apps closed with one swipe.

Recently closed tabs: Want to reread this article on your phone but you forgot what site you were reading it on in the first place? Simply tap and hold on the + symbol in Safari on the tab carousel view to open a screen that lists all of your recently closed tabs.

Desktop version of a site: We all know you can request the desktop version of a mobile site in Safari but it’s easier to do than you think. Just hold down the reload button in the URL bar.

Peek at tabs: Not sure you want to open that tab in the Safari tab carousel? A 3D Touch will let you Peek at it first.

Peek at bookmarks: Did you know you can use 3D Touch to Peek at bookmarks before you open them?

Edit reminders: 3D Touch an item in your Reminders app to edit the time or add a location.

Quick Reply: When you get a notification at the top of the screen that you have a new iMessage or SMS, pull the notification downward to reply without leaving the screen you’re on.

Hidden level(s): Slide to the left in the Compass app open the level. Then place your phone flat with the screen facing away from the ground to reveal a bubble level.

Artist Peek: 3D Touch an artist in the Music app to Peek at their music.

Reenable Low Power Mode: When Low Power Mode automatically shuts off as you charge, you’ll get a notification on your lock screen that it has been disabled. Swipe left on that notification to turn it back on.

Find an iPhone’s owner: Did you find a lost iPhone in a bar? Simply ask Siri, “whose phone is this?” and it will show you so you can get in touch with him or her and return it.

Reachability: This is one of the new iPhones’ best features and there are still SO many people who don’t know about it. Double-touch (don’t tap, touch) on the home button and the entire screen will shift down so you can reach the top without shifting your grip.

Mac OS X Hidden Features (With GIFs)

All the “hidden” features below are standard Mac functionality, so no additional software is required. The only thing you need (for most of them) is simply a copy of Mac OS X El Capitan.
Also, feel free to share this list with your Windows-loving friends. Maybe it will make them think twice before buying a new Windows computer.
# Open finder folder in new window

To open a folder in a new window or new tab, double-click it while holding ⌘, much like you would do in Chrome, Safari or Firefox to open a page in a new tab.

# Hot Corners

Hot corners allow you to trigger certain events by touching a corner of your screen. You can start and disable a screensaver, open mission control, application windows, show the desktop, dashboard, notification center or lauchpad or put your display to sleep.

To avoid triggering Hot Corners accidentally, you can assign a key to hold down to trigger an action.

To open Hot Cornets settings go to System Preferences > Desktop & Screen Saver > Screen Saver tab > Hot Corners…

# Create more screen space with Retina Screen Macs

If you own a Mac with a Retina display you can scale the screen to create more screen space for you to work with. This feature also works if you have a second monitor connected to your main Retina device. Usually, if you’re using the “More Space” scaled resolution and connect a second screen, it will jump back to the standard setting. To get more space again, visit the settings and adjust the display scaling one more time.

If you’re changing the scaling of your Retina screen often, the quickest and easiest way for you to access the menu is by pressing ⌥ + F1 or F2 (screen brightness up/down keys).

# Quickly summarize text

Mac OS X allows you to quickly summarize long pieces of text in just a few seconds. To summarize a text first select it, right click on the selection and click on “Summarize”. To enable the summary feature, click on the app name in the status bar (“Chrome” for instance) > Services > Services Preferences… >  scroll down and check “Summarize”.
# Rename and move iWork documents

Rename and move Pages, Keynote or Numbers documents right from the menu bar. To move a document click and hold the icon, then drag it wherever you want while holding ⌥.

# Change volume and brightness in quarter-step increments

Hold ⇧ + ⌥ and change your brightness in smaller increments for more control. Unfortunately, this doesn’t work anymore for the lowest brightness “section”. If you want to dim your screen even further at night, I suggest that you download F.lux to reduce eye stress.
The latest Mac OS versions don’t play a sound then adjusting the volume. If you want to hear it to check your sound levels, hold the Shift key (⇧) while changing it.
# Move selected text to create a new text file

Select text anywhere, click & hold and move it where you need to create a net text file with the selected text inside.

# Amazing screenshot functionality

⌘ + ⇧ + 3 Capture entire screen + save

⌘ + ctrl + ⇧ + 3 Capture entire screen + copy to the clipboard

⌘ + ⇧ + 4 Capture dragged area + save (the one I use the most)

⌘ + ctrl + ⇧ + 4 Capture dragged area + copy to the clipboard

⌘ + ⇧ + 4 then Space Capture a window +save

⌘ + ctrl + ⇧ + 4 then Space Capture a window + copy to the clipboard

A nice addition to this feature is the ability to share the screenshot instantly using Dropbox. After making a screenshot, Dropbox will automatically create a sharable link for you and copy it to your clipboard, that you can send to anyone instantly

# Dictation – type with your voice

Dictation works surprisingly well on Mac OS X. Just press the function (fn) key twice, start speaking and press fn one more time to convert speech to text.

What’s even more awesome is a feature called Enhanced Dictation. With this feature you can not only use all dictation features offline, but also get live feedback, do edits while recording, and then continue dictating your text. From my experience, Enhanced Dictation works much faster, almost instantly. You can aslo dictate longer sentences in a single go, because your Mac doesn’t need to send the audio file to Apple servers to convert it into text. Be warned, though. The offline dictation pack is around 700MB, so you’ll need to have this space available on your Mac.

To enable Enhanced Dictation simply go to your Settings > Dictation & Speech, and then check the box Use Enhanced Dictation. You’ll be prompted to download the additional files onto your machine. Once everything is downloaded, go ahead and give it a shot! You will see, that words will appear almost instantly as you speak. As a matter of fact, I have dictated this whole section of this post using Enhanced Dictation with a few edits here and there, like capitalizing letters and adding formatting.

# Preview any file with space bar

You can preview any file (even Photoshop files and videos) by selecting it and pressing the spacebar. Press it again to close the preview. While in the preview you can also press the arrow keys to change between files. This works especially great if you made tons of pictures on your last trip with your family, and need a quick way to select a few good ones to upload to Facebook.

The Space Bar Preview function also works with some video formats, that allows you to have quick glances of what’s inside the video file.

# Quickly close or hide lots of running apps

To close a lot of running apps, simply hold ⌘+tab, keep holding ⌘ and keep “tabbing” through the apps. As soon as you reach the app you want to close or hide, press whether Q to quit or H to hide the app.

# Built-in Mac emoji

In case you didn’t know, OS X comes with built in emoji. Like the ones you have in iOS. Simply press ctrl+⌘+space to open the special characters window and choose the one you need!