Microsoft Excel - Excel from Beginner to Advanced
4.7 /5- Offered byUDEMY
Microsoft Excel - Excel from Beginner to Advanced at UDEMY Overview
Duration | 21 hours |
Total fee | ₹9,600 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Microsoft Excel - Excel from Beginner to Advanced at UDEMY Highlights
- Course Instructor : Kyle Pew
- Master Microsoft Excel from Beginner to Advanced
- Build a solid understanding on the Basics of Microsoft Excel
- Learn the most common Excel functions used in the Office
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
- Maintain large sets of Excel data in a list or table
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
- Access to a Professional Trainer with 10+ years of Excel Training
- Access on mobile and TV
- Certificate of Completion
- 16 hours on-demand video, 4 articles
Microsoft Excel - Excel from Beginner to Advanced at UDEMY Course details
- This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
- If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
- Master Microsoft Excel from Beginner to Advanced
- Learn the most common Excel functions used in the Office
- Maintain large sets of Excel data in a list or table
- Learn dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
- Build a solid understanding on the Basics of Microsoft Excel
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Access to a Professional Trainer with 10+ years of Excel Training
- This Microsoft Excel course combines 4 different courses
- Microsoft Excel 101 - An Introduction to Excel
- Microsoft Excel 102 - Intermediate Level Excel
- Microsoft Excel 103 - Advanced Level Excel
- Master Microsoft Excel Macros and VBA in 6 Simple Projects
Microsoft Excel - Excel from Beginner to Advanced at UDEMY Curriculum
Microsoft Excel 101 Course Introduction
Microsoft Excel Fundamentals
Entering and Editing Text and Formulas
Working with Basic Excel Functions
Modifying an Excel Worksheet
Formatting Data in an Excel Worksheet
Inserting Images and Shapes into an Excel Worksheet
Creating Basic Charts in Excel
Printing an Excel Worksheet
Working with Excel Templates
Congratulations! You've Built a Solid Microsoft Excel Foundation
Microsoft Excel 102 Course Introduction
Working with an Excel List
Excel List Functions
Excel Data Validation
Importing and Exporting Data
Excel PivotTables
Working with Excel's PowerPivot Tools
Working with Large Sets of Excel Data
Congratulations! You're an Intermediate Excel User
Microsoft Excel 103 Course Introduction
Working with Excel's Conditional Functions
Working with Excel's Lookup Functions
Working with Excel's Text Based Functions
Auditing an Excel Worksheet
Protecting Excel Worksheets and Workbooks
Mastering Excel's "What If?" Tools
Automating Repetitive Tasks in Excel with Macros
Congratulations!
Microsoft Excel Macros and VBA Course Introduction
Project #1: Using Excel's Macro Recorder Tool
Excel VBA Concepts
Project #2: Moving Beyond the Basics and into VBA
Project #3: Preparing and Cleaning Up Data with a Little VBA
Project #4: Using VBA to Automate Excel Formulas
Project #5: Bringing it All Together and a Weekly Report
Project #6: Working with Excel VBA User Forms
Project #7: Importing Data from Text Files
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?