- Home
- computer training
Using Pivot Charts For Better Analysis
Using Pivot Charts when analyzing data can show you more in one image and quicker than standard charts where you may have to create multiple charts. In this image, there are two standard charts showing the sales by person and the sales by region. But to the right we have a Pivot Chart which shows […]
Continue readingVLookup with multiple values
So, you can use a VLookUp to retrieve a piece of information. You can use SumIf to total a range based on criteria and you can use CountIf to count how many times criteria appears. What do you do though when you have to create a VLookUp with multiple values? The VLookUp will run through […]
Continue readingEXCEL SUBSTITUTE FUNCTION
I have been coming across more and more cases where people have problems with lookup formulas because databases do not have matching information. The most common type of incident I come across are where one database contains a name like “Adam O’Reilly” and another database has the name as “Adam OReilly”, with no apostrophe. So […]
Continue readingSelecting Next Cells In A Different Order
If you have ever used Excel, you probably know already that you can move from your current cell to the one to the right, or below by using the tab or return keys. So what if you want to select the next cell, but the next cell is not in the normal order? For example, […]
Continue readingLayout 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 readingCSS Basics
To improve the look and layout of webpages, CSS is often used alongside HTML. CSS (Cascading Style Sheets) can dramatically improve the look of your page with just a few small changes. If you’re following the HTML series of posts below you will have created 3 relatively bare looking pages. HTML Basics HTML Lists HTML […]
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 readingHTML Basics of Lists
This post will go through creating simple lists for your website. It covers ordered lists, unordered lists, definition lists and nested lists. In the last blog post we created a file called “index.html”. Click here to review the blog if you haven’t read through it already and want to continue following this series. If you’re […]
Continue readingHTML Back To Basics
As you look at websites, do you ever wonder about how it was made? Did it cost thousands to create? Was it made by a 45 year old virgin living in his mother’s basement? These thoughts are not entirely true. You can write your own website for free. It is true that there are some […]
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 reading