Banner Image

Skills

  • Analytics
  • Business Analysis
  • Copy and Paste
  • Data Analysis
  • Data Cleaning
  • Data Entry
  • Microsoft
  • Microsoft Excel
  • Pivot
  • VLOOKUP

Services

  • Work and services of Microsoft Excel

    $18/hr Starting at $25 Ongoing

    Dedicated Resource

    Get your requirements or work done with the below and make your job simpler. ​ Microsoft Excel Pivot table and chart Vlookup Microsoft Word Power BI - Beginner Data Analytics Business Analytics Copy and...

    AnalyticsBusiness AnalysisCopy and PasteData AnalysisData Cleaning

About

Business Analytics with Excel, VLOOKUP, Pivot Table and Chart

👉🏻 I have more than 10+ years of work experience in Microsoft Excel. I am enabled to complete complex Excel-related tasks. I am skilled in Excel with expertise in: Business Analytics like:

✅ Formatting - Formats the data, Makes data easy to read, Presents the data efficiently.

✅ Conditional Formatting - Helps us visualize data that make worksheets easier to understand. Highlights important information in the spreadsheet by using colors, icons, and data bars. Changes the appearance of one or more cells when the cell value meets certain conditions.

✅ Custom Formatting - The custom formatting helps us in changing the appearance of the cell value according to our needs.

✅ Logical Function - Logical functions evaluate a cell or cells for a criteria and return a Boolean value, true or false. Examples, IF, AND, OR, NOT, TRUE, FALSE

✅ Lookup and Reference Functions - Examples, VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET

✅ Statistical Functions - SUMIFS and COUNTIFs perform count and sum based on one or more criteria.

✅ PIVOT TABLES - Pivot table helps us to Summarize, Analyze, Explore and Present the data in tabular form. Pivot Table Makes life easy, Helps us to give data insights, Discovers new trends and patterns, Calculates and summarizes data, Easy to read and manipulate, Easy to design.

✅ Dashboarding - Dashboard is a graphical representation of our data, which initiates action., it understands the importance of interactive charts and form controls. Like Combo Box, Check Box, Radio Buttons, It is Easy to read user interface, Graphical presentation of data.

👉🏻 I have certified in:
Power BI for Beginners, certified on 30th Aug 2024, from Simplilearn, Skillup., Certificate code : 7331710
Excel Automation using ChatGPT, certified on 16th Sep 2024, from Simplilearn, Skillup., Certificate code : 7379246
Business Analytics with Excel, certified on 23rd Nov 2024, from Simplilearn, Skillup., Certificate code :7589351

👉🏻 Competencies: Business Analytics with Excel, Microsoft Excel, Pivot table and chart, Vlookup

Work Terms

Preferred Freelancing and flexible timings, communication through mails or messages in English language, Payments accepted to Direct Bank account.