Platform Access

Microsoft Excel

For Beginners

A fundamental application used when dealing with data, having the skill in using it allows easier advancement to more analytical softwares such as Power BI & Tableau

Enroll Now

Here's What You'll Get

With The Course

More than 4 hours of self-paced training videos

Build a strong foundation on your MS Excel skills

  • This course will give you a foundational knowledge on Excel as an application for storing, auditing, analyzing and visualizing data
  • Learn its features and the common formulas that you can use for real-world scenarios

  • Program Level - Basic
  • Field(s) of Study - Computer Software & App
  • Instruction Delivery Method - QAS Self-study

Details Of What You Will Learn

During This Course

  • Explore and understand the UI of Excel
  • Input data in an Excel spreadsheet with accuracy and efficiency
  • Utilize useful shortcuts
  • Utilize common Formulas & Functions
  • Identify Excel features and their purposes

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

MS Excel is the one of the most famous and utilized application used across every industry, from finance to the health industry, and even sports. It is a prerequisite at every job these days. If you know how to use Excel, you are already better than any other candidate in a job interview. Hiring managers want people who are good at analyzing data.

LEARN HOW TO

Utilize the key features Power BI

  • Getting started w Excel, workbook, sheet, and ribbon
  • Working with main formulas
  • Most useful Excel features
  • Top essential Excel functions
  • Analyzing and visualizing data with Excel
  • Best practices for storing and auditing data

Course Curriculum

1. Course Overview

  • Introduction

2. Getting Started w Excel

  • Excel, Workbook, Sheet, and Ribbon
  • Modifying Ribbon
  • Excel Objects
  • Data Entry, formatting data etc
  • Useful shortcuts

3. Important Functions

  • Absolute vs Relative and Numeric Functions
  • Boolean Operations
  • IF Function
  • VLOOKUP
  • Text Functions
  • INDEX and MATCH

4. Useful Excel Features

  • Flash Fill
  • Text To Columns
  • Remove Duplicates
  • Conditional Formatting
  • Hyperlink
  • Custom List
  • Investigating Data
  • Named Ranges
  • Create Dates

What our Students Say

Your Instructor

Antriksh Sharma

Super User at Microsoft’s Power BI community platform with over 80 solutions, 50 PBI solutions at Enterprise DNA’s community, and approx. 30 PBI solutions on other platforms. Passionately believes in sharing everything he knows.

  • 2+ years of experience in Power BI, Power Pivot, Power Query and SSAS
  • 2+ years of experience in DAX, optimizing DAX, and SQL language. Likes to read DAX blogs, articles, and books in free time
  • 1+ years of experience in Core Python and approx. 6 months of experience in Pandas/NumPy/Matplotlib/Seaborn etc. Python libraries for Data Analytics
  • 4+ years of experience in excel automation through VBA, likes to read VBA blogs in free time

Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or For Business access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA For Business platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

On-Demand

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace