Serving Athboy & Surrounding Areas
087 835 8635

Teresa Coleman Computer TutorWant to get more out of your PC, laptop or mobile phone? Teresa Coleman offers a tutoring service aimed at those who want to develop their computer skills and gain confidence with everyday tasks including email, the internet, Social Media, printing, creating documents, spreadsheets and much more.

One to one and group training options are available.

Course Selection

  • Computer Tutoring
    Learn how to use your Windows PC or laptop more effectively. Manage files, send and receive emails, use the internet, create documents and print them.
  • Social Media for Beginners
    Get started on Facebook, Twitter, Instagram, Snapchat, LinkedIn and other Social Media platforms. What are they? How do you use them? What about safety and privacy?
  • Microsoft Excel for Beginners / Improvers
    Learn how to create and manage spreadsheets. Includes formulae, functions, charts and printing.
  • Microsoft Excel Consultancy
    Helping you to get the most from Excel in your business. Learn how to use Excel to solve specific problems for project work, data management, cleansing, import and export.
  • Tutoring on specific Excel topics
    Learn how to create formulae, charts, pivot tables, VLOOKUPs or any other advanced topics in Microsoft Excel.

Contact Teresa

For further information about the courses available or to enquire about your specific needs, please call 087 835 8635.

Find Teresa Coleman Computer Tutor on Facebook

Excel on Windows Tip of the Week:

The Excel menus across the top of the screen are known as the "Ribbon".
If you accidentally collapse the Ribbon so that only the names of the tabs are being shown (the options underneath the tabs are not shown) and you want Excel to display the full Ribbon again,

EITHER
1. Click on the Home tab name to show the Ribbon again temporarily, then click on the PIN icon on the bottom right of the Ribbon to PIN it back in place
OR
2.Press CTRL+F1 to open and PIN the Ribbon back in place. On some PCs and laptops you may have to press the FN key as well.

How did you accidentally collapse the Ribbon?
By clicking on the Collapse Ribbon button which is shown instead of the PIN button when the Ribbon is PINned in place OR by pressing CTRL+F1.
... See MoreSee Less

Excel on Windows Tip of the Week:

The Excel menus across the top of the screen are known as the Ribbon.
If you accidentally collapse the Ribbon so that only the names of the tabs are being shown (the options underneath the tabs are not shown) and you want Excel to display the full Ribbon again,

EITHER 
1. Click on the Home tab name to show the Ribbon again temporarily, then click on the PIN icon on the bottom right of the Ribbon to PIN it back in place 
OR 
2.Press CTRL+F1 to open and PIN the Ribbon back in place. On some PCs and laptops you may have to press the FN key as well.

How did you accidentally collapse the Ribbon?
By clicking on the Collapse Ribbon button which is shown instead of the PIN button when the Ribbon is PINned in place OR by pressing CTRL+F1.

👩‍🏫 Keyboard shortcut of the week:

CTRL+HOME - takes you to the top of your document
... See MoreSee Less

 

Comment on Facebook

Ah, I've a mac tho....

I've been teaching Microsoft Excel over the past few months, to both beginners and experienced users, and have been reminded how easy it is when learning a product to miss out on some fundamental functions that can make life easier and save time.

So, over the next few weeks I'm going to publish a few short articles to explain some of those fundamentals. While I'll be using Excel 2016 for any examples I show, many of these functions have not changed since Excel was released in 1987.

Today's article is on selecting parts of a worksheet. This is something that is usually taught at the very beginning of an Excel course, and parts of it are sometimes forgotten as students focus on more complex concepts.

....
Selecting areas of a worksheet:

Excel performs actions on cells you have selected e.g. copy or cut the cells or format them. You can select a single cell, a range of cells (a rectangular group of cells), a row, multiple rows, a column, multiple columns or a whole worksheet. You can also select multiple ranges at the same time, including combinations of ranges, rows and columns.

To select a single cell, click on it.

To select a range (a rectangle of cells), click on a cell that forms one corner of the rectangle, hold down the mouse key and drag the mouse over to the opposite corner of the rectangle then release the mouse key. For beginners this can take a bit of practice.

Select a column by clicking on the column header at the top of the worksheet. The whole column will be highlighted.

Select multiple columns by clicking on the first column header, holding down the mouse key and dragging the selection left or right to cover multiple columns. The group of columns will be highlighted.

Select a row by clicking on a row header at the left of the worksheet.

Select multiple rows by clicking on the first row header, holding down the mouse key and dragging the selection up or down to cover multiple rows. The group of rows will be highlighted.

Select an entire worksheet by clicking the grey triangle above the first row header and to the left of the column A header. The entire worksheet should be highlighted.

Select multiple groups of cells at the same time by selecting the first range, then holding down the CTRL key and selecting the next range. Keep holding down the CTRL key until you have selected all of the ranges, rows and columns that you want, then release it. All of the ranges will be highlighted.
... See MoreSee Less

Ive been teaching Microsoft Excel over the past few months, to both beginners and experienced users, and have been reminded how easy it is when learning a product to miss out on some fundamental functions that can make life easier and save time.

So, over the next few weeks Im going to publish a few short articles to explain some of those fundamentals. While Ill be using Excel 2016 for any examples I show, many of these functions have not changed since Excel was released in 1987.

Todays article is on selecting parts of a worksheet. This is something that is usually taught at the very beginning of an Excel course, and parts of it are sometimes forgotten as students focus on more complex concepts.

....
Selecting areas of a worksheet:

Excel performs actions on cells you have selected e.g. copy or cut the cells or format them. You can select a single cell, a range of cells (a rectangular group of cells), a row, multiple rows, a column, multiple columns or a whole worksheet. You can also select multiple ranges at the same time, including combinations of ranges, rows and columns.

To select a single cell, click on it.   

To select a range (a rectangle of cells), click on a cell that forms one corner of the rectangle, hold down the mouse key and drag the mouse over to the opposite corner of the rectangle then release the mouse key. For beginners this can take a bit of practice.

Select a column by clicking on the column header at the top of the worksheet. The whole column will be highlighted. 

Select multiple columns by clicking on the first column header, holding down the mouse key and dragging the selection left or right to cover multiple columns. The group of columns will be highlighted.

Select a row by clicking on a row header at the left of the worksheet. 

Select multiple rows by clicking on the first row header, holding down the mouse key and dragging the selection up or down to cover multiple rows. The group of rows will be highlighted.

Select an entire worksheet by clicking the grey triangle above the first row header and to the left of the column A header. The entire worksheet should be highlighted.

Select multiple groups of cells at the same time by selecting the first range, then holding down the CTRL key and selecting the next range. Keep holding down the CTRL key until you have selected all of the ranges, rows and columns that you want, then release it.  All of the ranges will be highlighted.