Step-by-Step Tutorial on How to Start a Blog Using Google Blogger



Creating a blog can be an exciting, creative, and rewarding experience. It can be an outlet for expressing your ideas and giving a voice to your passions. With Google Blogger, starting a blog can be done quickly and easily. In this step-by-step tutorial, you’ll learn how to create a blog using Google Blogger. We’ll cover the basics of setting up your blog, selecting a template, customizing your blog, and writing your first post. This tutorial is designed to make the process of creating a blog stress-free and straightforward. Whether you’re a novice blogger or an experienced one, this tutorial will guide you through the process of creating a successful blog with Google Blogger.



Steps for creating a Blogger account

To begin your journey toward starting a blog, you’ll first need to create a Google Account. Creating a Google Account is free and will allow you to sign into multiple Google services such as Gmail, YouTube, and Google Sheets. You can create an account by visiting Account Settings and clicking Create an Account. When you create your account, make sure to select the option for a “Blogger” account type. After your account has been created, you will be prompted to select a user name. This is the name that will appear when people leave comments on your blog. Make sure to choose a name that represents you and is easy for others to remember. You may also want to select the option to receive email notifications when other people leave comments on your blog posts. This way, you’ll know when your readers are leaving feedback on your posts.

Setting up your blog

You’ll now need to sign into your Blogger account and click the “New Blog” button. This will take you to the prompt where you can enter your blog details and click the “Create Blog” button to finish setting up your blog. You’ll be prompted to select a category for your blog. Categories are used to group similar blogs. You can choose any category that best describes your blog. After selecting your category, you’ll be prompted to enter your blog name. Your blog name will be used as the title of your blog and will be displayed on search engine results pages. Next, you’ll be prompted to enter your blog address. Your blog address will be used to redirect people to your blog. After entering your blog details, you’ll be prompted to select a hosting plan. There are three hosting plans to choose from Basic, Plus, and Business. The hosting plan you select will depend on your blogging needs and how often you post. Once you’ve selected your hosting plan, click “Next” to proceed to the next prompt.

Selecting a template

Now that you’ve created your blog, you’ll need to select a template. Blogger comes with a variety of free and premium templates to choose from. Free templates are available to everyone who uses Blogger. Premium templates are available for those who subscribe to Blogger’s paid hosting plan. When selecting a template, you’ll want to make sure that it aligns with your blog’s niche. You’ll also want to select a template that allows you to fully customize it to your liking. You can select a template by clicking “Choose a template” on the “Design and layout” prompt. You can then scroll through the selection of templates until you find one that you like. Once you’ve selected a template, click “Next” to proceed to the next prompt.

Customizing your blog

Now that you’ve picked a template, you can customize your blog. You’ll start by selecting a colour palette that best represents your brand. You can then select the font style, font size, and font colour. You can also select a header image that will be displayed at the top of your blog. Now that you’ve chosen the colours, fonts, and images that you want to use on your blog, you can click “Next” to proceed to the next prompt.

Creating your first post

Now that you’ve finished customizing your blog, you’ll need to create your first post. Blog posts are what make up your blog. They are posts that you write that address a specific topic or question. To create your first post, you’ll start by selecting a template. Just like choosing a template for your blog, you’ll want to select a template that best represents your brand. Once you’ve selected a template, you can start writing your post by clicking “Edit post.” To save time, when writing your post, you can use Google’s Auto-fill feature to auto-populate your blog post’s title, images, and headlines. You can also use Auto-fill to insert links to other posts, images, or videos on your blog. When you’re finished writing your post, you can click “Publish” to publish your post on your blog. Now that you’ve published your first post, you’re ready to start your blogging journey. You’ve created a blog using Google Blogger. Now, you can focus on creating more content that your readers will love.

Publishing your post

When publishing your post, you’ll need to select the category that best describes your post. Doing this will help readers find your posts more easily. You can also select an appropriate tag that describes your post and will help readers find your posts. You can also select the Privacy setting for your post. The options are Public, Friends, or Private. You can change the Privacy setting for your posts at any time. You can also add a Privacy stop to ensure that no one can see your post until a certain date. Now that you’ve published your first post, you’re ready to start growing your blog and connecting with your readers. You’ve created a blog using Google Blogger. Now, you can focus on creating more content that your readers will love.

Promoting your blog

Now that you’ve published your first post, you’ll need to promote your blog. You can do this by connecting your blog to social media platforms. You can also promote your blog by connecting it to other blogs. You can do this by joining Blog Networks. To connect your blog to social media platforms, you’ll need to first sign into your Blogger account. Next, you’ll click “Promote” in your prompt. You can then click “Connect your blog to other services.” Now, you can select the platforms to that you want to connect your blog. Next, you can select the settings for each platform. When you’re finished, click “Finish” to save your changes. You can also join Blog Networks to promote your blog. Blog Networks are communities that allow bloggers to network and promote each other’s blogs. Joining a Blog Network is free and can help grow your blog and connect with readers. Now that you’ve connected your blog to social media, joined Blog Networks, and promoted your blog, you can focus on creating more content that your readers will love.

Monetizing your blog

Now that you’ve created a blog using Google Blogger, you may want to monetize your blog. There are two ways to monetize your blog: Google AdSense and affiliate marketing. Google AdSense is Google’s advertising network that allows you to earn money by displaying ads on your blog. You can sign into your Blogger account and click “Select an ad format.” You can then select the Google AdSense ad format that you want to display on your blog. You can also select the amount you want to charge per click. Once you’ve selected the ad format, you can preview the ad before publishing it on your blog. You can also increase your earnings by creating attractive and engaging content on your blog. You can also earn money by promoting other people’s products and services on your blog using affiliate marketing. To do this, you need to sign up for an affiliate marketing program. You can choose from a wide variety of affiliate programs and products to promote on your blog. Now that you know the ways you can monetize your blog, you can focus on creating content that your readers will love.

Conclusion

Now that you’ve created a blog using Google Blogger, you can focus on creating content that your readers will love. You can also promote your blog, join Blog

Microsoft Excel Tutorial- Hide or Unhide Rows and Columns

In most cases in Microsoft excel worksheet, it is necessary to hide or unhide certain rows or columns so as to make the whole worksheet compact and readable without scrolling to the right and left or up and down.

For example, if you want to insert chart into a worksheet and you don’t want certain columns or rows to appear on the chart, it is necessary to hide and later unhide those columns and rows when you are through with the chart.  

In this tutorial, I will be taken you through the steps of hiding and unhide rows and columns in Microsoft excel worksheet. So sit back and follow me along.

Table of Content

  • Explanation
  • Hide Columns and Rows
  • Unhide Columns and Rows

 

EXPLANATION



From the above figure, it can be seen that students are offering six subjects. The first subject is English follow by Mathematics, Chemistry, Physics, Biology, Geography. what happen if we want to plot a pie chat of students names against Mathematics scores. The problem here is that English column is between Name and Mathematics columns, and we need to select both Name and mathematics columns to insert the pie chart in the worksheet.

The solution to this problem is to hide the middle column (English) and then select the remaining columns (Name and Mathematics).

 

Hide Columns or Rows

The following steps below apply to both row and column

Step one:

Select the column or row

 

Click on the heading to select it as shown in the figure below




Steep two:

Right-click and from the drop down menu, select “Hide”




Outcome




Unhide Column or Row

The following steps below apply to both row and column

Step one:

To unhide a column or row, select the column or row to the right and left or up and down of the column or row you have already hidden.




Step two:

Right-click and from the drop-down menu that appears, select unhide.







Microsoft Excel Tutorial-How To Create Running Total

Running total is the gradual summation of values in a particular column or row in excel worksheet

This tutorial will take you through the steps of creating a running total (cumulative) using cell referencing.

As you can see in the figure below, the running total will automatically be updated when a new data is entered or added to a list of values in column B(Sales).

Let me take the time to explain the concept clearly.

Table of Contents

Step one: Total Sum
Step two: Cumulative (Running Total)
Step three: Copy The Running Total Formula to Other Cells
Step four: Enter The “IF” Condition


STEP ONE: TOTAL SUM

In cell B9 enter a simple SUM function to add all the sales values from cell B2 to B7.

=SUM (B2: B7)

Microsoft Excel Tutorial- Running-Total-Total-Sum

STEP TWO: CUMULATIVE (RUNNING TOTAL)

In cell C2 enter the SUM function =SUM (B$2: B2). What does the reference B$2 in this function represent? It is a mixed reference and it tells you that row 2 is fixed by adding a $ symbol in front of the row number. The second cell reference(B2) is a mixed reference, it means as the function is copied to other cells the row number is not fixed but changes to respective row numbers.

Microsoft Excel Tutorial- Running Total


STEP THREE: COPY THE RUNNING TOTAL FORMULA TO OTHER CELLS

Select cell C2 and coping its function down to cell C7. To do this, click on the lower right corner of cell C2 the drag it down to cell C7.

NOTE: The content of B$2 which is 420 does not change because it is a fixed reference, but B2 which is a mixed reference changed to B2, B3, B4, B5, B6, and B7 respectively.

RUNNING TOTAL FORMULA


STEP FOUR: ENTER THE “IF” CONDITION

Now in cell C2 enter the following conditional formula   =IF (B2 <> “”, SUM (B$2: B2), “”). 

What does this imply? It means if the value of B2 is not empty, the cumulative is displayed in cell C2, else it will display nothing in cell C2. Now copy this conditional formula to other cells through to cell C7.

Microsoft Excel Tutorial- Running-Total-Total-Sum




Microsoft Excel Tutorial- Running-Total-Total-Sum


CONCLUSION

Running total is very important in data analysis and statistics. To know the cumulative distribution of data and other advanced data manipulation.

Your suggestion and additions are highly welcomed. Thank you for taking the time to go through this tutorial.





How To Use AutoFill In Microsoft Excel



Many Microsoft Excel users are not aware of one important tool that can be used to automate some repetitive tasks. By using AutoFill, you can save a lot of time by not typing entry several times. I have received a lot of questions from people asking me where is AutoFill in excel; what are AutoFill features. Well, do not worry about yourself because I am going to open your eyes to some repetitive tasks you can use AutoFill to do in Microsoft excel.

Table of Content

  • What is AutoFill in Microsoft Excel?
  • Copy cell option
  • AutoFill date and time in excel
  • AutoFill days of the weeks in excel
  • AutoFill Month in excel
  • AutoFill Year in excel
  • AutoFill formula in excel

What is AutoFill in Microsoft Excel?

AutoFill is an excel feature that lets one enters data into an entire column or row from other cells in the same column or row.microsoft excel quest the next values to be entered into entire column or row based on the selected data. The selected data can be days of the weeks, serial numbers, dates, months, years, and so on. From this definition, AutoFill is an excel tool that fills columns or rows with data that follow a pattern based on the data selected in the same column or row.



How To Carry Out Simple And Advanced Calculation In Microsoft Excel



Lately, some visitors to my blog sent an email to me asking a series of questions, which prompted me to write this post. Questions such as: How do you create a formula in Excel? How do you calculate 20% in Excel? How do you calculate the total on Excel?

A basic and advanced mathematical calculation can be done using a Microsoft Excel spreadsheet. You can enter numbers and formulas in cells. These cells can be referenced to perform calculations in their contents whether you enter a number of formulas. Many a time when it is required to do simple arithmetic operation on the numerical values entered into the cells of excel spreadsheet.

In this article, I will be taken you through simple arithmetic and advanced calculations with Microsoft excel. In our day-to-day calculation, we add, subtract, multiply, divide, and raise values to the power of another number. I will be starting with the addition of numbers and subsequently with subtraction, multiplication, division, and exponentiation. So, get set and follow me along as I teach you simple and advanced calculation operation in Microsoft excel.

Note: to write or perform any arithmetic expression, the calculation, and formulas, you must start it with the equal to sign (=) in the cell that will contain the result of the arithmetic operation.

Content Outline

  • Addition of Numbers
  • Subtraction of Numbers
  • Multiplication of Numbers
  • Exponentiation
  • Using Excel Functions


Addition of Numbers

To add numbers in Microsoft Excel, follow the steps given below:

 Type Add in cell A1.

Press Enter. The cursor moves down one cell.
Type 1 in cell A2.
Press Enter. The cursor moves down one cell.
Type 2 in cell A3.
Press Enter. The cursor moves down one cell.
Type =A2+A3 in cell A4
Click the checkmark on the formula bar. Excel adds cell A1 to cell A2 and displays the result in cell A4.


The formula you entered will be displayed on the formula bar shown in the image below.
Note: clicking the checkmark on the formula bar is similar to pressing the Enter key. Excel records your entry but does not move to the next cell.

Subtraction of Numbers

Follow the steps below to subtract numbers in Microsoft excel:
Press F5 to display the “Go to dialogue box”.



Type B1 in the Go to reference field.
Press Enter. Excel moves to cell B1.
Type Subtract.
Press Enter. Excel moves down one cell.
Type 6 in cell B2.
Press Enter. Excel moves down one cell.
Type 3 in cell B3.
Press Enter. Excel moves down one cell.
Type =B2-B3 in cell B4.



Click the checkmark on the formula bar. Excel subtracts cell B3 fro cell B2 and the result displays in cell B4. The formula displays on the formula bar.

Multiplication of Numbers

You will recall when we were subtracting, we press F5 to display the “Go to” dialogue box. Another way of doing the same is by holding down the control key while pressing the “G” (Ctrl + G).the Go to dialogue box appears.




Type C1 in the Go to reference field.
Press Enter. Excel moves down one cell.
Type Multiply.
Press Enter. Excel moves down one cell.
Type 2 in cell C2.
Press Enter. Excel moves down one cell.
Type 3 in cell C3.
Press Enter. Excel moves down one cell.
Type =C2*C3 in cell C4.
Click the checkmark on the formula bar. Excel multiplies C1 by cell C2 and displays the result in cell C3. The formula displays on the formula bar.

Division of Numbers

To reference or go to a particular cell, you can just click on the cell to select it.
Click on cell D1.
Press Enter. Excel moves down one cell.
Type Divide in cell D1.
Press Enter. Excel moves down one cell.
Type 6 in cell D2.
Press Enter. Excel moves down one cell.
Type 3 in cell D3.
Press Enter. Excel moves down one cell.
Type = D2/D3 in cell D4.




Click the checkmark on the formula bar. Excel divides D2 by cell D3 and displays the result in cell D4. The formula displays on the formula bar.

Exponentiation

In mathematics, numbers are raised to the power of another. For example, 25 = 2*2*2*2*2, and 106 = 10*10*10*10*10*10. In Microsoft excel, the caret symbol (^) to indicate exponential of numbers.
Click on cell D5.
Type = D4^2.excel displays……..

Using Excel Functions
Check back for this part. Thank you for the time spent reading this article
















Tips To Spark Blogger Blog SEO With Breadcrumb

Tips To Spark Blogger Blog SEO With Breadcrumb
Tips To Spark Blogger Blog SEO With Breadcrumb

Breadcrumb plays an important role in adding SEO values to your blogger blog. It is little navigation that appears at the top of a blog post.in this tutorial, I will teach you how to add breadcrumb to the top of a blogger blog post.

Breadcrumb helps a blog to improve its internal linking strategy. Like other methods bloggers are using to improve the internal link count of their blogs- adding related posts widget, using category and label.

You may read:
How To Add a Related Posts To Blogger Blog

To add a breadcrumb to blogger blog, follow the steps below:

Sign-in into blogger dashboard > Edit HTML.

Tips To Spark Blogger Blog SEO With Breadcrumb
Tips To Spark Blogger Blog SEO With Breadcrumb



Still in the Edit HTML, press ctrl+F to find <div class=’blog-posts hfeed’>
Copy the above and paste it below the <div> tag.

Click the save template.
Refresh your blog and note the breadcrumb at the top of the post.

Tips To Spark Blogger Blog SEO With Breadcrumb3


As you can see from the picture above, the breadcrumb displays Home > Category > Blog post title. By reading the breadcrumb, visitors can easily navigate to a different section of the blog.



Working With Microsoft Word Files- Beginners Guide

Working With Microsoft Word Files- Beginners Guide
Working With Microsoft Word Files- Beginners Guide

In this tutorial, working with Microsoft word files, we shall be looking at how we can create a new document, open an existing document, renaming the document, and even closing Microsoft word.


Opening Microsoft word

The very first step in using Microsoft word is to open/launch it for use.  To open Microsoft word, there are three methods to use:


1)      Desktop

Look for the Microsoft-word icon on the computer screen, and double-click to open it.



2)      Start menu

i.                     Click on the windows start menu button.
ii.                   Select “All Programs”.
iii.                  Select “Microsoft Office”.
iv.                 Select “Microsoft Word”.

3)      Recent

This method can be used to open recently used word documents.  About 30 word documents can be accessed with this method.  Follow the steps below:


                                            I.            Open Microsoft word.
                                          II.            Click on the Microsoft Office button.
                                        III.            Select “Recent”.
                                        IV.            Select word document you want to open.

Create a word document

By creating a new document, I mean saving your document for the first time in the desired folder on your computer.  To create a new word    document, follow the steps below:

creating-microsoft-word-document
creating-Microsoft-word-document


  1. Click on the Microsoft Office button. 
  2. Select one “Save As”. 
  3. In the “Save As” dialogue box, type the name for the document, and also choose the location/destination folder
  4. Select Save


Rename word documents

Renaming a document may sometime be necessary to portray the content or purpose of the document. To rename a word document, first, locate the folder where the file is saved. Follow the steps  below:

        I.            Right-click on the document.
      II.            Select rename from the opened shortcut menu.
    III.            Type a new name in the selected bar.
    IV.            And press Enter key when done.

Close document

For proper computer usage, all opened applications must be properly closed before shutting the computer down. Failure to shutdown correctly may lead to damage or totally losing the document.
In all the Microsoft Office applications, there are many ways to close an application. But in this tutorial, I am going to explain three methods:

        I.            Close button

The close button is on the title bar at the very top of the screen. by clicking on this button, you can close Microsoft word.


Microsoft word close button


      II.            Taskbar

By right-clicking on the minimized button of Microsoft word the taskbar, a menu containing “Close window” is displayed. Click on close.

microsft word logo
Microsft word logo

    III.            Microsoft word logo

This logo is on the left side of the title bar as you can see it below. Just click on the logo, a menu containing Restore, Move, Minimize, Maximize, and Close. Click on close.

microsoft-word-logo
Microsoft-word-logo



These four methods of working with Microsoft word files can also be used with any office application (Excel, Word, Access, and PowerPoint).
Thank you for reading, your comments are welcomed.






How To Create Sitemap Page For Blogger Bog

How To Create Sitemap Page For Blogger Bog

Hi, everyone in this tutorial we are going to create a sitemap for our blogger blog. Creating an HTML sitemap is very simple and can be done very quickly.

A sitemap is a table of content for all the content of your blogger site. As you can see the example above, all the posts are displayed on one page. How would you like all the links to all your site contents are displayed on one page?

You may like:


Why do you need a sitemap for your blog? The answer to this question is having a table of content is like telling Google search engine how your blog articles/contents are arranged into levels and sections. This makes easy for Google bot to crawl the entire blog omitting anyone .secondly; visitors to the blog can easily navigate the entire blog by visiting the sitemap.

As part of the requirement to get accepted into the Google AdSense program, creating a sitemap for a blog is very necessary. Other pages like about us, contact us, privacy policy, and lastly submitting XML sitemap of your blog to Google webmaster tool are created the same way sitemap is created.
The sitemap code is added via HTML, so it is required you have basic knowledge of HTML. But do not be panic, because this tutorial is for beginners like you.

Creating an HTML sitemap is divided into two parts. The first is to create the page and add the link to the navigation menu. While the second is to copy a JavaScript code into the empty page that is created.


1.       Create the HTML page

Login into your Google blogger dashboard.
Select pages> New Page.
Type “Sitemap” as the title of the page.
Leave the content empty for now.
      Add the sitemap link to navigation menu

How To Create Sitemap Page For Blogger Bog


2.       Copy the sitemap code

Now, switch back to the sitemap page you have just created. Change the page content from compose mode to HTML. Copy the JavaScript code below into the page content area, and change URL in the code to your blog URL. Update and refresh the blog.

<div id="bp_toc">
</div>
<script src="http://mybloggerlab.com/js/sitemap.js" type="text/javascript"></script>
<script src="/feeds/posts/summary?alt=json-in-script&amp;max-results=9999&amp;callback=loadtoc" type="text/javascript"></script>

To see the effect on the page, refresh the blog and click the page in the navigation menu. You will see all the posts of the blog on a single page.


I see you excel in blogging. If you have any comment, do not wait to drop it here. Thank you for reading.


Ultimate Guide To Mouse Techniques – Microsoft Word

Ultimate Guide To Mouse Techniques – Microsoft Word
Ultimate Guide To Mouse Techniques – Microsoft Word

A mouse is one of the important devices that are used to enter data to the computer. It makes human-computer interaction very easy and enjoyable.
As a computer user, you must be proficient in the use of a mouse to make computer usage a good experience. A computer can still be used with only the keyboard, but this is only used by an advanced user. For example, computer engineers can work without a mouse if the mouse input is faulty. They know all the shortcut keys to use in place of a mouse.

This tutorial, ultimate guide to mouse techniques is written for the beginners and intermediate users who want to broaden their knowledge in Microsoft word. With my ten years’ experience as a computer teacher, Microsoft office precisely, I have come to know that many computer users do not know how to use the mouse effectively.

In this lesson, I will be looking into four beginners guide to mouse techniques in Microsoft word. So, sit back and follow the lesson. A quick look at the mouse techniques before we start:

1.Left-click
2.Right-click
3.Double-click
4.Dragging the mouse



Mouse Left-Click and Right-Click
Mouse Left-Click and Right-Click


       1.            Left-Click
Clicking the left mouse button once allows you to select any text or object on the screen. This mouse action is only used for selection. For example, to select a Microsoft word icon on the desktop, just click once on the mouse button.

       2.            Right-Click
By clicking the right mouse button, you will notice a menu is displayed showing a list of options to choose from. This menu is called a shortcut menu. This menu is used. If you are confused on what to do next, to show actions that can be carried out on what has been selected.

Mouse-Right-Click
Mouse-Right-Click


For example,  if I right-click on Microsoft word icon on the desktop. The shortcut menu for this iron is displayed as shown below. From there, I can now select “Open” from the list. In short, right-click is used to show a shortcut menu.

       3.            Double-click
Clicking the left mouse button twice on any folder or icon will open and displays the content of the folder or icon. Double-click is mainly used to open a folder, and secondly to launch an application.

Microsoft Word Icon
Microsoft Word Icon


       4.            Dragging the mouse
Hold down the left mouse button and move the mouse from the beginning of a text, sentence, and paragraph across to the end of the text. As you move the mouse across the text, it will be selected gradually.
This mouse technique is the best if you are selecting part of a paragraph in Microsoft word document.

Let me know if you are having any problem with this tutorial. You can drop your comments here. I will also try to add a video tutorial on this topic – “Ultimate Guide To Mouse Techniques-Microsoft word” for better understanding. Thank you for reading.