Formatting in Excel seems to be a topic of interest for users at all levels of expertise. In this post I look at three different areas – formatting basics, formatting a report and formatting cells; so there should be something for everyone. Continue reading
Category Archives: 1 Beginner
Genealogy Chart
Today we are going to apply a few tricks to create a genealogy chart. (I had to check my spelling – it is often misspelt as geneology and geneaology.) This is equivalent to creating a Gantt chart if you are scheduling a project. I am going to use the genealogies in the Bible in Genesis chapters 5 and 10 as my data set. Continue reading
Introduction to Printing in Excel – Page Setup
The page setup options within Excel provide you with flexibility and control over printed output. In this post we look at the Page Layout view, the Page layout tab and the Page Setup dialog box. Continue reading
Introduction to Printing – Views
One of the things that I love about Excel is the amount of control and flexibility it provides when printing. In this post we will focus on some different ways of viewing what gets printed. In the next post we will take a closer look at the various options which provide the wonderful control and flexibility. Continue reading
Introduction to Charts
Learning to create charts or graphs is an important skill to learn for Excel users. Charts can show relationships between numbers visually which may not be obvious by looking at a screen full of numbers. A common obstacle when creating charts is addressed. The file from the Power Comparison post is used as an example. Continue reading