- أماكن: Lagos Johannesburg - جنوب أفريقيا Ikeja Abuja Port Harcourt Durban Nairobi Windhoek Gaborone Johannesburg - جنوب أفريقيا Pretoria Cape Town Luanda Lusaka Maputo Beira Free State Secunda Swaziland Lesotho Port Elizabeth Madagascar Kinshasa Lisbon Mpumalanga Johannesburg - جنوب أفريقيا
- مدة الدورة التدريبية: 1 Day
تفاصيل الدورة
Unit 1: Introducing Microsoft Excel• About Microsoft Excel
• Start Microsoft Excel 2016
• Quit Microsoft Excel 2016
• The Excel 2016 environment
Unit 2: Saving, Closing and Opening Workbooks
• Start a new workbook
• Save a new workbook
• Save changes to an existing workbook
• Create a new folder
• Rename an existing folder
• Save an existing workbook with a new name and/or in a new location
• Save an Excel file as a PDF
• Open an existing workbook
• Close a workbook
Unit 3: Entering and Editing Data
• Enter text and numbers in a worksheet
• Edit text and numbers in a worksheet
• Find and replace text
• Move and copy data
• Check spelling
• Navigate and select cells and ranges
Unit 4: Basic Formulas
• About formulas
• Insert a formula
• Work with operators and order of operations
• Copy formulas using AutoFill
• Copy formulas with Relative and Absolute cell references
Unit 5: Using Functions
• About functions
• Ranges as arguments
• Insert simple functions
• Basic functions SUM(), AVERAGE(), MAX(), MIN(), COUNT()
Unit 6: Formatting a Worksheet
• Format text
• Work with cell alignment
• Format numbers
• Change cell fills
• Change cell borders
• Copy cell formats
• Insert, delete, hide and show columns, rows and cells
Unit 7: Working with Workbooks and Worksheets
• Switch between open workbooks
• Insert and delete worksheets
• Move and copy worksheets
• Change the colour of sheet tabs
• Hide and unhide worksheets
• View different parts of a worksheet
• View multiple workbooks or worksheets at the same time
Unit 8: Page Setup and Printing
• Print preview a worksheet
• Set up paper size, orientation and margins
• Insert headers and footers
• Set horizontal and vertical print titles
• Adjust page breaks
• Adjust print settings
• Set and clear a print area
• Print your worksheet, workbook or selection تحديث بتاريخ 08 February, 2023
المتطلبات
Course is delivered in English language. Learners must possess basic English and Mathematics communication level 1.
وظائف مناسبة لهذه الدورة
Data Analyst , Data Capturer , Training Administrator , HR Manager , موظفة إستقبال , HR Administrator , HR Officer , Admin Executive- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- 25,321 NGN
278,653 NGNمدة الدورة التدريبية: Upto 11 Hours - MS Office 2016 Excel for Beginners One Education29,217 NGN
619,228 NGNمدة الدورة التدريبية: Upto 5 Hours