Showing posts with label Microsoft Excel. Show all posts
Showing posts with label Microsoft Excel. Show all posts

25.1.14

cpacrsherr

STEP-BY-STEP PICTORIAL LEARNING OF MICROSOFT EXCEL 2010 -13: SAVINGS (Lesson 5)

By     No comments:

You are welcome to lesson 5, In this lesson you will learn how to use the Save and Save As commands, you will also get to know the difference between them, how to save as an Excel 97-2003 compatible workbook, and how to save as a PDF (Potable Document Format).
This lesson is special because you will learn the trick most people have been using to make PDF materials,

Am about to let you see how I was able to package this lesson materials into PDF that you have been downloading, starting from lesson 1 to this lesson, and most people use this trick to package their information products and sell online, so seat back an enjoy lesson 5 out of the total of 24 lessons under Excel.
Are you saving a workbook for the first time?
Saving it as another name? 

Sharing it with someone that does not have Excel 2010?
There are many ways you share and receive workbooks, which will affect how you need to save the file.
Difference Between "Save" and "Save As" Command

A). Save is used when you want to save a workbook for the first time, it can be used also to update a workbook when you have made some changes to it.

While  
 
B). Save As allows you to:
1. Choose a name and location for your workbook before you save.
2. Can also be use it if you are saving a workbook for the first time.
3. If you want to save a different version of a workbook while keeping the original.
4. If you want to save your workbook into other format like PDF.
5. If you want to make a duplicate of a workbook.
 
From the above, you can see that Save As is indeed a useful command.

why not download the full copy of lesson 5 which I have also converted to a PDF format using this Save As we have been talking about, download it here http://adf.ly/LXZSJ and learn how to convert Word documents to PDF etc.

Do you like this post? appreciate by clicking the share button below
Read More

17.2.13

cpacrsherr

STEP-BY-STEP PICTORIAL LEARNING OF MICROSOFT EXCEL 2010 -13: FORMATTING CELLS (Lesson 4)

By     No comments:
Spreadsheets that have not been formatted can be difficult to read. Formatted text and cells can draw attention to specific parts of the spreadsheet and make the spreadsheet more visually appealing and easier to understand.

In Excel, there are many tools you can use to format text and cells, and that is what we are going to concentrate on.
In this lesson, you will learn how to change the color and style of text and cells; align text; and apply special formatting to numbers and dates.
If you missed any Excel lesson, you can see all lessons when you click HERE
This lesson will teach us how to:
  • Formatting Text
  • Change the Font
  • Change the Font Size
  • Use the Bold, Italic, and Underline Commands
  • Add a Border
  • Change the Font Color
  • Add a Fill Color
  • Change Horizontal Text Alignment
  • Change Vertical Text Alignment
  • Formatting Numbers and Dates
  • Assignment
  • etc
This guide will show you in PICTURES each step you need to take to study Excel, click on this link http://adf.ly/JHtuO when the page opens, Click on SKIP AD at the top right corner to download the full Lesson 4 PDF.
Thanks, any question use the comment form below.

Subscribe to this blog below with your BEST EMAIL to get the remaining lessons delivered into your Email, even while you are sleeping
Don't forget to share this with your friends especially those seeking bank jobs, it will surely be of help to them, just click on the share buttons.
Read More

30.1.13

cpacrsherr

STEP-BY-STEP PICTORIAL LEARNING OF MICROSOFT EXCEL 2010 -13: Modifying Columns, Rows, and Cells (Lesson 3)

By     No comments:
We have seen Getting Started (Lesson 1) and Cell Basics (Lesson 2), today I bring you lesson 3 which is how to Modifying Columns, Rows, and Cells, if you follow these lessons very well, you could be better than those your counterpart who attend some of this training schools.

When you open a new, blank workbook, the cells are set to a default size. You do have the ability to modify cells, and to insert and delete columns, rows, and cells, as needed.
In this lesson, you will learn how to change row height and column width; insert and delete rows and columns; wrap text in a cell; and merge cells, it continues in the list below.
  • Working with Columns, Rows, and Cells
  • Modify Column Width
  • Set Column Width with a Specific Measurement
  • Modify the Row Height
  • Set Row Height with a Specific Measurement
  • Insert Rows
  • Insert Columns
  • Delete Rows
  • Delete Columns
  • Wrapping Text and Merging Cells
  • Merge Cells Using the Merge & Center Command
  • Access More Merge Options
This guide will show you in PICTURES each step you need to take to study Excel all by yourself, click on this link http://adf.ly/IEvYq when the page opens, Click on SKIP AD at the top right corner to download the full Lesson 3 PDF material now.

Thanks, any question use the comment form below. Don't forget to share this with your friends by clicking on the buttons below.
Read More

24.1.13

cpacrsherr

STEP-BY-STEP PICTORIAL LEARNING OF MICROSOFT EXCEL 2010 -13: Cell Basics (Lesson 2)

By     No comments:

In Lesson one we saw how to get started with Excel, In this lesson, we will be looking at Cell Basic, hope you will enjoy it.
You will need to know the basic ways you can work with cells and cell content in Excel to be able to use it to calculate, analyse, and organize data.This lesson will teach us how to select cells; insert content; and delete cells and cell content. You will also learn how to cut, copy and paste cells; drag and drop cells; and fill cells using the fill handle.
This lesson will introduce us to Cells and Cell Content, and you will see that cells are the basic building blocks of a worksheet. Cells can contain a variety of content such as text, number, formatting attributes, formulas, functions etc.
A cell is the intersection of a row and a column, therefore each rectangle in a worksheet is called a cell.
Each cell has a name, or a cell address based on which column and row it intersects. The cell address of a selected cell appears in the Name box.

This is a brief introduction of what lesson 2 is all about Download the PDF here http://adf.ly/Hr8O6 when the page opens, click on SKIP AD at the top right corner to Download the Complete lesson 2 in PDF.

Show you like this post by sharing it.
Read More

15.1.13

cpacrsherr

STEP-BY-STEP PICTORIAL LEARNING OF MICROSOFT EXCEL 2010 -13: Getting Started (Lesson 1)

By     No comments:
Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS X. It is a spreadsheet program that allows you to store, organize, and analyze information.

In this lesson, you will learn your way around the Excel 2010 environment, including the new Backstage view, which replaces the Microsoft Button menu from Excel 2007.

You will see how to use and modify the Ribbon and the Quick Access Toolbar, and how to create new workbooks and open existing ones.

After this lesson, you will be ready to get started on your first workbook. but first let me give you the table of content, so as to see that you are about to learn.

Table of Contents for Excel 2010

1: Getting Started with Excel
2: Cell Basics
3: Modifying Columns, Rows, and Cells
4: Formatting Cells
5: Saving
6: Creating Simple Formulas
7: Worksheet Basics
8: Printing
9: Creating Complex Formulas
10: Working with Basic Functions
11: Sorting Data
12: Outlining Data
13: Filtering Data
14: Formatting Tables
15: Reviewing and Sharing Workbooks
16: Using Templates
17: Working with Charts
18: Working with Sparklines
19: Using Conditional Formatting
20: Creating PivotTables
21: Using What-If Analysis
So this is what this Excel lesson contains, it covers the whole of Excel with this you will definitely become grounded in Excel.


Get the complete lesson 1 from the download link below

A job seeker in any financial organization or any other organization which involves analyzing figures and data MUST be conversant with the use of excel, to help you understand better I have carefully compiled a 21 CHAPTER (all with Pictures, self explanatory) work on excel called “STEP-BY-STEP PICTORIAL LEARNING OF MICROSOFT EXCEL 2010”.


This guide will show you in PICTURES each step you need to take to study Excel all by yourself, click on this link http://adf.ly/HRhzl (when the page opens, click on SKIP AD at the top right to download the full Lesson 1 PDF.)
If you have any question, use the comment form below. If you like this post, kindly share it using the social media button on this blog
Read More
© Copyright 2015 JINDUBLOG.|. Powered by Blogger.