Are you over 18 and want to see adult content?
More Annotations
A complete backup of www.pocket-lint.com/phones/news/samsung/151042-official-samsung-galaxy-s20-trailer-leaked-see-the-flagship-
Are you over 18 and want to see adult content?
A complete backup of www.bostonglobe.com/sports/bruins/2020/02/11/louis-anaheim-game-postponed-after-jay-bouwmeester-collapses-b
Are you over 18 and want to see adult content?
A complete backup of www.indiatoday.in/technology/news/story/redmi-9a-redmi-powerbank-to-launch-today-expected-price-features-an
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of https://deltaculturalcenter.com
Are you over 18 and want to see adult content?
A complete backup of https://novogene.com
Are you over 18 and want to see adult content?
A complete backup of https://photobookamerica.com
Are you over 18 and want to see adult content?
A complete backup of https://thesweetestoccasion.com
Are you over 18 and want to see adult content?
A complete backup of https://ebates.com
Are you over 18 and want to see adult content?
A complete backup of https://radioalianca.com.br
Are you over 18 and want to see adult content?
A complete backup of https://hydropolis.pl
Are you over 18 and want to see adult content?
A complete backup of https://dmlawfirm.com
Are you over 18 and want to see adult content?
A complete backup of https://thehempnurse.com
Are you over 18 and want to see adult content?
A complete backup of https://foreign.gov.tt
Are you over 18 and want to see adult content?
A complete backup of https://amerikanki.com
Are you over 18 and want to see adult content?
Text
CRYSTAL REPORTS
I was training Crystal Reports this week and we produced a chart where a lot of the values were zero which made the chart rather messy. We were charting Last Year's Sales by field Region from the Customer table. Create a new formula field, No Sales Region If Sum({Customer.Last Year’s Sales},{Customer.Region})=0 then {Customer.Region} Go intoMICROSOFT OFFICE
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.MICROSOFT WORD
To insert a watermark into a document on the Design tab, in the Page Background group, click the Watermark dropdown and select your required watermark. This will appear on the first page of the document. If you want it to appear on every page in the document, from the Watermark dropdown, click Custom Watermark.The Custom Watermark dialog box will be displayed.MICROSOFT PROJECT
Click the View tab on the ribbon, select the Tables command and click Tracking. . You can type information into the following columns: Act. Start The actual date the task started. Act. Finish The actual date the task was completed. % Comp. If the task isMICROSOFT PROJECT
Click Formula, then from the Function dropdown, select ProjDateAdd. For the date part, from the Field dropdown, select Project – Date – Current Date. For duration we need 90 (days in three months) multiplied by Field – Project – Number – Minutes per day. Click OK twice. From the View tab and the Filter dropdown, select NewFilter.
MICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT WORD
When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the Styles group on the Home tab.. To add any built-in style to the Styles Gallery, provided you are using Microsoft Word 2007 or Microsoft Word 2010, click on the little arrowMICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. YouMICROSOFT EXCEL
Rather than having negative numbers with a minus sign in front of them, some people prefer to put negative numbers in brackets. To do this, select the cell or range of cells to be formatted, then if using Microsoft Excel 2003 or earlier, click Format – Cells and ensure the Number tab is uppermost. If using Microsoft Excel 2007, 2010,2013 or 2016, then on the Home tab, in the Number groupMICROSOFT WORD
I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next line. The trick is that instead of just pressing the spacebar toseparate the blocks
CRYSTAL REPORTS
I was training Crystal Reports this week and we produced a chart where a lot of the values were zero which made the chart rather messy. We were charting Last Year's Sales by field Region from the Customer table. Create a new formula field, No Sales Region If Sum({Customer.Last Year’s Sales},{Customer.Region})=0 then {Customer.Region} Go intoMICROSOFT OFFICE
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.MICROSOFT WORD
To insert a watermark into a document on the Design tab, in the Page Background group, click the Watermark dropdown and select your required watermark. This will appear on the first page of the document. If you want it to appear on every page in the document, from the Watermark dropdown, click Custom Watermark.The Custom Watermark dialog box will be displayed.MICROSOFT PROJECT
Click the View tab on the ribbon, select the Tables command and click Tracking. . You can type information into the following columns: Act. Start The actual date the task started. Act. Finish The actual date the task was completed. % Comp. If the task isMICROSOFT PROJECT
Click Formula, then from the Function dropdown, select ProjDateAdd. For the date part, from the Field dropdown, select Project – Date – Current Date. For duration we need 90 (days in three months) multiplied by Field – Project – Number – Minutes per day. Click OK twice. From the View tab and the Filter dropdown, select NewFilter.
MICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT WORD
When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the Styles group on the Home tab.. To add any built-in style to the Styles Gallery, provided you are using Microsoft Word 2007 or Microsoft Word 2010, click on the little arrowMICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. YouMICROSOFT EXCEL
Rather than having negative numbers with a minus sign in front of them, some people prefer to put negative numbers in brackets. To do this, select the cell or range of cells to be formatted, then if using Microsoft Excel 2003 or earlier, click Format – Cells and ensure the Number tab is uppermost. If using Microsoft Excel 2007, 2010,2013 or 2016, then on the Home tab, in the Number groupMICROSOFT WORD
I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next line. The trick is that instead of just pressing the spacebar toseparate the blocks
MICROSOFT PROJECT
Click the View tab on the ribbon, select the Tables command and click Tracking. . You can type information into the following columns: Act. Start The actual date the task started. Act. Finish The actual date the task was completed. % Comp. If the task isMICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. YouMICROSOFT EXCEL
Then we need to make use of the EOMONTH function which gives the end of month date of the previous month so we will need to add three days to it to get the third day of the next month. The syntax of the EOMONTH function is =EOMONTH (Start date, number of months). In this instance the number of months after the start date is 0 – we justwant
MICROSOFT PROJECT 2010, 2013, 2016 In earlier versions of Microsoft Project, all tasks were auto-scheduled by default. In Microsoft Project 2010 this changed, so that by default all new tasks are scheduled manually. If you are used to the older versions, you may prefer to set the default to auto-scheduling for all new projects. To use auto-scheduling for allnew
MICROSOFT WORD
I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next line. The trick is that instead of just pressing the spacebar toseparate the blocks
REMOVING TODAY’S DATE LINE FROM MICROSOFT PROJECT GANTT To remove today’s date line from a Gantt Chart: On the Gantt Chart Tools Format tab, in the Format group, click the Gridlines dropdown, and click Gridlines. The Gridlines dialog box will be displayed. In the Line to change section, select Current Date. From the Type dropdown, select the first option, which is blank. Click OK.MICROSOFT EXCEL
I was asked by a client how I could display a dash (-) instead of 0 in cells. Although this could be done by the use of an IF statement, an easier way to do it is to select the cells to be adapted then go to the Format Cells Number tab (in Microsoft Excel 2007, 2010 and 2013, click on the dialog box launcher at the bottom of the Number group on the Home tab and in Microsoft Excel 2003 or MICROSOFT WORD LABELS MAILMERGE PROBLEM One or two clients have mentioned problems with creating mailing labels, using Word 2007 or Word 2010 mailings tab. Only one label is being printed on each sheet of labels. To create mailing labels, from the Mailings tab, in the Start Mail Merge group, from the Start Mail Merge dropdown, click Labels. The Label OptionsMICROSOFT WORD
When training Word 2010 outline numbering recently, one learner was unable to use her Tab key to get to the next level of numbers. This foiled me for a while but I decided it must be something in the settings. If using Word 2007, click the Office button and then click Word Options; if using PROBLEMS WITH OUTLOOK CONTACTS SHOWING WRONG NAMES I was at a client site yesterday and although contact names and email addresses looked right in the Contacts list, on trying to send an email some of them were getting mixed up e.g. John Smith was showing as Jane Smith (another contact) but with John's email address. IMICROSOFT OFFICE
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.MICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. You MICROSOFT PROJECT 2010, 2013, 2016 In earlier versions of Microsoft Project, all tasks were auto-scheduled by default. In Microsoft Project 2010 this changed, so that by default all new tasks are scheduled manually. If you are used to the older versions, you may prefer to set the default to auto-scheduling for all new projects. To use auto-scheduling for allnew
MICROSOFT WORD
When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the Styles group on the Home tab.. To add any built-in style to the Styles Gallery, provided you are using Microsoft Word 2007 or Microsoft Word 2010, click on the little arrowMICROSOFT WORD
From the dropdown at the Choose commands from box, select All Commands. Scroll down in the section below until you get to Shrink One Page. Click Add. Click OK. The Shrink One Page button will then be added to your Quick Access Toolbar. Next time, you want a document to fit on one page, click on the button and it will do it for you. REMOVING TODAY’S DATE LINE FROM MICROSOFT PROJECT GANTT To remove today’s date line from a Gantt Chart: On the Gantt Chart Tools Format tab, in the Format group, click the Gridlines dropdown, and click Gridlines. The Gridlines dialog box will be displayed. In the Line to change section, select Current Date. From the Type dropdown, select the first option, which is blank. Click OK.MICROSOFT OFFICE
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.MICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. You MICROSOFT PROJECT 2010, 2013, 2016 In earlier versions of Microsoft Project, all tasks were auto-scheduled by default. In Microsoft Project 2010 this changed, so that by default all new tasks are scheduled manually. If you are used to the older versions, you may prefer to set the default to auto-scheduling for all new projects. To use auto-scheduling for allnew
MICROSOFT WORD
When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the Styles group on the Home tab.. To add any built-in style to the Styles Gallery, provided you are using Microsoft Word 2007 or Microsoft Word 2010, click on the little arrowMICROSOFT WORD
From the dropdown at the Choose commands from box, select All Commands. Scroll down in the section below until you get to Shrink One Page. Click Add. Click OK. The Shrink One Page button will then be added to your Quick Access Toolbar. Next time, you want a document to fit on one page, click on the button and it will do it for you. REMOVING TODAY’S DATE LINE FROM MICROSOFT PROJECT GANTT To remove today’s date line from a Gantt Chart: On the Gantt Chart Tools Format tab, in the Format group, click the Gridlines dropdown, and click Gridlines. The Gridlines dialog box will be displayed. In the Line to change section, select Current Date. From the Type dropdown, select the first option, which is blank. Click OK.MICROSOFT EXCEL
The trick needed is to format the axis as text. Click on the horizontal axis, right-click and select Format Axis. On the Axis Options tab, in the Axis Type section choose Text axis. Click Close. Your columns become wider!!! You can then further adapt the widths by right-clicking on the column and selecting Format Data Series.MICROSOFT WORD
I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next line. The trick is that instead of just pressing the spacebar toseparate the blocks
MICROSOFT WORD
If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you may well find that you cannot evenMICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
Click the View tab on the ribbon, select the Tables command and click Tracking. . You can type information into the following columns: Act. Start The actual date the task started. Act. Finish The actual date the task was completed. % Comp. If the task isMICROSOFT WORD
To insert a watermark into a document on the Design tab, in the Page Background group, click the Watermark dropdown and select your required watermark. This will appear on the first page of the document. If you want it to appear on every page in the document, from the Watermark dropdown, click Custom Watermark.The Custom Watermark dialog box will be displayed.MICROSOFT PROJECT
Microsoft Project – Resource Contouring. Posted on August 5, 2014 by jdonbavand. If you assign a person to a 10 day task at 25% of their time, Microsoft Project assumes that they will do the task at 25% of their time throughout the duration of the task. What happens if you know that it will take more effort at the start of the task or towardsMICROSOFT EXCEL
For many versions of Microsoft Excel I found it annoying that it said Row labels and Column labels in a Pivot Table instead of the actual field headings. In Excel 365 this can now eventually be changed to show field headings by default. To do so, from within Excel itself, goto File - Options.
MICROSOFT WORD
Microsoft Word – getting back to normal text after using text effects. If you use the Text Effects button in the Font group on the Home tab, you produce some interesting effects. However, it is not then obvious how to get back to normal writing! To do so, click the Clear All Formatting button also in the Font group on the Home tab.MICROSOFT EXCEL
School years run from September to August, so in general it depends on both the month that a child is born in as well as the year. So if you have a list of dates of births and need to work out the school year that a child would be in for the next schoolMICROSOFT WORD
If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you may well find that you cannot evenMICROSOFT EXCEL
I was asked by a client how I could display a dash (-) instead of 0 in cells. Although this could be done by the use of an IF statement, an easier way to do it is to select the cells to be adapted then go to the Format Cells Number tab (in Microsoft Excel 2007, 2010 and 2013, click on the dialog box launcher at the bottom of the Number group on the Home tab and in Microsoft Excel 2003 or MICROSOFT WORD LABELS MAILMERGE PROBLEM One or two clients have mentioned problems with creating mailing labels, using Word 2007 or Word 2010 mailings tab. Only one label is being printed on each sheet of labels. To create mailing labels, from the Mailings tab, in the Start Mail Merge group, from the Start Mail Merge dropdown, click Labels. The Label OptionsMICROSOFT OFFICE
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.MICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. You MICROSOFT PROJECT 2010, 2013, 2016 In earlier versions of Microsoft Project, all tasks were auto-scheduled by default. In Microsoft Project 2010 this changed, so that by default all new tasks are scheduled manually. If you are used to the older versions, you may prefer to set the default to auto-scheduling for all new projects. To use auto-scheduling for allnew
MICROSOFT WORD
When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the Styles group on the Home tab.. To add any built-in style to the Styles Gallery, provided you are using Microsoft Word 2007 or Microsoft Word 2010, click on the little arrowMICROSOFT WORD
From the dropdown at the Choose commands from box, select All Commands. Scroll down in the section below until you get to Shrink One Page. Click Add. Click OK. The Shrink One Page button will then be added to your Quick Access Toolbar. Next time, you want a document to fit on one page, click on the button and it will do it for you. REMOVING TODAY’S DATE LINE FROM MICROSOFT PROJECT GANTT To remove today’s date line from a Gantt Chart: On the Gantt Chart Tools Format tab, in the Format group, click the Gridlines dropdown, and click Gridlines. The Gridlines dialog box will be displayed. In the Line to change section, select Current Date. From the Type dropdown, select the first option, which is blank. Click OK.MICROSOFT EXCEL
The trick needed is to format the axis as text. Click on the horizontal axis, right-click and select Format Axis. On the Axis Options tab, in the Axis Type section choose Text axis. Click Close. Your columns become wider!!! You can then further adapt the widths by right-clicking on the column and selecting Format Data Series.MICROSOFT WORD
I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next line. The trick is that instead of just pressing the spacebar toseparate the blocks
MICROSOFT WORD
If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you may well find that you cannot evenMICROSOFT OFFICE
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.MICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. You MICROSOFT PROJECT 2010, 2013, 2016 In earlier versions of Microsoft Project, all tasks were auto-scheduled by default. In Microsoft Project 2010 this changed, so that by default all new tasks are scheduled manually. If you are used to the older versions, you may prefer to set the default to auto-scheduling for all new projects. To use auto-scheduling for allnew
MICROSOFT WORD
When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the Styles group on the Home tab.. To add any built-in style to the Styles Gallery, provided you are using Microsoft Word 2007 or Microsoft Word 2010, click on the little arrowMICROSOFT WORD
From the dropdown at the Choose commands from box, select All Commands. Scroll down in the section below until you get to Shrink One Page. Click Add. Click OK. The Shrink One Page button will then be added to your Quick Access Toolbar. Next time, you want a document to fit on one page, click on the button and it will do it for you. REMOVING TODAY’S DATE LINE FROM MICROSOFT PROJECT GANTT To remove today’s date line from a Gantt Chart: On the Gantt Chart Tools Format tab, in the Format group, click the Gridlines dropdown, and click Gridlines. The Gridlines dialog box will be displayed. In the Line to change section, select Current Date. From the Type dropdown, select the first option, which is blank. Click OK.MICROSOFT EXCEL
The trick needed is to format the axis as text. Click on the horizontal axis, right-click and select Format Axis. On the Axis Options tab, in the Axis Type section choose Text axis. Click Close. Your columns become wider!!! You can then further adapt the widths by right-clicking on the column and selecting Format Data Series.MICROSOFT WORD
I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next line. The trick is that instead of just pressing the spacebar toseparate the blocks
MICROSOFT WORD
If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you may well find that you cannot evenMICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
Click the View tab on the ribbon, select the Tables command and click Tracking. . You can type information into the following columns: Act. Start The actual date the task started. Act. Finish The actual date the task was completed. % Comp. If the task isMICROSOFT WORD
To insert a watermark into a document on the Design tab, in the Page Background group, click the Watermark dropdown and select your required watermark. This will appear on the first page of the document. If you want it to appear on every page in the document, from the Watermark dropdown, click Custom Watermark.The Custom Watermark dialog box will be displayed.MICROSOFT PROJECT
Microsoft Project – Resource Contouring. Posted on August 5, 2014 by jdonbavand. If you assign a person to a 10 day task at 25% of their time, Microsoft Project assumes that they will do the task at 25% of their time throughout the duration of the task. What happens if you know that it will take more effort at the start of the task or towardsMICROSOFT EXCEL
For many versions of Microsoft Excel I found it annoying that it said Row labels and Column labels in a Pivot Table instead of the actual field headings. In Excel 365 this can now eventually be changed to show field headings by default. To do so, from within Excel itself, goto File - Options.
MICROSOFT WORD
Microsoft Word – getting back to normal text after using text effects. If you use the Text Effects button in the Font group on the Home tab, you produce some interesting effects. However, it is not then obvious how to get back to normal writing! To do so, click the Clear All Formatting button also in the Font group on the Home tab.MICROSOFT EXCEL
School years run from September to August, so in general it depends on both the month that a child is born in as well as the year. So if you have a list of dates of births and need to work out the school year that a child would be in for the next schoolMICROSOFT WORD
If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you may well find that you cannot evenMICROSOFT EXCEL
I was asked by a client how I could display a dash (-) instead of 0 in cells. Although this could be done by the use of an IF statement, an easier way to do it is to select the cells to be adapted then go to the Format Cells Number tab (in Microsoft Excel 2007, 2010 and 2013, click on the dialog box launcher at the bottom of the Number group on the Home tab and in Microsoft Excel 2003 or MICROSOFT WORD LABELS MAILMERGE PROBLEM One or two clients have mentioned problems with creating mailing labels, using Word 2007 or Word 2010 mailings tab. Only one label is being printed on each sheet of labels. To create mailing labels, from the Mailings tab, in the Start Mail Merge group, from the Start Mail Merge dropdown, click Labels. The Label OptionsMICROSOFT OFFICE
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.MICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. You MICROSOFT PROJECT 2010, 2013, 2016 In earlier versions of Microsoft Project, all tasks were auto-scheduled by default. In Microsoft Project 2010 this changed, so that by default all new tasks are scheduled manually. If you are used to the older versions, you may prefer to set the default to auto-scheduling for all new projects. To use auto-scheduling for allnew
MICROSOFT WORD
When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the Styles group on the Home tab.. To add any built-in style to the Styles Gallery, provided you are using Microsoft Word 2007 or Microsoft Word 2010, click on the little arrowMICROSOFT WORD
From the dropdown at the Choose commands from box, select All Commands. Scroll down in the section below until you get to Shrink One Page. Click Add. Click OK. The Shrink One Page button will then be added to your Quick Access Toolbar. Next time, you want a document to fit on one page, click on the button and it will do it for you. REMOVING TODAY’S DATE LINE FROM MICROSOFT PROJECT GANTT To remove today’s date line from a Gantt Chart: On the Gantt Chart Tools Format tab, in the Format group, click the Gridlines dropdown, and click Gridlines. The Gridlines dialog box will be displayed. In the Line to change section, select Current Date. From the Type dropdown, select the first option, which is blank. Click OK.MICROSOFT EXCEL
The trick needed is to format the axis as text. Click on the horizontal axis, right-click and select Format Axis. On the Axis Options tab, in the Axis Type section choose Text axis. Click Close. Your columns become wider!!! You can then further adapt the widths by right-clicking on the column and selecting Format Data Series.MICROSOFT WORD
I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next line. The trick is that instead of just pressing the spacebar toseparate the blocks
MICROSOFT WORD
If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you may well find that you cannot evenMICROSOFT OFFICE
Right-click on the horizontal axis showing the dates and select Format Axis. Under the Axis Options, for Axis Type, select Text axis. The Chart then just displays the data for the weekdays. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.MICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add in a constraint date. You MICROSOFT PROJECT 2010, 2013, 2016 In earlier versions of Microsoft Project, all tasks were auto-scheduled by default. In Microsoft Project 2010 this changed, so that by default all new tasks are scheduled manually. If you are used to the older versions, you may prefer to set the default to auto-scheduling for all new projects. To use auto-scheduling for allnew
MICROSOFT WORD
When teaching Styles in Microsoft Word recently, we were doing an exercise to use Heading 1, Heading 2 and Heading 3 styles. However, on some of the training computers, Heading 3 was not visible on the Styles Gallery in the Styles group on the Home tab.. To add any built-in style to the Styles Gallery, provided you are using Microsoft Word 2007 or Microsoft Word 2010, click on the little arrowMICROSOFT WORD
From the dropdown at the Choose commands from box, select All Commands. Scroll down in the section below until you get to Shrink One Page. Click Add. Click OK. The Shrink One Page button will then be added to your Quick Access Toolbar. Next time, you want a document to fit on one page, click on the button and it will do it for you. REMOVING TODAY’S DATE LINE FROM MICROSOFT PROJECT GANTT To remove today’s date line from a Gantt Chart: On the Gantt Chart Tools Format tab, in the Format group, click the Gridlines dropdown, and click Gridlines. The Gridlines dialog box will be displayed. In the Line to change section, select Current Date. From the Type dropdown, select the first option, which is blank. Click OK.MICROSOFT EXCEL
The trick needed is to format the axis as text. Click on the horizontal axis, right-click and select Format Axis. On the Axis Options tab, in the Axis Type section choose Text axis. Click Close. Your columns become wider!!! You can then further adapt the widths by right-clicking on the column and selecting Format Data Series.MICROSOFT WORD
I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next line. The trick is that instead of just pressing the spacebar toseparate the blocks
MICROSOFT WORD
If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you may well find that you cannot evenMICROSOFT PROJECT
Then from the Resource Group filter dropdown, get rid of the tick by Select All and put a tick by the first of your groups. If you want to change text colours of background colours in the entry table, select the filtered rows, and on the Home tab in the Font group, select your required font colour and/or background colour.MICROSOFT PROJECT
Click the View tab on the ribbon, select the Tables command and click Tracking. . You can type information into the following columns: Act. Start The actual date the task started. Act. Finish The actual date the task was completed. % Comp. If the task isMICROSOFT WORD
To insert a watermark into a document on the Design tab, in the Page Background group, click the Watermark dropdown and select your required watermark. This will appear on the first page of the document. If you want it to appear on every page in the document, from the Watermark dropdown, click Custom Watermark.The Custom Watermark dialog box will be displayed.MICROSOFT PROJECT
Microsoft Project – Resource Contouring. Posted on August 5, 2014 by jdonbavand. If you assign a person to a 10 day task at 25% of their time, Microsoft Project assumes that they will do the task at 25% of their time throughout the duration of the task. What happens if you know that it will take more effort at the start of the task or towardsMICROSOFT EXCEL
For many versions of Microsoft Excel I found it annoying that it said Row labels and Column labels in a Pivot Table instead of the actual field headings. In Excel 365 this can now eventually be changed to show field headings by default. To do so, from within Excel itself, goto File - Options.
MICROSOFT WORD
Microsoft Word – getting back to normal text after using text effects. If you use the Text Effects button in the Font group on the Home tab, you produce some interesting effects. However, it is not then obvious how to get back to normal writing! To do so, click the Clear All Formatting button also in the Font group on the Home tab.MICROSOFT EXCEL
School years run from September to August, so in general it depends on both the month that a child is born in as well as the year. So if you have a list of dates of births and need to work out the school year that a child would be in for the next schoolMICROSOFT WORD
If you insert a shape and a picture into a Word document, you may want to group them together for the purpose, for example, of copying and pasting. If you try to group them together having just inserted them, you may well find that you cannot evenMICROSOFT EXCEL
I was asked by a client how I could display a dash (-) instead of 0 in cells. Although this could be done by the use of an IF statement, an easier way to do it is to select the cells to be adapted then go to the Format Cells Number tab (in Microsoft Excel 2007, 2010 and 2013, click on the dialog box launcher at the bottom of the Number group on the Home tab and in Microsoft Excel 2003 or MICROSOFT WORD LABELS MAILMERGE PROBLEM One or two clients have mentioned problems with creating mailing labels, using Word 2007 or Word 2010 mailings tab. Only one label is being printed on each sheet of labels. To create mailing labels, from the Mailings tab, in the Start Mail Merge group, from the Start Mail Merge dropdown, click Labels. The Label OptionsIFONLYIDKNOWNTHAT
Microsoft Office hints and tipsSkip to content
* Home
* About
* Microsoft Excel – creating a calendar with weekends greyed out * Microsoft Excel – getting column widths to just fit a Worddocument width
← Older posts
MICROSOFT EXCEL – CHARTS WITH MISSING VALUES Posted on October 16, 2019by jdonbavand
If you create a line chart where there are blanks in the data, the resulting chart can look rather odd! On the CHART DESIGN tab, click SELECT DATA. From the SELECT DATA SOURCE dialog box, click HIDDEN AND EMPTY CELLS. Choose from one of the options. Here, I have chosen CONNECT DATA POINTS WITH LINE. Click OK. Your chart will no longer have gaps. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.Advertisements
Report this ad
Report this ad
Posted in Excel 365
,
Microsoft Excel
,
Microsoft Excel 2010,
Microsoft Excel 2013,
Microsoft Excel 2016 | Tagged charts with blanks,
charts with missing data,
Microsoft Excel
| Leave
a comment
MICROSOFT EXCEL – THE UNIQUE FUNCTION Posted on October 8, 2019by jdonbavand
If you are an Excel 365 user, you will have the UNIQUE function, which looks at a range of cells and produces a list of unique values. This may, be useful, for example, if you wanted to create a Data Validation List from data that is already there. In the example below, I have a list of orders, but some customers have made more than one order and I just want a list of customer names. In cell H2, I use the formula =UNIQUE(B2:B154) which is the range that I am searching through. I get a list of unique names in column H. The syntax for the UNIQUE function is UNIQUE(ARRAY, ,).
Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset. Posted in Uncategorized| 2
Comments
MICROSOFT EXCEL – TEXTJOIN FUNCTION Posted on September 30, 2019by jdonbavand
When storing names in Excel, it is usual to create three separate fields – Title, FirstName and Surname. Sometimes we want to join the words together, for example, for sending out an invoice. Joining two or more words together into one string is called CONCATENATION. The CONCAT function was introduced in Excel 2016 and replaces the earlier CONCATENATE function. The syntax for this is CONCAT(TEXT1, ,…) where text1, text2 etc are the strings you want to join together. We can concatenate a space character within the CONCAT function asfollows:
=CONCAT(A2,” “,B2,” “,C2) Another way of typing this is =A2&” “&B2&” “&C2. With the new TEXTJOIN function, the same process would look somethinglike this:
=TEXTJOIN(” “, TRUE, A2:C2). Even more usefully, the TEXTJOIN function allows you to ignore empty cells.The syntax is:
TEXTJOIN(DELIMITER, IGNORE_EMPTY, TEXT1, ,…) The delimiter is the separator required between each text string and needs to be enclosed in double quotes. If you want to ignore empty cells in a range, then IGNORE_EMPTY should be TRUE, otherwise FALSE. TEXT1, TEXT2 etc are the parts of text you want to join and can be actual text or a cell range. If you were using a Slicer in an Excel pivot table, the TEXTJOIN function would allow you to create a title for the table. If I remove the Grand Total and then adapt my slicer my title willchange accordingly.
Report this ad
Find out more about our Microsoft Excel trainingin the London area.
Find out more about our Microsoft Excel training in Wiltshire, Dorset, Somerset and Hampshire. Posted in Uncategorized|
Leave a comment
MICROSOFT OUTLOOK – ADDING CONTACT LISTS TO THE ADDRESS BOOK Posted on June 7, 2019by jdonbavand
When you are trying to address an email and click the To button, the SELECT NAMES dialog box displays with a dropdown list in the ADDRESS BOOK area, usually showing the Global Address Book and various other contact folders. At a client site recently, they had various contact folders that were not showing up on the dropdown list. To add to the list, right-click on the CONTACT folder, then click PROPERTIES, click OUTLOOK ADDRESS BOOK, then put a tick by SHOW THIS FOLDER AS AN EMAIL ADDRESS BOOK. Click OK. Find out more information about our Microsoft Outlook training in the London area or our Microsoft Outlook training in Wiltshire, Dorset, Somerset and Hampshire. Posted in Microsoft Outlook 2013,
Microsoft Outlook 2016,
Outlook 365
| Tagged adding contact folders to address book,
Microsoft Outlook
|
Leave a comment
MICROSOFT OUTLOOK – CLASSIC RIBBON VS SIMPLIFIED RIBBON Posted on June 6, 2019by jdonbavand
From Office 2007 onwards, there has been a ribbon structure at the top of the opened package with various tabs showing various commands. On opening Microsoft Outlook on a computer belonging to a client recently, the ribbon showed some icons but not all of them. Outlook 2016 and Outlook 365 have the options of showing a Simplified ribbon which just shows your most frequently used commands on oneline.
To switch between the standard or CLASSIC ribbon and the SIMPLIFIED ribbon, right-click on the ribbon. Three options will appear – CUSTOMIZE THE RIBBON, COLLAPSE THE RIBBON and USE SIMPLIFIEDRIBBON.
Classic Ribbon
Collapsed Ribbon
Simplified Ribbon
Find more information about our Microsoft Outlook training in the London area or about our Microsoft Outlook training in Wiltshire, Dorset, Somerset and Hampshire. Posted in Microsoft Outlook 2016,
Outlook 365
,
Uncategorized
|
Tagged Classic Ribbon,
Simplified Ribbon
|
Leave a comment
MICROSOFT OUTLOOK – ADDING CONTACTS TO AUTOCOMPLETE Posted on June 5, 2019by jdonbavand
Generally when you are using Microsoft Outlook, recently used contacts come up under the AutoComplete list when you are using the TO box to address a new email. At one client site recently this wasn’t happening for a few contacts – and ones they did use on a regularbasis.
The solution involved going offline as you have to seem to send an email to the added contacts – click the SEND/RECEIVE tab, then in the PREFERENCES group, click WORK OFFLINE. Now go to the relevant CONTACTS folder and select the required contacts by holding down the CTRL key and clicking. Then on the HOME tab, in the COMMUNICATE group, click EMAIL. The relevant email addresses will now show in the TO box. Click SEND. Because you are offline, the message will now be in the OUTBOX. Go to that and delete the message. Then go back online, by going back to the SEND/RECEIVE tab and in the PREFERENCES group, clicking WORKOFFLINE again.
Next time you try to send an email, the required contacts should be in the AUTOCOMPLETE list. Find out more about our Microsoft Outlook trainingin
the London area or our Microsoft Outlook training in Wiltshire, Dorset, Somerset and Hampshire. Posted in Microsoft Outlook,
Microsoft Outlook 2010,
Microsoft Outlook 2013,
Microsoft Outlook 2016 | Tagged contact autocomplete,
Microsoft Outlook
|
Leave a comment
MICROSOFT POWERPOINT – HOW CAN I STOP MY HYPERLINK CHANGING COLOURWHEN IT IS CLICKED
Posted on May 29, 2019by jdonbavand
Not everyone is using PowerPoint for presentations; some use it to produce notices or reports. If you are creating something to put on a wall, you don’t want some hyperlinks to be differently coloured to others. The reason this happens is because you, or someone else, has clicked on the hyperlink at some point. The colours for hyperlinks are linked to themes. Go to the DESIGN tab, then open up the VARIANTS gallery, click COLORS – CUSTOMIZE COLORS. The CREATE NEW THEME COLORS dialog box will be displayed. From the FOLLOWED HYPERLINK dropdown, select the same colour as for HYPERLINK. Click SAVE. The colours of your hyperlinks will thenremain the same.
Find out more about our Microsoft PowerPoint training in the London area or our Microsoft PowerPoint training in Wiltshire, Dorset, Somerset and Hampshire. Posted in Microsoft PowerPoint,
Microsoft PowerPoint 2013,
Microsoft PowerPoint 2016,
Uncategorized
|
Tagged colours ,
hyperlink ,
Microsoft PowerPoint|
Leave a comment
MICROSOFT OUTLOOK – PRINTING CONTACT LIST WITH NOTES Posted on May 20, 2019by jdonbavand
A client wanted to be able to print off contact details with Notes from Microsoft Outlook. This is easy enough for one contact – open up the contact details, then click FILE – PRINT. The contact details will be printed, together with any notes. To print several contacts with notes, go to FILE – PRINT, select MEMO STYLE. The notes will be printed alongside the contact details, with one contact per page. Find out more about our Microsoft Outlook training in the London area or our Microsoft Outlook training in Wiltshire, Dorset, Somerset and Hampshire. Posted in Uncategorized|
Leave a comment
PROBLEMS WITH OUTLOOK CONTACTS SHOWING WRONG NAMES Posted on May 9, 2019by jdonbavand
I was at a client site yesterday and although contact names and email addresses looked right in the Contacts list, on trying to send an email some of them were getting mixed up e.g. John Smith was showing as Jane Smith (another contact) but with John’s email address. I tried deleting the contacts and then re-entering but without muchsuccess.
On further investigation, it seems that the two contacts were linked and that this was causing the problem. To check whether contacts are linked, start an email to one, then double-click on the email address. Click on the three dots …, then click LINK CONTACTS. This will show whether there are any linked contacts. To remove the link, select the contact to be unlinked and click UNLINK, then click OK. Find out more about our Microsoft Outlook trainingin the London area.
Find out more about our Microsoft Outlook training in Wiltshire, Dorset, Hampshire and Somerset. Posted in Microsoft Office 365,
Microsoft Outlook
,
Microsoft Outlook 2013,
Microsoft Outlook 2016,
Outlook 365
| Tagged Microsoft Outlook,
wrong contact names in emails| Leave a comment
SEARCHING FILE CONTENTS USING FILE EXPLORER Posted on April 26, 2019by jdonbavand
I was at client site recently and was told that File Explorer wasn’t searching within files but only file names. I checked on my laptop and didn’t have the same problem. It turned out that their Search options were configured differently from mine. If you have the same problem, go into File Explorer and type your search term in the SEARCH box at the top right under the Ribbon. Click the magnifying glass. The search will be started and a contextual SEARCH tab will appear. From the ADVANCED OPTIONS dropdown, select FILE CONTENTS (and SYSTEM FILES if that isn’t ticked). From now on, your file contents will be searched. Find out more about our Microsoft Office trainingin the London
area and our Microsoft Office trainingin Wiltshire,
Dorset, Hampshire and Somerset. Posted in Uncategorized|
Leave a comment
← Older posts
Older posts
*
Search for:
*
RECENT POSTS
* Microsoft Excel – Charts with missing values * Microsoft Excel – The UNIQUE function * Microsoft Excel – TEXTJOIN function * Microsoft Outlook – adding contact lists to the Address Book * Microsoft Outlook – Classic Ribbon vs Simplified Ribbon*
RECENT COMMENTS
jdonbavand on MicrosoftExcel – The UN…
Paul Terry on Microsoft Excel – TheUN…
Alex on Microsoft Word – I cannot see… Monika on Microsoft Excel – putting nega… Shelby on Microsoft Word labels mailmerg…*
ARCHIVES
* October 2019
* September 2019
* June 2019
* May 2019
* April 2019
* March 2019
* January 2019
* November 2018
* October 2018
* September 2018
* August 2018
* July 2018
* June 2018
* May 2018
* April 2018
* March 2018
* February 2018
* January 2018
* December 2017
* November 2017
* October 2017
* August 2017
* July 2017
* June 2017
* May 2017
* March 2017
* January 2017
* December 2016
* November 2016
* October 2016
* September 2016
* August 2016
* July 2016
* June 2016
* April 2016
* March 2016
* February 2016
* January 2016
* December 2015
* October 2015
* September 2015
* August 2015
* July 2015
* June 2015
* May 2015
* April 2015
* March 2015
* February 2015
* January 2015
* December 2014
* November 2014
* October 2014
* September 2014
* August 2014
* July 2014
* June 2014
* May 2014
* April 2014
* March 2014
* February 2014
* January 2014
* December 2013
* November 2013
* October 2013
* September 2013
* August 2013
* June 2013
* May 2013
* April 2013
* March 2013
* February 2013
* January 2013
* December 2012
* October 2012
* August 2012
* July 2012
* June 2012
* May 2012
* April 2012
* March 2012
* February 2012
* January 2012
* December 2011
* November 2011
* October 2011
* September 2011
* August 2011
* July 2011
* June 2011
* May 2011
* April 2011
*
CATEGORIES
* Business Writing
* Coaching skills
* Communication Skills* Crystal Reports
* Excel 365
* Mentoring training* Microsoft Access
* Microsoft Access 2003 * Microsoft Access 2007 * Microsoft Access 2010 * Microsoft Access 2013 * Microsoft Access 2016* Microsoft Excel
* Microsoft Excel 2003 * Microsoft Excel 2007 * Microsoft Excel 2010 * Microsoft Excel 2013 * Microsoft Excel 2016 * Microsoft Office 2007 and 2010 * Microsoft Office 2013 * Microsoft Office 2016 * Microsoft Office 365 * Microsoft Ofiice 2016* Microsoft Outlook
* Microsoft Outlook 2007 * Microsoft Outlook 2010 * Microsoft Outlook 2013 * Microsoft Outlook 2016 * Microsoft Outlook 2016 * Microsoft PowerPoint * Microsoft PowerPoint 2007 * Microsoft PowerPoint 2010 * Microsoft PowerPoint 2013 * Microsoft PowerPoint 2016* Microsoft Project
* Microsoft Project 2010 * Microsoft Project 2013 * Microsoft Project 2016* Microsoft Teams
* Microsoft Word
* Microsoft Word 2003 * Microsoft Word 2007 * Microsoft Word 2010 * Microsoft Word 2013 * Microsoft Word 2016* Minute Taking
* Negotiating and Influencing Skills* Office 365
* Outlook 365
* Presentation Skills * Project Management* Report writing
* Time Management
* Uncategorized
* Windows 10
* Windows 7
*
META
* Register
* Log in
* Entries feed
* Comments feed
* WordPress.com
Advertisements
Report this ad
ifonlyidknownthat
Blog at WordPress.com.Post to
Cancel
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. To find out more, including how to control cookies, see here: CookiePolicy
* Follow
*
* ifonlyidknownthat
* Customize
* Follow
* Sign up
* Log in
* Report this content * Manage subscriptions* Collapse this bar
Report this ad
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0