0 All Posts Facebook0Google+0Twitter0LinkedIn0Pinterest0All PostsSearchable Drop-Down List In ExcelMay 14, 2021OEE Solution – Querying Various SheetsMarch 5, 2019Pareto Chart In ExcelDecember 20, 2018Formula to get first second and third highest valuesDecember 16, 2018FORMULA TO GET LAST ROW NUMBERNovember 16, 2018Excel Option ButtonsNovember 11, 2018Excels INDIRECT FunctionNovember 4, 2018Speedomoter For Excel DashboardJune 20, 2018Canvas Sprite Sheet AnimationApril 19, 2018Canvas Snake Game TutorialFebruary 3, 2018Canvas Basics – Arkanoid Game TutorialJanuary 9, 2018Canvas Basics – 09 More On ArraysDecember 3, 2017Canvas Game Tutorial PongNovember 21, 2017Canvas Basics – 08 Bouncing And DeflectingNovember 15, 2017Canvas Basics – 07 Random PositionsNovember 12, 2017Canvas Basics – 06 Collision DetectionNovember 6, 2017Canvas Basics – 05 Limiting Movement To CanvasNovember 3, 2017Canvas Basics – 04 Move An Object Using The KeyboardNovember 2, 2017Canvas Basics – 03 Moving An ObjectOctober 31, 2017Canvas Basics – 02 Mouse DetectionOctober 26, 2017Canvas Basics – 01 Hello WorldOctober 25, 2017Maths In Games Pythagorus and TrigonometryOctober 14, 2017Maths In Games Variables and PhysicsOctober 13, 2017Maths In Games AlgebraOctober 13, 2017Maths In GamesOctober 13, 2017Data Validation List Based On CriteriaAugust 13, 2017Advanced Filter in ExcelMay 23, 2017Animate In Excel 2May 2, 2017Animate In ExcelApril 11, 2017Data Validation List To Automatically Update Source RangeMarch 27, 2017Data Validation List Based On Range Of CellsMarch 21, 2017Data Validation List In Excel IntroductionMarch 20, 2017Project Tip Go Forward By Working BackwardsJanuary 22, 2017Excel Logo AnimationJanuary 4, 2017Excel Format dates to include st, nd,rd and thNovember 14, 2016Sum By Color in ExcelNovember 6, 2016Excels Scenario ManagerAugust 11, 2016INDEX MATCH An Alternative To VLookUpJune 18, 2016VLookUp To Retrieve data relating to the second or third matchJune 1, 2016COUNTIFS – COUNTIF FOR MULTIPLE CRITERIAMay 16, 2016SUMIFS – SUMIF FOR MULTIPLE CRITERIAMarch 16, 2016Sum Odd or Even Numbers only in ExcelFebruary 24, 2016Custom SortFebruary 21, 2016Avoid #REF! in Excel by knowing your Dependents and PrecedentsJanuary 27, 2016How To Auto Fill Sequential Letters in Excel VideoJanuary 6, 2016PowerPoint & The Star Wars Opening EffectDecember 6, 2015Simplify IF AND OR eBookNovember 9, 20151 Tip For More Effective MeetingsOctober 14, 2015Using Pivot Charts For Better AnalysisSeptember 23, 2015VLookup with multiple valuesAugust 30, 2015EXCEL SUBSTITUTE FUNCTIONAugust 10, 2015Selecting Next Cells In A Different OrderJuly 26, 2015Why have a website?July 1, 2015Layout With ColumnsJune 7, 2015HTML5 CSS LAYOUTMay 24, 2015CSS SelectorsMay 17, 2015CSS BorderMay 10, 2015CSS BasicsApril 30, 2015Basics of HTML ImagesApril 26, 2015Basics of HTML LinksApril 19, 2015HTML Basics of ListsApril 12, 2015HTML Back To BasicsApril 9, 2015Multiplication Table Challenge SolutionJanuary 19, 2015Multiplication Table ChallengeJanuary 15, 2015Coming Soon – eBooksJanuary 11, 2015Create A Planner In ExcelDecember 8, 20143D SumNovember 23, 2014UPPER, lower & Proper in ExcelNovember 2, 2014Sort Left To Right In ExcelOctober 12, 2014Office Design TipOctober 6, 2014How To Add Macros To Custom ToolbarSeptember 29, 2014UnpluggingSeptember 5, 2014A Quicker Way To Create VLookUps Across Multiple ColumnsAugust 31, 2014Using Charts To Help You With Problem SolvingAugust 25, 2014The 5 Whys in Root Cause AnalysisAugust 13, 2014Add Video To PowerPointAugust 6, 2014PowerPoint Animation PaneJuly 28, 20142 Powerpoint Tips: Make your point, point by pointJuly 21, 2014PowerPoint Animation Tip: Leave it to the endJuly 13, 2014Problem Solving TipJuly 6, 2014Email Tip : Sort Out Your InboxJune 30, 2014Paste SpecialJune 23, 2014One button that will boost your personal efficiencyJune 16, 2014Excel Pivot TablesJune 8, 2014Page Breaks In WordJune 1, 2014Excel VBA Macro DemoMay 30, 2014Business Culture DifferencesMay 30, 2014Excel VBA : Debugging ErrorsMay 25, 2014Excel VBA : Working With Multiple FilesMay 21, 2014Excel VBA : Finishing Our File – Comments, Borders & Column WidthMay 9, 2014Excel VBA : Message Boxes & User InputsMay 7, 2014Excel VBA Macros : VariablesMay 5, 2014Excel Tip : OffsetMay 2, 2014Excel Tip : Ctrl And Arrow KeysApril 30, 2014Excel VBA Macros : Your First FormulaApril 27, 2014Excel VBA Macros : Format TextApril 22, 2014Excel VBA Macros : How To Change Text In A CellApril 19, 2014Excel VBA Macros : Understanding Our First MacroApril 13, 2014Excel VBA Macros : Answer To Challenge Question 1April 13, 2014Excel VBA Macros : Recording Your First MacroApril 9, 2014Excel VBA Macros : IntroductionApril 8, 2014Making Office work for you with VBA MacrosApril 6, 2014IFERRORMarch 31, 2014VLOOKUPMarch 23, 2014Wildcards in FormulaMarch 15, 2014The ABCs of good meetingsMarch 15, 2014SUMPRODUCTMarch 10, 2014How to get filename in ExcelMarch 6, 2014THE LEN LEFT RIGHT MID FORMULAS IN EXCELMarch 5, 2014COUNTIFFebruary 24, 2014SUMIFFebruary 17, 2014How to auto fill sequential letters in ExcelFebruary 12, 2014IF StatementsFebruary 10, 2014Brackets And Commas in ExcelFebruary 4, 2014Photo Editing Tutorial 3 : ZombieJanuary 26, 2014Just In TimeJanuary 14, 2014Home KeysJanuary 7, 2014Photo Editing Tutorial 2 : Color and Black And White Part 2December 18, 2013Image Layout in WordDecember 12, 2013Photo Editing Tutorial 2 : Color and Black and WhiteDecember 10, 2013WingdingsDecember 5, 2013Photo Editing Tutorial : Finishing TouchesDecember 3, 2013Navigating Tabs ShortcutNovember 28, 2013Photo Editing Tutorial : Zoom & EraseNovember 25, 2013Styles In WordNovember 21, 2013Photo Editing Tutorial : Lasso, Transparency and LayersNovember 18, 2013The Scroll ButtonNovember 14, 2013Introduction To Photo EditingNovember 11, 2013Desktop TidyNovember 7, 2013Thinking outside the packageNovember 4, 2013Context Menu ShortcutOctober 31, 2013When a shortcut’s not a shortcutOctober 29, 2013The Alt Key ShortcutsOctober 24, 2013The Trinity – 5s Lean and Six SigmaOctober 22, 2013PowerPoint TipOctober 17, 2013Six Sigma in Plain EnglishOctober 14, 2013Quick Access ToolbarOctober 10, 2013Root Cause and SymptomsOctober 8, 2013Combining Charts In ExcelOctober 3, 2013Accurate and PreciseOctober 1, 2013How To…. Quick Launch Toolbar to Windows 7 & 8September 26, 2013The best way, or just another way?September 24, 2013The Relevance Of Takt Time?September 19, 2013Do you remember the days – Maths in gamesSeptember 19, 2013& Let Us Begin! – Demonstrating Excel LogicSeptember 17, 2013
