Freelancer logosuNasıl İşlerİşlere Göz Atın Giriş Kaydolun Bir Proje İlan EdinProfile cover photoundefined
Şu anda adlı kullanıcıyı takip ediyorsunuz.
Kullanıcıyı takip etmede hata.
Bu kullanıcı kullanıcıların kendisini takip etmesine izin vermiyor.
Zaten bu kullanıcıyı takip ediyorsunuz.
Üyelik planınız sadece 0 takibe izin veriyor. Buradan yükseltme yapın.
Kullanıcının takip edilmesi başarılı bir şekilde bırakıldı.
Kullanıcının takip edilmesinde hata.
adlı kullanıcıyı başarılı bir şekilde tavsiye ettiniz
Kullanıcıyı tavsiye etmede hata.
Bir şeyler yanlış gitti. Lütfen sayfayı yenileyin ve tekrar deneyin.
E-posta başarılı bir şekilde doğrulandı.
Kullanıcı Avatarı
$10 USD / saat
   EGYPT bayrağı
el-mahalla el-kubra, egypt
$10 USD / saat
Şu anda burada saat 10:25 ÖS
Eylül 24, 2022 tarihinde katıldı
0 Tavsiye

Omar Ahmad B.

@Badromar5522

5,0 (1 değerlendirme)
0,7
0,7
$10 USD / saat
   EGYPT bayrağı
el-mahalla el-kubra, egypt
$10 USD / saat
%100
Tamamlanmış İş
%100
Bütçe Dahilinde
%100
Zamanında
Kullanılabilir değil
Tekrar İşe Alınma Oranı

Data Analyst

My name is Omar, a student at the Faculty of Engineering, Tanta University, I took courses from udemy and a grant from the digital Egypt platform of the Ministry of Communications. My Skills in Excel : I learn about the importance of data quality, and I know how to import file data into Excel. I also know about the fundamentals of data privacy. In addition, I know how to remove duplicate and inaccurate data, and how to remove empty rows in your data. Finally, I know how to deal with inconsistencies in your data and how to use the Flash Fill and Text to Columns features to help you manipulate and standardize your data.
Freelancer Data Processing Executives Egypt

Omar Ahmad B. ile işiniz hakkında iletişime geçin

Sohbet üzerinden herhangi bir detayı tartışmak için giriş yapın.

Portföy Ögeleri

Format the data as a table: Use the Format as Table option to format the data as a table.

Use AutoSum to calculate values: Use AutoSum to find the following values for column 'C' and record each of the values:

SUM
AVERAGE
MIN
MAX
COUNT

Create a Pivot Table: Use the PivotTable feature to create a pivot table that displays the Department field in the Rows section, and the Equipment Count in the Values section, so that the pivot table displays the sum of equipment count by department.

Sort the pivot table data: Use the Sort By Value set on the pivot table to sort it in descending order by the sum of equipment count.

Make two more pivot tables exactly the same as task 3: Follow the same steps you performed in Tasks 3 and 4 to create two more identical pivot tables so that you end up with 3 worksheets that contain identical pivot tables.

Analyze data in the pivot table: Use the PivotTable Fields pane to manipulate and analyze data in the two copied pivot tables as follows:

In pivot
Final Assignment – Part 2
Format the data as a table: Use the Format as Table option to format the data as a table.

Use AutoSum to calculate values: Use AutoSum to find the following values for column 'C' and record each of the values:

SUM
AVERAGE
MIN
MAX
COUNT

Create a Pivot Table: Use the PivotTable feature to create a pivot table that displays the Department field in the Rows section, and the Equipment Count in the Values section, so that the pivot table displays the sum of equipment count by department.

Sort the pivot table data: Use the Sort By Value set on the pivot table to sort it in descending order by the sum of equipment count.

Make two more pivot tables exactly the same as task 3: Follow the same steps you performed in Tasks 3 and 4 to create two more identical pivot tables so that you end up with 3 worksheets that contain identical pivot tables.

Analyze data in the pivot table: Use the PivotTable Fields pane to manipulate and analyze data in the two copied pivot tables as follows:

In pivot
Final Assignment – Part 2
Format the data as a table: Use the Format as Table option to format the data as a table.

Use AutoSum to calculate values: Use AutoSum to find the following values for column 'C' and record each of the values:

SUM
AVERAGE
MIN
MAX
COUNT

Create a Pivot Table: Use the PivotTable feature to create a pivot table that displays the Department field in the Rows section, and the Equipment Count in the Values section, so that the pivot table displays the sum of equipment count by department.

Sort the pivot table data: Use the Sort By Value set on the pivot table to sort it in descending order by the sum of equipment count.

Make two more pivot tables exactly the same as task 3: Follow the same steps you performed in Tasks 3 and 4 to create two more identical pivot tables so that you end up with 3 worksheets that contain identical pivot tables.

Analyze data in the pivot table: Use the PivotTable Fields pane to manipulate and analyze data in the two copied pivot tables as follows:

In pivot
Final Assignment – Part 2
Format the data as a table: Use the Format as Table option to format the data as a table.

Use AutoSum to calculate values: Use AutoSum to find the following values for column 'C' and record each of the values:

SUM
AVERAGE
MIN
MAX
COUNT

Create a Pivot Table: Use the PivotTable feature to create a pivot table that displays the Department field in the Rows section, and the Equipment Count in the Values section, so that the pivot table displays the sum of equipment count by department.

Sort the pivot table data: Use the Sort By Value set on the pivot table to sort it in descending order by the sum of equipment count.

Make two more pivot tables exactly the same as task 3: Follow the same steps you performed in Tasks 3 and 4 to create two more identical pivot tables so that you end up with 3 worksheets that contain identical pivot tables.

Analyze data in the pivot table: Use the PivotTable Fields pane to manipulate and analyze data in the two copied pivot tables as follows:

In pivot
Final Assignment – Part 2
Save the CSV file as an XLSX file: Click the 'Edit Workbook' button in the ToolTip to save the file as an XLSX file. The file is converted when you click 'OK' in the prompt.

Column widths: Sort out the widths of all columns so that the data is clearly visible in all cells.

Empty rows: Use the Filter feature to look for blanks and remove all empty rows from the data.

Duplicate records: Use either the Conditional Formatting or Remove Duplicates feature to look for and remove any duplicated records from the data.

Spelling: The original source file data has not been checked for errors in spelling. Check for spelling mistakes in the data and fix them.

Whitespace: Use the Find and Replace feature to remove all double spaces from the data.
Final Assignment – Part 1 In IBM Certificate

Değerlendirmeler

Değişiklikler kaydedildi
1 değerlendirme içinden 1 - 1 arasındakiler gösteriliyor
Değerlendirmeleri filtreleme kriteri: 5,0
€20,00 EUR
Highly qualified , on time, will work together again for sure
Data Processing Data Entry Charts
H
    bayrağı Hadi H. @Hadi177
4 ay önce

Omar Ahmad B. ile işiniz hakkında iletişime geçin

Sohbet üzerinden herhangi bir detayı tartışmak için giriş yapın.

Doğrulamalar

Tercih Edilen Freelancer
Kimlik Onaylı
Ödeme Onaylı
Telefon Onaylı
E-posta Onaylı
Facebook Bağlantılı

Önde Gelen Beceriler

Data Processing 1 Excel Microsoft Microsoft Office Excel VBA

Benzer Freelancerlara Göz Atın

Data Processing Executives in Egypt
Data Processing Executives
Excel Experts
Microsoft Developers

Benzer Vitrinlere Göz Atın

Data Processing
Excel
Microsoft
Microsoft Office
Önceki Kullanıcı
Sonraki Kullanıcı
Davet başarılı bir şekilde gönderildi!
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.