Logotipo do Freelancer Como Funciona Busque Trabalhos Fazer Login Cadastrar Publicar um ProjetoProfile cover photoundefined
Agora você está seguindo .
Erro seguindo usuário.
Esse usuários não permite que o sigam.
Você já está seguindo esse usuário.
Seu plano permite apenas 0 seguidas. Aprimore-o aqui.
Deixou de seguir o usuário com sucesso.
Ocorreu um erro ao deixar de seguir o usuário.
Você recomendou com sucesso
Ocorreu um erro ao recomendar o usuário.
Algo deu errado. Por favor, atualize a página e tente novamente.
E-mail verificado com sucesso
Avatar do Usuário
$10 USD / hora
Bandeira do(a) EGYPT
el-mahalla el-kubra, egypt
$10 USD / hora
No momento são 3:04 PM aqui
Entrou no Freelancer em setembro 24, 2022
0 Recomendações

Omar Ahmad B.

@Badromar5522

5,0 (1 avaliação)
0,7
0,7
$10 USD / hora
Bandeira do(a) EGYPT
el-mahalla el-kubra, egypt
$10 USD / hora
100%
Trabalhos Concluídos
100%
Dentro do Orçamento
100%
No Prazo
N/A
Taxa de Recontratação

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

Contate Omar Ahmad B. para falar sobre o seu trabalho

Entre para falar sobre qualquer detalhe pelo chat

Itens de Portfólio

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

Avaliações

Mudanças salvas
Mostrando 1 - 1 de 1 avaliações
Filtrar avaliações por: 5,0
€20,00 EUR
Highly qualified , on time, will work together again for sure
Data Processing Data Entry Charts
H
Bandeira do(a) Hadi H. @Hadi177
há 4 meses

Contate Omar Ahmad B. para falar sobre o seu trabalho

Entre para falar sobre qualquer detalhe pelo chat

Verificações

Freelancer Preferencial
Identidade Verificada
Pagamento Verificado
Telefone Verificado
E-mail Verificado
Conectado ao Facebook

Principais Habilidades

Data Processing 1 Excel Microsoft Microsoft Office Excel VBA

Busque Freelancers Parecidos

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

Busque Mostruários Parecidos

Data Processing
Excel
Microsoft
Microsoft Office
Usuário Anterior
Usuário Seguinte
Convite enviado com sucesso!
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.