- Home
- how to
Layout With Columns
Improving your layout with columns is easy to do. Whether you want to set a layout with 3 columns, or a 3 column layout, it’s simply and gives very different results. I say 3 columns, but this could be 2, 4, 5 whatever you want (the more columns you have, the less impressive the page […]
Continue readingHTML5 CSS LAYOUT
So, you can display text and images on screen, you can insert numbered lists and bullet point lists, you can change elements of the page, but you’re probably not feeling as warm and fuzzy about your website as you feel. Let’s look at HTML5 CSS Layout now, “div” in particular and then hopefully you will […]
Continue readingCSS Selectors
CSS Selectors allow us to target and style specific elements of our webpage. In the last post, we applied borders and fonts to different headers in our page. The different level headers (h1, h2, h3) are different elements of the page. In the CSS file, we use CSS selectors to select and style those […]
Continue readingCSS Border
Improve the look of your website with borders. They are easy to create and useful for separating sections of your page and improving the look of the site. CSS borders should not be mistaken for tables. Tables contain rows, columns, cells and may or may not have borders. A CSS border on the otherhand, is […]
Continue readingBasics of HTML Images
Without images and other media, websites can be as boring as phone books (remember those?). In this post I will show you how to add images to your HTML pages. The code for HTML images is relatively straightforward. If you have been following this series of posts, this is the 4th post in the series. […]
Continue readingBasics of HTML Links
If you’re following the series of posts, you will have created two basic html web pages so far, one called “index” and one called “music”. If you haven’t been following the posts, you can read them from here if you want… Basic HTML Page Basic Lists You do not need to follow these posts, if […]
Continue readingComing Soon – eBooks
Coming Soon – Our First eBook Our first eBook will be available for download soon. To start us in this new area, it will be free to all subscribers. This book will be based on some of the more useful Date & Time functions in Excel. If you’re not already a subscriber, you may sign […]
Continue readingCreate A Planner In Excel
It’s that time of year again when I start receiving requests for help with creating planners for the new year. These planners are usually for teams or groups to organise holiday schedules and rosters. This year I created a reusable planner that can be used in future years and also includes most of the features […]
Continue reading3D Sum
In Excel, a 3D Reference refers to the same cell or range in multiple worksheets. The 3D Sum allows you to sum the same cells in multiple worksheets. To demonstrate this, we have 4 worksheets and in Cell B1 of each sheet, there is a sales value that we want to get the total of. […]
Continue readingSort Left To Right In Excel
If you’ve covered even the basics of Excel, there is a good chance that at some point you have sorted at least 1 column of data in ascending or descending order. Sorting up and down is well covered in classes, books, tutorials and with a big button in Excel ribbons that says “Sort”, but […]
Continue readingOffice Design Tip
I’m often asked for help with, or to recommend a good (cheap) program for designing certain shapes like banners etc. There are many good ways to do this out there, feel free to look into some yourself, this is what I usually tell people, but I also give them an Office design tip. A […]
Continue readingHow To Add Macros To Custom Toolbar
Having trained a variety people and helped others with macros, especially in Excel, I have noticed a common issue – assigning keyboard shortcuts to the most regularly used macros. Ctrl along with most of the letters are already assigned as shortcuts, by assigning for example Ctrl and B to your macro, this overwrites the […]
Continue readingA Quicker Way To Create VLookUps Across Multiple Columns
Recently I have been asked by a few people for a quicker way to create VLookUps across multiple columns. In each case the user wanted a VLookUp to pull in several columns of data, but did not want to have to create a VLookUp for each column (one case would have been over 20 columns […]
Continue readingAdd Video To PowerPoint
Would you like to add video to PowerPoint presentations? Videos and other media can add to your presentations, enhance slides and for longer presentations they can give you a break from talking and give your audience a break from listening to you (no offence intended). So how do you add video? A common technique I […]
Continue readingPowerPoint Animation Pane
So you’ve put together the content of your presentation and you are now ready to animate it. This is where the PowerPoint animation pane comes into play. As well as making animation easier, faster and less painful to work with, the PowerPoint animation pane may also give you easier access to some options. If […]
Continue reading