Are you over 18 and want to see adult content?
More Annotations
![A complete backup of ds11-form-online.com](https://www.archivebay.com/archive2/318cb8a7-9a29-42da-a0be-be253bb10c09.png)
A complete backup of ds11-form-online.com
Are you over 18 and want to see adult content?
![A complete backup of droughtrelief.org](https://www.archivebay.com/archive2/6ef62eea-7e24-4c3f-bfbc-cb0700b700f0.png)
A complete backup of droughtrelief.org
Are you over 18 and want to see adult content?
![A complete backup of activatealifestyle.com](https://www.archivebay.com/archive2/7af8354d-8370-43f5-94e2-9b55a639bda7.png)
A complete backup of activatealifestyle.com
Are you over 18 and want to see adult content?
![A complete backup of wiseinsights.net](https://www.archivebay.com/archive2/dec40768-6709-4e14-826a-4c0040f3a3e9.png)
A complete backup of wiseinsights.net
Are you over 18 and want to see adult content?
![A complete backup of dennisthefoodie.com](https://www.archivebay.com/archive2/4f6f08f7-a29f-4608-8ba9-87af641e857d.png)
A complete backup of dennisthefoodie.com
Are you over 18 and want to see adult content?
![A complete backup of 25daysofgiveaways.com](https://www.archivebay.com/archive2/25ac2e7f-579f-488a-aafa-259767cf1cbd.png)
A complete backup of 25daysofgiveaways.com
Are you over 18 and want to see adult content?
![A complete backup of sivanaspirit.com](https://www.archivebay.com/archive2/74a26fe1-f398-46c5-9bf3-56363cad7e0d.png)
A complete backup of sivanaspirit.com
Are you over 18 and want to see adult content?
Favourite Annotations
![AirportServices.ae – We offer Meet & Greet Services, 96 hour visas, hotel booking , Travel Insurance](https://www.archivebay.com/archive/9de40a70-ef9c-4e86-ae55-b03800dd08ed.png)
AirportServices.ae – We offer Meet & Greet Services, 96 hour visas, hotel booking , Travel Insurance
Are you over 18 and want to see adult content?
![Prosty i elegancki Półbuty Family Shoes w stylu klasycznym ze skóry ekologicznej SdrAZDNXPV](https://www.archivebay.com/archive/c3c028a8-5d78-4954-bc29-3e55298ba283.png)
Prosty i elegancki Półbuty Family Shoes w stylu klasycznym ze skóry ekologicznej SdrAZDNXPV
Are you over 18 and want to see adult content?
![TRANSBRAVA - Kayak Costa Brava: Alquiler y excursiones guiadas en Lloret de Mar](https://www.archivebay.com/archive/25b3b7bd-cf8e-4977-8640-ed8c23eaba61.png)
TRANSBRAVA - Kayak Costa Brava: Alquiler y excursiones guiadas en Lloret de Mar
Are you over 18 and want to see adult content?
![MANAGING WITH RESPECT © - Managing With Respect](https://www.archivebay.com/archive/af10fa8f-d472-4683-9a73-b3ec51da672f.png)
MANAGING WITH RESPECT © - Managing With Respect
Are you over 18 and want to see adult content?
![Bidolubaskı | Online Matbaa ve Kaliteli Baskı Hizmetleri | Matbaa](https://www.archivebay.com/archive/324693bb-27cb-4680-8582-355c395ec099.png)
Bidolubaskı | Online Matbaa ve Kaliteli Baskı Hizmetleri | Matbaa
Are you over 18 and want to see adult content?
![Cycling Clothing | Cycology Clothing UK](https://www.archivebay.com/archive/126c9a35-3cd9-4400-b809-2d300cbc688d.png)
Cycling Clothing | Cycology Clothing UK
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 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 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
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 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 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 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 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 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 groupCRYSTAL 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 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 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
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 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 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 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 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 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 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 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
USING A TICK IN AN EXCEL FORMULA A client wanted to use an IF statement but instead of the answer showing Y and N, she wanted to show a tick or a cross. First, find the relevant symbols and enter them into a cell (not the one you want the answer in); to do this, from the Insert tab, in the Symbols group, click Symbol.From the Font dropdown, select Wingdings, find the tickand click Insert.
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 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 group MICROSOFT EXCEL 2013 AND 2016 Microsoft Excel 2013 and 2016 – automatic currency conversion. A client wants to automatically convert £ to $ and £ to €. You used to be able to do this using MSN MoneyCentral straight from within Excel but this now longer seems to be readily available. However, the below worked for me. Go to Data – Get External Data – From Web. 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. 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. ICRYSTAL 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 EXCEL
Microsoft Excel – putting two or more charts on same sheet. Click an empty cell, and press (or Fn + F11 depending on your laptop. Change the default chart name to Two Chart Sheet (or some other suitable name). Select Object In, and choose Two Chart Sheet from the drop-down list. Click OK.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 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 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 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
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.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 EXCEL
Microsoft Excel – putting two or more charts on same sheet. Click an empty cell, and press (or Fn + F11 depending on your laptop. Change the default chart name to Two Chart Sheet (or some other suitable name). Select Object In, and choose Two Chart Sheet from the drop-down list. Click OK.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 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 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 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
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 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 POWERPOINT When you are giving a PowerPoint presentation, it is sometimes useful to talk about one bullet point, before your audience sees the next one. You can use animation to bring a bulleted list, one point at a time. On the relevant slide: Select the bulleted list. Click the Animations tab, then from the Animation gallery,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. YouMICROSOFT EXCEL
I had a client who had typed in as text, R, A or G depending on whether a certain indicator should be classified as Red, Amber or Green. They then wanted to use conditional formatting to show the relevant colour icon in cells adjacent to their RAG column. Selecting the cells containing the text andMICROSOFT 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 TEAMS
Microsoft Teams – Microsoft Office dialog boxes not showing when sharing screen. Posted on June 24, 2020 by jdonbavand. I was training Microsoft Excel remotely recently using Microsoft Teams. On opening the Insert Function dialog box, I was told it couldn’t beMICROSOFT PROJECT
I was asked how to create a field that would show the text “Due this week” if the task was due to finish within the next week and leave it blank otherwise. Go to the Project tab and in the Properties group, click Custom Fields. From the Type dropdown, select Text, select arelevant text
CRYSTAL REPORTS
In Crystal Reports you may have several reports with similar formulas. If you have Crystal Reports Enterprise you can copy formulas to the repository, but many people do not have this option. To copy formulas from a report, drag the formulas to be copied from the Formula Fields section of the Field Explorer into anMICROSOFT 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
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. ICRYSTAL 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 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 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
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 EXCEL
If you only want to show the RAG indicators without the numbers (as in column C), select the column with the indicators and from the Conditional Formatting dropdown, select Manage Rules. The Conditional Formatting Rules Manager will be displayed. Click on the rule, then click Edit Rule. Check the Show icon only box, then click OK twice.MICROSOFT 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 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
Microsoft Excel – putting two or more charts on same sheet. Click an empty cell, and press (or Fn + F11 depending on your laptop. Change the default chart name to Two Chart Sheet (or some other suitable name). Select Object In, and choose Two Chart Sheet from the drop-down list. Click OK.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 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 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
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 EXCEL
If you only want to show the RAG indicators without the numbers (as in column C), select the column with the indicators and from the Conditional Formatting dropdown, select Manage Rules. The Conditional Formatting Rules Manager will be displayed. Click on the rule, then click Edit Rule. Check the Show icon only box, then click OK twice.MICROSOFT 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 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
Microsoft Excel – putting two or more charts on same sheet. Click an empty cell, and press (or Fn + F11 depending on your laptop. Change the default chart name to Two Chart Sheet (or some other suitable name). Select Object In, and choose Two Chart Sheet from the drop-down list. Click OK.MICROSOFT ACCESS
The original report looks like: To created % of Totals go into Design view. In the Report Footer, create the relevant formulas as shown below: On viewing the report, you then have the relevant Percentages of Totals. Find out more about our Microsoft Access training in the London area or our Microsoft Access training in Wiltshire, DorsetMICROSOFT 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 EXCEL
Microsoft Excel – putting two or more charts on same sheet. Click an empty cell, and press (or Fn + F11 depending on your laptop. Change the default chart name to Two Chart Sheet (or some other suitable name). Select Object In, and choose Two Chart Sheet from the drop-down list. Click OK.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
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 POWERPOINT When you are giving a PowerPoint presentation, it is sometimes useful to talk about one bullet point, before your audience sees the next one. You can use animation to bring a bulleted list, one point at a time. On the relevant slide: Select the bulleted list. Click the Animations tab, then from the Animation gallery,MICROSOFT PROJECT
If you have a project that is long term, you may want to report on milestones due in the next three months. To do so, you will have to create a custom filter. First we need to create a formula field called Three months from now. To do so, on the Project tab, click CustomMICROSOFT 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. 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. IIFONLYIDKNOWNTHAT
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 – ARRANGING COUNTRIES INTO REGIONS IN A PIVOTTABLE Posted on November 13, 2019by jdonbavand
If you are a global company and are analysing sales by region, even if the name of the region isn’t in the raw data, you can group countries together by region as long as you know the appropriate regions to group them in to. In the example below, I have various countries and their last year’s sales. I want to find sales by continent. The first country, Argentina, is in South America. Click in the cell containing the first country, then hold down the CTRL key, click in the cells containing the other South Americancountries.
On the PIVOT TABLE ANALYZE tab, in the GROUP group, click GROUPSELECTION.
Click where it says GROUP1 and type in SOUTH AMERICA for the groupname.
Continue similarly for each set of countries. 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
Advertisements
Report this ad
Posted in Excel 365
,
Microsoft Excel
,
Microsoft Excel 2007,
Microsoft Excel 2010,
Microsoft Excel 2013,
Microsoft Excel 2016 | Tagged Assigning countries to regions,
Microsoft Excel
, pivot
tables |
Leave a comment
MICROSOFT EXCEL – FREEZING TOP ROW IN A PIVOT TABLE Posted on November 8, 2019by jdonbavand
I was at client site recently and someone had a Pivot table with a lot of rows. It was therefore hard to see what the column headings were. Just as when you are trying to freeze rows in any Excel data set, click in the row under the top row of the pivot table. Go to the VIEW tab, then in the WINDOW group, from the FREEZE PANES dropdown, select FREEZE PANES. That should do the trick. 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 Excel 365
,
Microsoft Excel
,
Microsoft Excel 2007,
Microsoft Excel 2010,
Microsoft Excel 2013,
Microsoft Excel 2016 | Tagged Freeze top row of pivot table,
Microsoft Excel
| Leave
a comment
MICROSOFT EXCEL – USING ICON SETS TO SHOW WHETHER FIGURES HAVE GONE UP, DOWN OR STAYED THE SAME Posted on November 7, 2019by jdonbavand
In the example above, I would like to use icon sets to show whether sales figures have increased, decreased or stayed static. In cell D5, I created a formula =IF(C5>B5,3,IF(C5=B5,2,1)) – i.e. if the figure had increased, D5 becomes a 3, if it is static, it becomes a 2, and if the figure has decreased, it becomes a 1. I then selected the numbers in column D, then on the HOME tab, in the STYLES group, I clicked the CONDITIONAL FORMATTING dropdown, clicked ICON SETS and selected the first of the DIRECTIONAL options. Then from the CONDITIONAL FORMATTING dropdown, select MANAGE RULES, then EDIT RULES and select SHOW ICON ONLY.Click OK twice.
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 Excel 365
,
Microsoft Excel
,
Microsoft Excel 2010,
Microsoft Excel 2013,
Microsoft Excel 2016 | Tagged conditional formatting,
icon sets ,
Microsoft Excel
| Leave
a comment
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.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.
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
← Older posts
Older posts
*
Search for:
*
RECENT POSTS
* Microsoft Excel – arranging countries into regions ina PivotTable
* Microsoft Excel – freezing top row in a Pivot Table * Microsoft Excel – using Icon Sets to show whether figures have gone up, down or stayed the same * Microsoft Excel – Charts with missing values * Microsoft Excel – The UNIQUE function*
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
* November 2019
* 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
Create a free website or 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
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0