Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165

07 July 2009 a wodge of kitchen paper to smear it round before you make each pancake. Now get the pan really hot, then turn the heat down to medium and, to start with, do a test pancake to see if you're using the correct amount of batter. I find 2 tbsp is about...

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• Language: *

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

12 April 2013 never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The excel report would hit a bug where it...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

11 February 2019 in the same folder. Move the Excel file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Newbies guide to be the local computer guyhttps://www.joellipman.com/component/content/article/newbies-guide-to-be-the-local-computer-guy.html?catid=116&Itemid=165

28 April 2011 Source: http://www.reddit.com/r/IAmA/comments/9usm7/iama_local_tech_repair_man_i_run_my_own_business/ I love the last point. Down talk as opposed to hype and then produce. Even with most services this nearly always guarantees a happy customer. "So this...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/component/content/article/windows-7-and-google-chrome-incognito-mode-by-default.html?catid=61&Itemid=165

24 March 2010 -incognito) Additional Note 201004201256: The shortcut key within Google Chrome is holding down the Control and Shift key and then pressing the letter N.

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/component/content/article/ssrs-repeat-headers-in-pdf-report.html?catid=75&Itemid=165

26 October 2011 2008 (BIDS) - SQL Server Reporting Services 2008 R2 (SSRS) - PDF generated to a Windows File Share The Fix Click on the down arrow icon near the "Column Groups" panel (see below screenshot). Click on the "static" row that is the header of the tablix...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Border Problemhttps://www.joellipman.com/component/content/article/ssrs-border-problem.html?catid=75&Itemid=165

20 January 2014 a whole section of the report with just one border??? How? In Design view, click on the first cell (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells. Now open the "Properties" pane, find the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Add "Command prompt from here" to right-click context menuhttps://www.joellipman.com/component/content/article/add-command-prompt-from-here-to-right-click-context-menu.html?catid=80&Itemid=165

27 January 2010 as well post the way I do it: Open up windows explorer Go to Tools -> Folder Options Click on the File Types tab Scroll down and select (NONE) Folder as file type Click on Advanced Click on New... For the Action type what ever you want the context menu...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/cms/website-development/code-troubleshooting-checklist.html

03 June 2011 on the files? Ensured all global, posted and session variables are present when they should be and behave properly? Broken down the error in understandable and diagnosable parts? Checked appropriate services are running? Questions for the customer Can...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/cms/website-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically resized in...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: en-GB

Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

13 February 2013 time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join. Why? Currently the smallest bookable time by...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB