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
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
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