Nataka kujifunza ordinaly na advanced excel, niko Mbeya Mjini

[mwaseba]

Ninahitaji kujifunza excel ordinaly na advanced.niko mbeya mjini,
kwa yule mwenye ujuzi au anayeweza kunipa maelekezo sehemu ya kupata ujuzi huo ndani ya wiki moja.pesa ya kulipia huduma ipo tayar.ushauri wenu wadau

 

[KAKA YAKO NAPITA]

Ninahitaji kujifunza excel ordinaly na advanced.niko mbeya mjini,
kwa yule mwenye ujuzi au anayeweza kunipa maelekezo sehemu ya kupata ujuzi huo ndani ya wiki moja.pesa ya kulipia huduma ipo tayar.ushauri wenu wadau

mkuu mpaka mtu awe mbeya au hta mtu akiwa mbali anaweza kukusaidia,mim nipo tayari na nina mtaalam sana wa hyo kitu km vip nipm

 

[Horseshoe Arch]

Nyota yako si ya elimu tafuta vitu vingine vya kufanya...'Ordinaly' ni mdudu gani?

 

[The Monk]

mwaseba hongera sana ka hiyo hatua. Kwa kuanzia unamiliki laptop au computer ya aina yeyote?
Kama jibu ni ndio na una muda hata wa masaa mawili tu kwa siku, unaweza kujifunza mwenyewe kwa vitendo huku ukifanya majaribio mwenyewe kitu kitakachokupa uwezo na uzoefu wa kutumia vizuri excel.

Japo inategemea lengo lako ni nini, ukimaliza hapo utatakiwa utafute chuo kinachotambuliwa ili uweze kupata cheti cha kuonyesha uwezo wako kwa waajiri.

Kwa kuanzia tu, tembelea hii link hapa chini na kama utataka msaada wowote au maelekezo nijulishe, usihofu mimi msamaria hakuna malipo.

Excel 2007 Tutorial Homepage

 

[TEATO]

Ninahitaji kujifunza excel ordinaly na advanced.niko mbeya mjini,
kwa yule mwenye ujuzi au anayeweza kunipa maelekezo sehemu ya kupata ujuzi huo ndani ya wiki moja.pesa ya kulipia huduma ipo tayar.ushauri wenu wadau

Ndugu Mwaseba,
Global Business Consultancy (GBC) huwa tunatoa training za namna hiyo kwa makampuni na watu binafsi.
Ofsi zetu ziko Dar Kinondoni, Tanga Korogwe na Dodoma mjini...
Kwa individuals ambao wako mbali huwa tunawafuata at least wakijiarrange wakafika kumi (10)... Below that inakuwa cost kwetu kumfuata mtu individual mkoani halafu yuko mwenyewe.
Kama una uhitaji mkubwa na hiyo kozi, unaweza wasiliana nasi ili tuweze kuorganize training ya huko Mbeya na kama watu mkiwa wengi we will come as soon as possible.. wewe utakuwa organizer wetu huko, unaweza pia zungukia kwenye vyuo vya huko eg. TEKU ili muwe wengi zaidi tuwafwate... Gharama zetu ni ndogo tu, ila huwa zinategemeana na contents utakazohitaji. Nitakuwekea syllabus yetu hapa chini ili ukiwa interested tuweze kuwasiliana zaidi... Namba zetu ni +255-717-385-177
+255-713-388-317
+255- 789-895-005
SYLLABUS YETU FROM ORDINARY EXCEL USER TO ADVANCED EXCEL USER:

Lesson 1: Working with Custom and Conditional Formats
1.1Creating a Custom Format

• Create a custom number format
• Creating Conditional Formatting
• Editing Conditional Formatting
  
• Adding Conditional Formatting
• Deleting Conditional Formatting from the Selected Range

Lesson 2: Using Formulas and Functions

• Relative Cell Reference
• Absolute Cell Reference
• Using Text Functions
• Left Function Upper Function
• Concatenating the text values
• Date Functions
• Using Today Function Calculating using Date Function
• Using Sum Functions
• Using CountA Functions

Lesson 3: Working with Range Names

• Using Range Names
• Creating Range Names
• Using Range Names in Formulas
• Creating Range Names from Headings
• Deleting Range Names
• Creating 3-D Range Names

Lesson 4: Using Advanced Functions for Banks

• Using If Functions
• Using Nested If Functions
• Using Sum If Functions
• Using Count If Functions
• Using Vlook up Functions
• Using HLOOKUP Functions

Lesson 5: Managing Tables

• Creating Tables
• Naming the Table
• Changing the Table Style
• Creating a Total Row
• Creating a calculated column
• Using Filtering in Table
• Removing the Duplicate Record

Lesson 6: Using Auto Filter

• Sorting Data
• Using AutoFilter
• Creating a Custom AutoFilter
• Using Advanced Filter
• Using Database Functions

Lesson 7: Getting Most from your Data

• Creating Subtotal
• Using Automatic Outline
• Grouping Data Manually
• Using Data Validation

Lesson 8: Working with Carts

• Creating a Chart
• Formatting the Chart
• Adding Labels

• Changing the Chart Type
• Changing the Data Source
• Changing the Chart Location

Lesson 9: Working with Pivot Tables for Banking Operations

• Creating Pivot Tables
• Adding Pivot Table Report Fields
• Refreshing Pivot Table Report
• Changing the summary function
• Changing the Layout
• Creating report filter pages
• Creating Pivot Chart

Lesson 10: Creating and Using Shared Workbooks

• Sharing a Workbook
• Opening and Editing a Shared Workbook
• Tracking Changes
• Resolving Conflicts in a Shared Workbook

Lesson 11: Working with Worksheet Protection

• Protecting your Worksheets
• Protecting range with password
• Protecting your Workbook
• Protecting your Excel Files

Lesson 12: Working with Multiple Workbooks

• Linking Workbooks
• Editing the Link
• Consolidating Workbooks

Lesson 13: Working with Macros

• Display the Developers Tab
• Changing Macro Security Settings
• Running a Macro

• Recording a Macro
• Deleting a Macro

Lesson 14: Scenarios in Excel 2007 (Optional)

• How to Create a Report from a Scenario (Optional)
• Auditing Tools (Optional)

KARIBU SANA GBC; UTAFURAHIA HUDUMA ZETU.

 

[mwaseba]

Nashukuru sana kwa ushauri.nina laptop na pia nina uwezo mzur wa kutumia microsoft word isipokuwa excel ndo tatizo..so nikaona ni vema walau nikipata mtu wa kunifundisha hiyo excel ili niwe namlipa walau masaa 2 tu kwa siku.

 

[The Monk]

Nashukuru sana kwa ushauri.nina laptop na pia nina uwezo mzur wa kutumia microsoft word isipokuwa excel ndo tatizo..so nikaona ni vema walau nikipata mtu wa kunifundisha hiyo excel ili niwe namlipa walau masaa 2 tu kwa siku.

Kama unavitu vyote hivyo basi hauko mbali kua mtaalam wa excel, mwisho wa siku muda unaoutumia kufanya mazoezi mengi ndivyo utakavyoweza kumudu na kuwa mzoefu zaidi.

Hiyo link niliyokuwekea utajifunza yafuatayo:-



[TABLE="width: 597"]
[TR]
[TD="width: 47%, align: left"]Getting Started

• Spreadsheets
• Microsoft Office Button
• Ribbon
• Quick Access Toolbar
• Mini Toolbar

Customize Excel

• Popular
• Formulas
• Proofing
• Save
• Advanced
• Customize

Working with a Workbook

• Create a Workbook
• Save a Workbook
• Open a Workbook
• Entering Data

Manipulating Data

• Select Data
• Copy and Paste
• Cut and Paste
• Undo and Redo
• Auto Fill

Modifying a Worksheet

• Insert Cells, Rows and Columns
• Delete Cells, Rows and Columns
• Find and Replace
• Go To Command
• Spell Check

Performing Calculations

• Excel Formulas
• Calculate with Functions
• Function Library
• Relative, Absolute, & Mixed Functions
• Linking Worksheets

Macros

• Recording a Marco
• Running a Macro

[/TD]
[TD="width: 44%, align: left"]Sort and Filter

• Basic Sorts
• Custom Sorts
• Filter

Graphics

• Adding a Picture
• Adding Clip Art
• Editing Pictures and Clip Art
• Adding Shapes
• Adding SmartArt

Charts

• Create a Chart
• Modify a Chart
• Chart Tools
• Copy a Chart to Word

Formatting a Worksheet

• Convert Text to Columns
• Modify Fonts
• Format Cells Dialog Box
• Add Borders and Colors to Cells
• Change Column Width and Row Height
• Hide or Unhide Rows and Columns
• Merge Cells
• Align Cell Contents

Developing a Workbook

• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheets
• Copy and Paste Worksheets

Page Properties and Printing

• Set Print Titles
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Set Page Breaks
• Print a Range

Customize the Layout

• Split a Worksheet
• Freeze and Unfreeze Rows & Columns
• Hide and Unhide Worksheets

[/TD]
[/TR]
[/TABLE]


Source

http://www.fgcu.edu/support/office2007/excel/

 

[ISLETS]

Nashukuru sana kwa ushauri.nina laptop na pia nina uwezo mzur wa kutumia microsoft word isipokuwa excel ndo tatizo..so nikaona ni vema walau nikipata mtu wa kunifundisha hiyo excel ili niwe namlipa walau masaa 2 tu kwa siku.

mkuu kwanza jaribu kutafuta stationery yoyote hapo mjini mtu akufundishe hata bure unaweza kupata..
ukikosa kabisa basi jaribu pale GRACE COLLEGE,wapo maghorofani karibu na chuo cha mzumbe hapo Mbeya,huwa wanafundisha hayo mambo.

 

[mwaseba]

Nashukuru sana kwa ushauri

 

[Kichwa Ndio Mtu]

mwaseba hongera sana ka hiyo hatua. Kwa kuanzia unamiliki laptop au computer ya aina yeyote?
Kama jibu ni ndio na una muda hata wa masaa mawili tu kwa siku, unaweza kujifunza mwenyewe kwa vitendo huku ukifanya majaribio mwenyewe kitu kitakachokupa uwezo na uzoefu wa kutumia vizuri excel.

Japo inategemea lengo lako ni nini, ukimaliza hapo utatakiwa utafute chuo kinachotambuliwa ili uweze kupata cheti cha kuonyesha uwezo wako kwa waajiri.

Kwa kuanzia tu, tembelea hii link hapa chini na kama utataka msaada wowote au maelekezo nijulishe, usihofu mimi msamaria hakuna malipo.

Excel 2007 Tutorial Homepage

Excel nilijifunza mwenyewe bila kuelekezwa na mtu nikawa na advanced knowledge ya excel. Mambo mengine huhitaji kuelekezwa sana kipindi hicho mambo haya ya mitandao hayakua maarufu sana.

Akikomaa mwenyewe anaweza kujua ila kama hawezi apate shule msaada kidogo

 

[Kilimo]

Kama unavitu vyote hivyo basi hauko mbali kua mtaalam wa excel, mwisho wa siku muda unaoutumia kufanya mazoezi mengi ndivyo utakavyoweza kumudu na kuwa mzoefu zaidi.

Hiyo link niliyokuwekea utajifunza yafuatayo:-



[TABLE="width: 597"]
[TR]
[TD="width: 47%, align: left"]Getting Started


big up sana!

• Spreadsheets
• Microsoft Office Button
• Ribbon
• Quick Access Toolbar
• Mini Toolbar

Customize Excel

• Popular
• Formulas
• Proofing
• Save
• Advanced
• Customize

Working with a Workbook

• Create a Workbook
• Save a Workbook
• Open a Workbook
• Entering Data

Manipulating Data

• Select Data
• Copy and Paste
• Cut and Paste
• Undo and Redo
• Auto Fill

Modifying a Worksheet

• Insert Cells, Rows and Columns
• Delete Cells, Rows and Columns
• Find and Replace
• Go To Command
• Spell Check

Performing Calculations

• Excel Formulas
• Calculate with Functions
• Function Library
• Relative, Absolute, & Mixed Functions
• Linking Worksheets

Macros

• Recording a Marco
• Running a Macro

[/TD]
[TD="width: 44%, align: left"]Sort and Filter

• Basic Sorts
• Custom Sorts
• Filter

Graphics

• Adding a Picture
• Adding Clip Art
• Editing Pictures and Clip Art
• Adding Shapes
• Adding SmartArt

Charts

• Create a Chart
• Modify a Chart
• Chart Tools
• Copy a Chart to Word

Formatting a Worksheet

• Convert Text to Columns
• Modify Fonts
• Format Cells Dialog Box
• Add Borders and Colors to Cells
• Change Column Width and Row Height
• Hide or Unhide Rows and Columns
• Merge Cells
• Align Cell Contents

Developing a Workbook

• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheets
• Copy and Paste Worksheets

Page Properties and Printing

• Set Print Titles
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Set Page Breaks
• Print a Range

Customize the Layout

• Split a Worksheet
• Freeze and Unfreeze Rows & Columns
• Hide and Unhide Worksheets

[/TD]
[/TR]
[/TABLE]


Source

http://www.fgcu.edu/support/office2007/excel/

big up sana mkuu!