Bridging Technology and Business Success | Join Trust Rich Academy.

+256 752 976 336 / +256 753 972 488

Namungoona Opp. Metropolitan Int'l Uni.

Apply NowContact Us

Data Analysis With Microsoft Excel

  1. Home
  2. Data Analysis With Microsoft Excel
Course Description
About The Prime Pack:

The prime pack is created to help you become an expert in Data Analytics with the help of Excel. The premium prime pack includes more than 20 hours of learning access, starting with the basics and essentials of Excel. You will later learn how to sort, filter, and organize data following Pivot Tables, Data Cleaning and Data Analysis. You will then obtain functional experience in Power Query.

Scope and Importance of Excel:
  • Data analytics can assist in the collection of big data and solve major issues faced by the Organization
  • Data analytics helps companies boost efficiency.
  • Excel Data Analyst salary ranges from 5-6 Lac per annum for freshers.
  • According to Forrester Research, 81% of businesses use Excel.
Why Should You Get This Course?
  • Automate your work data routine.
  • Learn Industry best practices, shortcuts, and tips & tricks to get things done and become 4x faster.
  • To master Microsoft Excel’s best features, such as formatting, working with tables, graphs, formulas, etc.
  • Learn the essentials of using Excel formulae and functions, as well as practical methods for sorting and filtering data in Excel.
  • To gain practical and advanced knowledge of Excel Applications such as Data Analysis, Data Visualization, Data Cleaning, Power Query, etc
Goals
  • Data analysis
  • Microsoft excel
  • Statistics
  • Freelancing
  • Learn to reduce the complexity of spreadsheets
  • Learn to manipulate data with calculations
  • Learn to unlock the power of dynamic formulas
  • Learn to make custom formulas/functions
  • Learn to conquer logical operators
  • Learn to set up special commands
  • Learn to use pivot tables
  • Learn to use Excel in the most efficient way with concepts like Data Analysis, Data Visualization, Data Cleaning, and Power Query.
Prerequisites
  • Beginners who are curious about data analysis
  • Researchers and University students
  • Want to become a global data analyst freelancer
  • Client data analyst and decision-makers
  • You should have basic PC computer knowledge.
  • A computer with Windows, Mac, or Linux OS is installed.
Curriculum
  1. Introduction to the Course and Instructor
  2. Getting Started with Data Analysis Course
  3. Descriptive Statistics: Part A
  4. Descriptive Statistics: Part B
  5. Inferential Statistics: Overviews of Hypothesis Testing
  6. Inferential Statistics: One Sample Test of Hypothesis
  7. Inferential Statistics: Two Sample Test of Hypothesis
  8. Guidelines on Fiverr Freelancing Marketplace
Key Highlights
  • Data analysis: Microsoft Excel offers a powerful platform for performing data analysis tasks efficiently and effectively.
  • Spreadsheet functions: Excel provides a wide range of built-in functions, such as SUM, AVERAGE, COUNT, and more, which are crucial for data analysis.
  • Data visualization: Excel enables users to create compelling visualizations, including charts and graphs, to present data in a clear and concise manner.
  • Pivot tables: Pivot tables in Excel allow users to summarize, analyze, and manipulate large sets of data easily, making it a valuable tool for data analysis.
  • Data cleaning and transformation: Excel provides various features and functions to clean and transform raw data, including removing duplicates, splitting cells, merging data, and more.
  • Statistical analysis: With Excel’s statistical functions, users can perform descriptive statistics, regression analysis, hypothesis testing, and other statistical analyses.
  • What-if analysis: Excel’s scenario manager and goal seek features enable users to perform what-if analysis, exploring different scenarios and determining the impact of changing variables.
  • Data modeling: Excel supports the creation of data models using Power Pivot and Power Query, allowing users to combine data from multiple sources and perform advanced analytics.
  • Excel add-ins: Additional add-ins like Power BI, Solver, and Analysis ToolPak expand Excel’s capabilities for data analysis, enhancing productivity and enabling more advanced analyses.
  • Freelancing opportunities: Proficiency in Excel data analysis opens up numerous freelancing opportunities, as businesses often require assistance with data manipulation, reporting, and analysis tasks.

About this Course

Duration: 4 Weeks

Certificate on Completion

Level Beginner

Price: UGX. 450,000 | $130

Join Now

Powered by
►
Necessary cookies enable essential site features like secure log-ins and consent preference adjustments. They do not store personal data.
None
►
Functional cookies support features like content sharing on social media, collecting feedback, and enabling third-party tools.
None
►
Analytical cookies track visitor interactions, providing insights on metrics like visitor count, bounce rate, and traffic sources.
None
►
Advertisement cookies deliver personalized ads based on your previous visits and analyze the effectiveness of ad campaigns.
None
Powered by