Full Tutorial: How I Use Microsoft Excel To Store and Create My Office File and Data's - Welcome to Sodeeqloaded Welcome to Sodeeqloaded: Full Tutorial: How I Use Microsoft Excel To Store and Create My Office File and Data's

Pages

Featured Featured
how-to-use-your-android-device-as
How To Use Your Android Device as Keyboard and Mouse
dent-free-data
Sharing of Apk Files on Whatsapp Made Easier
9mobile-special-offer
9mobile Special Data, Get 1GB Data for N200 and 5GB for N1000
mtn-double-data-cheat
New Method To Activate MTN 100% Double Data Bonus Via IMEI Tweaking


Saturday, August 11, 2018

Full Tutorial: How I Use Microsoft Excel To Store and Create My Office File and Data's

Hello my viewers in this Tutorial we want discuss with you on how to use Microsoft Excel to store and create document .
Microsoft Excel is very proficient when it come to using it for storing and create document with unlimited database and safety for you data's I use it to store my office document, project,  users data, Calculations Analysis e.t.c This part of my experience in using Excel in my office screen shot below.




READ ALSO:- How To Use Your Android Phone As A Modem For Your PC or Laptop With Phone Charger Cable

HOW TO START USING MICROSOFT EXCEL

First of all download it from "Google Playstore" For Android users for IOS IPhone users download it from "Apple store" For PC users Get the Software and installed it on system.

Installed the app on your device and launch the App

NOTE FOR PHONE USERS:- after launching the app before start using it you have to create Account With Excel With you Email.
Gmail Is preferable if you don't have gmail before Create One Here
Reason for create account With Excel is because if you don't have account with excel and you started using it to create your document unfortunately the excel will restrict you from access to does document in short period of time so you have create account to enjoy it to the last.

READ ALSO:- How To Identify Fake Tecno , Infinix And iTel Smartphones


1. Open your excel on your device it will set itself up after through with set up it will display some thing like in screenshot

Click the search folder and enter your email or phone to sign in or sign up for excel account as it shown in screenshot above after then click the arrow button to complete your registration procedure. But if you to skip sign in and sign up step just click sign in later link shown in screenshot above and enjoy it for temporary time but if you complete the registration steps you will enjoy it for permanent time after you complete the registration you are good to go.

READ ALSO:- How To Start MTN SME Data Reselling in Nigeria

How To create Document on Excel

On the home page of the excel you will see to two icon on left and right header of the page with green background as show in screenshot below.






After click on that what we use arrow to indicate in image above it will take you to where to create document we have different type stylish document on Excel select one you wish to work on

LIST OF STYLISH DOCUMENT ON EXCEL

We have  21 type of stylish of document

    Blank workbook

    Welcome to Excel

    Make List

    Total list

    Track my task

    Manage my money

    Personal Budget

    Family Budget

    Mortgage loan Calculator

10     College Course Manager

11     College Comparison Tracker

12     House Hold Organizer

13     Weekly Assignment Schedule

14     Daily Schedule

15     Invoice

16     Travel Expense Tracker

17     Trip Planner

18     Gift planner

19     personal inventory

20     Workout log

21     Video game Tracker

Does are the list of Documents stylish on Microsoft Excel we list above so pick one you desire to work on by practicing it to acquire more Skills on it.

We choose number one which is "Blank Workbook" we will teach you technical skills you need on Blank workbook

This is Sample of Blank workbook style in below image


FEATURES AND TECHNICAL SKILLS YO NEED TO KNOW ON BLANK WORKBOOK?

Note:- All this featured list below are place under A icon on top of excel header they use Capital letter "A with pencil" to indicate the icon whenever you want to use this featured you need to locate the icon and click it to popup all this featured out for use. Screenshot below







1. Font: font mean how you want your text face and size to be in particularly you may text face be in blue color and bold in size and select styles of text you want it form



2. Border: border mean how you want your line to be on the edged of the document

3. Fill color: this featured work on if you want to put background color to your text in the document fill color is the option for it.

4. Font color: this featured also work for changing of font face to any color you desire to change to.

5. Merge Center: this featured is also work on merge to block or cell together

6. Text Direction: this featured also on work on how you want direction of your document to be either left, right or center.

8.Cell style: this work for changing of default cell style to your which desire style e.g expand block, add stick line and so on.

9. Format Cell size: this featured use for how you want cell size of you documents to be by increase the height, width, of the cell format.

10. Clear: this featured is use to clear any typographical error occur when you are writing your documents by just highlight the errors and use clear option.


11. Auto Sum: this featured work for calculation and statistics documents you can use it to add up all your figure.

Major tips you need know about this above features

1. Copy content: to copy content from one page to another empty page is easy task just locate where your copy content to start click that area you see two circle in the line of border block drag that circle to highlight content you want to copy after drag it to destination something will come up on top of what you copy or popup shown in screenshot below with indicator



2.Auto sum: this auto sum features  is very efficient and calculative when it come to create calculation documents how to use it screenshot below

1. Click A Icon indicate with blue dot in below


2. Click the Auto sum indicate with dot blue
3. Click Sum under Auto sum that indicate with blue dot


4. You will see that all does figure listed have been sum

4. Merge center: we will show you how to merge block together in screen shot below just follow the blue dot dot we use for direction.

1. Locate where you want to merge


2. Drag it to destination of merging



3. Click A icon to popup features


4. Look for merge center and click it


5. You will now see that the block have been merge to center



We are going to drop video of this tutorial soon so stay tune

Hope this tutorial help and don't forget to share with friend by using share button below  let them know about Sodeeqloaded thanks.


Copy the link below and Share with your Friends:

Download Our Official Android App on Google Playstore HERE
OR
Download from another source HERE



No comments:

Post a Comment