Learn Microsoft Excel, Access, Powerpoint/Presentation, Words in Enugu

36000.00 ₦

Name: Obinna

You must log in or register a new account in order to contact the advertiser

Login Register


Learn Microsoft Excel, Access, Powerpoint/Presentation, Words in Enugu

Published date: July 15, 2019 | Category: Enugu Enugu State 042 Nigeria, Excel, Access Learn Microsoft Excel, Access, Presentation Powerpoint, | Location: Enugu North, Enugu, Nigeria

Learn Microsoft Excel, Access, Powerpoint/Presentation, Words in Enugu -Enugu Enugu State: Foxxymobile? Learn Microsoft Excel in Enugu Nigeria Africa : Enugu Enugu State: Learn Microsoft Access Data, Microsoft Excel, Microsoft Presentation, Microsoft Words at C45 C TO C PLAZA NKPOKITI, 8 PRESIDENTIAL ROAD, INDEPENDENCE LAYOUT ENUGU to Register Now. Each goes for NGN30,000K Per Month

Programme Outline :

1. Opening Excel .............................................................................................................................................. 5
2. Getting Started ............................................................................................................................................. 5
2.1. The Excel Interface ............................................................................................................................... 6
2.1.1. The Application Window ............................................................................................................... 7
2.1.2. The Workbook Window ................................................................................................................ 15
2.2. Creating and Opening Workbooks ....................................................................................................... 22
2.2.1. Create a new blank workbook ..................................................................................................... 22
2.2.2. Open an existing workbook ......................................................................................................... 23
2.2.3. Compatibility mode ..................................................................................................................... 25
2.3. Saving and Sharing Workbooks ............................................................................................................27
2.3.1. Save and Save As ..........................................................................................................................27
2.3.2. AutoRecover ............................................................................................................................... 28
2.3.3. Exporting workbooks ................................................................................................................... 29
3. Cell Basics ................................................................................................................................................... 31
3.1. Understanding Cells ............................................................................................................................. 31
3.2. Cell Content ......................................................................................................................................... 33
3.3. Find and Replace ................................................................................................................................ 39
4. Formatting Cells ......................................................................................................................................... 41
4.1. Font Formatting .................................................................................................................................. 42
4.2. Text Alignment ................................................................................................................................... 44
4.3. Cell borders and fill colors ................................................................................................................... 45
4.4. Cell styles ........................................................................................................................................... 47
4.5. Formatting text and numbers ............................................................................................................. 47
5. Modifying Columns, Rows and Cells ............................................................................................................ 49
5.1. Inserting, deleting, moving, and hiding rows and columns .................................................................... 51
5.2. Wrapping text and merging cells ......................................................................................................... 55
6. Formulas and Functions ............................................................................................................................... 57
6.1. Simple Formulas .................................................................................................................................. 57
6.2. Complex Formulas .............................................................................................................................. 62
6.2.1. Relative and Absolute Cell References ......................................................................................... 63
6.2.2. Relative cell references ............................................................................................................... 63
6.2.3. Absolute cell references .............................................................................................................. 66
6.3. Functions ............................................................................................................................................ 67
6.3.1. Creating a function ...................................................................................................................... 69
6.3.2. The Function Library .................................................................................................................... 71
6.3.3. The Insert Function command ..................................................................................................... 74
7. Working with Data...................................................................................................................................... 80
7.1. Freezing Panes and View Options ........................................................................................................ 80
7.2. Sorting Data........................................................................................................................................ 81
7.3. Filtering Data ...................................................................................................................................... 83
8. Working with Charts ................................................................................................................................... 84
8.1. Understanding charts ......................................................................................................................... 84
8.2. Chart layout and style ......................................................................................................................... 85
8.3. Other chart options .............................................................................................................................87
9. Printing Workbooks .................................................................................................................................... 89
9.1. Choosing a print area .......................................................................................................................... 90
9.2. Fitting and scaling content .................................................................................................................. 93

Introducing Microsoft Access 2013
Starting Access 2013
Creating and Opening Databases
Planning and Designing Databases
Closing the Database

Working With Tables
Introducing Tables
Creating Tables in the Database
*Retrieving Information
Sorting and Filtering Data
Handling Queries
Working with Data
*Creating Forms and Reports
Introducing Forms
Introducing Reports

Digital Goods

Youtube video

Vote
Result 0 votes
Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest

Comments


    You must log in or register a new account in order to post comments

    Login Register

    Location

    • Location: Enugu North , Enugu, Nigeria

    Useful Information

    Avoid scams by acting locally or paying with Local Bank Union Bank of Nigeria Plc Please read safety tips Do not pay in advance even for the delivery Try to meet at a safe, public location Check the item BEFORE you buy it Pay only after collecting the item
    Top