Logo Freelancer Comment ça marche Parcourir les emplois
Se connecter S'inscrire
Publier un projet
Photo de couverture du profil
Vous suivez désormais
Erreur de suivi de l'utilisateur.
Cet utilisateur n'utilise pas les utilisateurs à le suivre.
Vous suivez déjà cet utilisateur.
Votre plan d'adhésion ne permet que 0 suivis. Améliorez ici.
Ne suit désormais plus
Erreur lors de l'arrêt du suivi de l'utilisateur.
Vous avez désormais recommandé
Erreur lors de la recommendation de l'utilisateur.
Une erreur a eu lieu. Veuillez rafraîchir la page et réessayer.
E-mail désormais vérifié.
Avatar de l'utilisateur
$10 USD / heure
Drapeau de EGYPT
al-qantara east, egypt
$10 USD / heure
Il est actuellement 12:47 AM ici
Rejoint le mars 31, 2023
0 Recommandations

Osama S.

@Osama102

 0,0 (0 commentaires)
0,0
0,0
0%
0%
$10 USD / heure
Drapeau de EGYPT
al-qantara east, egypt
$10 USD / heure
N/A
Travaux complétés
N/A
Suivant le budget
N/A
Dans les temps
N/A
Taux de réembauche

MS Excel | VBA | Access | Data Analyse & Visualize

A proficient and creative VBA developer with a portfolio of custom Excel and VBA projects, such as trackers and macros to perform or automate specific tasks, Data analysis and visualization on Excel, static solutions and Reports creation, and Dynamic solutions, and Reports to keep updating as data is being entered. Microsoft Access Databases design, with friendly and robust user interface, Books formatting and layout designing, and animated presentations creation. An enthusiastic and curious learner with a keen interest in exploring modern technologies and skills.
Freelancer Excel Experts Egypt
Voir tous les Excel Experts en Egypt

Contactez Osama S. concernant votre travail

Connectez-vous pour discuter de tous les détails via la messagerie.

Portfolio

11755954
Dynamic Data Visualization and Drill Ins using Excel & VBA
11696126
In this project I used excel formulas and VBA macros to create 9 new sheets that contain specific data collated from 9 original sheets, sorted and filtered according to different criteria. The new sheets are dynamically updated as the original data changes, using defined names and formulas. Also, I used conditional formatting to apply consistent formatting to the new sheets, To optimize the performance of the workbook I used VBA to disable formula calculations and enable it on demand by pressing a button, as the workbook freezes for some time when performing formulas due to large amount of data.
Dynamic Data Sorting and Filtering with Excel Formulas
11696121
This project uses Excel VBA to calculate the wages of employees based on their fingerprint data. It reads a text file that contains the fingerprint data of each employee, such as their ID, name, and clock-in and clock-out times. It then calculates their working hours, overtime, deductions, and net pay. It also generates a summary report of the total wages paid to all employees. This project simplifies the payroll process and reduces human errors.
Excel VBA Wage Calculator
This project uses Excel VBA to calculate the wages of employees based on their fingerprint data. It reads a text file that contains the fingerprint data of each employee, such as their ID, name, and clock-in and clock-out times. It then calculates their working hours, overtime, deductions, and net pay. It also generates a summary report of the total wages paid to all employees. This project simplifies the payroll process and reduces human errors.
Excel VBA Wage Calculator
This project uses Excel VBA to calculate the wages of employees based on their fingerprint data. It reads a text file that contains the fingerprint data of each employee, such as their ID, name, and clock-in and clock-out times. It then calculates their working hours, overtime, deductions, and net pay. It also generates a summary report of the total wages paid to all employees. This project simplifies the payroll process and reduces human errors.
Excel VBA Wage Calculator
This project uses Excel VBA to calculate the wages of employees based on their fingerprint data. It reads a text file that contains the fingerprint data of each employee, such as their ID, name, and clock-in and clock-out times. It then calculates their working hours, overtime, deductions, and net pay. It also generates a summary report of the total wages paid to all employees. This project simplifies the payroll process and reduces human errors.
Excel VBA Wage Calculator
11696119
This project uses Excel VBA to check for duplicate formula parts in a selected column of a file. It allows the user to select a file and enter a column letter to check. It then splits each formula in the column into its parts and compares them with other formulas in the same column. It returns the formula parts that are used more than once and the cells that contain them. This project helps to identify and avoid redundant or inconsistent formulas in Excel.
Excel Formula Duplicate Checker
This project uses Excel VBA to check for duplicate formula parts in a selected column of a file. It allows the user to select a file and enter a column letter to check. It then splits each formula in the column into its parts and compares them with other formulas in the same column. It returns the formula parts that are used more than once and the cells that contain them. This project helps to identify and avoid redundant or inconsistent formulas in Excel.
Excel Formula Duplicate Checker
This project uses Excel VBA to check for duplicate formula parts in a selected column of a file. It allows the user to select a file and enter a column letter to check. It then splits each formula in the column into its parts and compares them with other formulas in the same column. It returns the formula parts that are used more than once and the cells that contain them. This project helps to identify and avoid redundant or inconsistent formulas in Excel.
Excel Formula Duplicate Checker
This project uses Excel VBA to check for duplicate formula parts in a selected column of a file. It allows the user to select a file and enter a column letter to check. It then splits each formula in the column into its parts and compares them with other formulas in the same column. It returns the formula parts that are used more than once and the cells that contain them. This project helps to identify and avoid redundant or inconsistent formulas in Excel.
Excel Formula Duplicate Checker
11696115
This project allows users to undo the changes made by a user in Excel after running any VBA macro. It stores the previous values of the cells before editing them, and then restores them when the user clicks the regular undo button or its assigned shortcut (usually CTRL + Z). This project enhances the functionality and usability of Excel data entry and VBA macros.
Excel VBA Undo Macro allows users to undo changes after VBA
11696112
Designed a Graph with labels to visualize data on Excel Chart
Data Visualization on graph using Excel
Designed a Graph with labels to visualize data on Excel Chart
Data Visualization on graph using Excel
11755954
Dynamic Data Visualization and Drill Ins using Excel & VBA
11696126
In this project I used excel formulas and VBA macros to create 9 new sheets that contain specific data collated from 9 original sheets, sorted and filtered according to different criteria. The new sheets are dynamically updated as the original data changes, using defined names and formulas. Also, I used conditional formatting to apply consistent formatting to the new sheets, To optimize the performance of the workbook I used VBA to disable formula calculations and enable it on demand by pressing a button, as the workbook freezes for some time when performing formulas due to large amount of data.
Dynamic Data Sorting and Filtering with Excel Formulas
11696121
This project uses Excel VBA to calculate the wages of employees based on their fingerprint data. It reads a text file that contains the fingerprint data of each employee, such as their ID, name, and clock-in and clock-out times. It then calculates their working hours, overtime, deductions, and net pay. It also generates a summary report of the total wages paid to all employees. This project simplifies the payroll process and reduces human errors.
Excel VBA Wage Calculator
This project uses Excel VBA to calculate the wages of employees based on their fingerprint data. It reads a text file that contains the fingerprint data of each employee, such as their ID, name, and clock-in and clock-out times. It then calculates their working hours, overtime, deductions, and net pay. It also generates a summary report of the total wages paid to all employees. This project simplifies the payroll process and reduces human errors.
Excel VBA Wage Calculator
This project uses Excel VBA to calculate the wages of employees based on their fingerprint data. It reads a text file that contains the fingerprint data of each employee, such as their ID, name, and clock-in and clock-out times. It then calculates their working hours, overtime, deductions, and net pay. It also generates a summary report of the total wages paid to all employees. This project simplifies the payroll process and reduces human errors.
Excel VBA Wage Calculator
This project uses Excel VBA to calculate the wages of employees based on their fingerprint data. It reads a text file that contains the fingerprint data of each employee, such as their ID, name, and clock-in and clock-out times. It then calculates their working hours, overtime, deductions, and net pay. It also generates a summary report of the total wages paid to all employees. This project simplifies the payroll process and reduces human errors.
Excel VBA Wage Calculator
11696119
This project uses Excel VBA to check for duplicate formula parts in a selected column of a file. It allows the user to select a file and enter a column letter to check. It then splits each formula in the column into its parts and compares them with other formulas in the same column. It returns the formula parts that are used more than once and the cells that contain them. This project helps to identify and avoid redundant or inconsistent formulas in Excel.
Excel Formula Duplicate Checker
This project uses Excel VBA to check for duplicate formula parts in a selected column of a file. It allows the user to select a file and enter a column letter to check. It then splits each formula in the column into its parts and compares them with other formulas in the same column. It returns the formula parts that are used more than once and the cells that contain them. This project helps to identify and avoid redundant or inconsistent formulas in Excel.
Excel Formula Duplicate Checker
This project uses Excel VBA to check for duplicate formula parts in a selected column of a file. It allows the user to select a file and enter a column letter to check. It then splits each formula in the column into its parts and compares them with other formulas in the same column. It returns the formula parts that are used more than once and the cells that contain them. This project helps to identify and avoid redundant or inconsistent formulas in Excel.
Excel Formula Duplicate Checker
This project uses Excel VBA to check for duplicate formula parts in a selected column of a file. It allows the user to select a file and enter a column letter to check. It then splits each formula in the column into its parts and compares them with other formulas in the same column. It returns the formula parts that are used more than once and the cells that contain them. This project helps to identify and avoid redundant or inconsistent formulas in Excel.
Excel Formula Duplicate Checker
11696115
This project allows users to undo the changes made by a user in Excel after running any VBA macro. It stores the previous values of the cells before editing them, and then restores them when the user clicks the regular undo button or its assigned shortcut (usually CTRL + Z). This project enhances the functionality and usability of Excel data entry and VBA macros.
Excel VBA Undo Macro allows users to undo changes after VBA
11696112
Designed a Graph with labels to visualize data on Excel Chart
Data Visualization on graph using Excel
Designed a Graph with labels to visualize data on Excel Chart
Data Visualization on graph using Excel

Commentaires

Modifications enregistrées
Aucun commentaire visible ici !

Expérience

Microsoft Excel, Word, PowerPoint, VBA Specialist

People Per Hour
mars 2023 - Jusqu'à présent
Profile Link: pph.me/osama-excel-vba

Éducation

Bachelor's degree, Electrical, Electronics and Communications Engineering

Suez Canal University, Egypt 2016 - 2021
(5 ans)

Contactez Osama S. concernant votre travail

Connectez-vous pour discuter de tous les détails via la messagerie.

Vérifications

Freelance préféré
Identité vérifiée
Paiement vérifié
Téléphone vérifié
E-mail vérifié
Connecté à Facebook

Meilleures compétences

Excel
Powerpoint
Visual Basic for Apps
Microsoft Office
UI / User Interface

Parcourir les freelances similaires

Excel Experts in Egypt
Excel Experts
PowerPoint Designers
Visual Basic for Apps Developers

Parcourir les présentations similaires

Excel
Powerpoint
Visual Basic for Apps
Microsoft Office
Utilisateur précédent Utilisateur suivant
Invitation désormais envoyée !
Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Logo Freelancer France / Français Aide & Assistance FreelanceCatégoriesProjetsConcours FreelancesEntrepriseAdhésionProgramme de Freelance PréféréGestion de projetEmplois locauxPhoto AnywherePrésentationAPI pour les développeursDevenez VérifiéApplication Desktop À proposÀ propos de nousComment cela fonctionneSécuritéInvestisseurPlan du siteHistoiresNouveautésÉquipeRécompensesCommuniqué de presseOffres d'emploi TermesPolitique de ConfidentialitéTermes et ConditionsPolitique de CopyrightCode de conduiteFrais et chargesPartenairesEscrow.comLoadshiftWarrior Forum ApplicationsLogo d'Apple App StoreLogo Google play
Échec de copie dans le presse-papier, veuillez réessayer après avoir ajuster vos permissions.
Copié dans le presse-papier.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.