Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
14 Hour(s) 22 Minute(s)
Language
English
Taught by
Rajesh v
Rating
Course Overview
Microsoft Excel: Learn Advanced Formulas, Data Analysis, Automation, and Data Visualization
Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Microsoft Excel- Complete Master Program in MS Excel will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy Expert you can build on.
An accelerated, step-by-step program to give you a strong foundation to Expert Level Skills
Core Excel
Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Core Excel will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy foundation you can build on.
Core Excel Formulas and Functions
Formulas are the key to getting work done in Excel. In this accelerated video course, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. End your frustration with Excel formulas and Functions today.
Core Pivot
If you use Excel, but don't know how to use Pivot Tables, you're missing out...wasting time trying to do things that a Pivot Table can do for you automatically. With a small investment, Pivot Tables will pay you back again and again.
Core Charts
A picture is worth a thousand words. Nothing beats an effective chart for presenting data in a way people can instantly understand. Excel has a powerful and deep charting engine built right in, so you already have the tools you need to create a wide range of charts and visualizations. This course will untangle and demystify Excel's powerful charting tools, so you can create effective charts quickly and painlessly.
Excel Shortcuts
Shortcuts turbocharge your productivity in Excel: they help you work faster & more accurately, they let you focus on your work (not Excel's interface), and they unlock Excel's most powerful features. But shortcuts require practice to master. This video course covers over 200 Excel shortcuts, and includes a full set of practice worksheets. Start using more Excel shortcuts today!
Excel Tables
Excel Tables offer an easy way to create dynamic ranges that adjust when data changes. This makes tables perfect for pivot tables, charts, and dashboards that need to show the latest data. This course covers the key benefits of tables, including a detailed review of structured references, the special formula language for tables. Examples include VLOOKUP, INDEX and MATCH, and SUMIFS. The course also covers, table styles, slicers, filtering, sorting, and removing duplicates.
Conditional Formatting
One of the hottest trends today is data visualization. Why? Because when data is presented visually, people understand it immediately. This course will show you how to use Excel's conditional formatting to communicate key insights with clarity and impact. This is an accelerated program that takes you step-by-step through the capabilities of this powerful tool.
Happy Learning!
Course Content
- 10 section(s)
- 219 lecture(s)
- Section 1 Introduction
- Section 2 A Tour of Excel
- Section 3 Microsoft Excel Basics >>>>> (Module-I) <<<<<
- Section 4 Building a Workbook
- Section 5 Entering Data in Excel
- Section 6 Fill Handlers for Data Manipulation
- Section 7 Find and Replace in Excel
- Section 8 Font Formatting in Excel
- Section 9 Borders and fills
- Section 10 Cell References
What You’ll Learn
- Navigate and customize the Excel interface with ease
- Create, format, and manage spreadsheets for efficient data entry and organization
- Use basic to advanced Excel formulas such as SUM, IF, VLOOKUP, INDEX, MATCH, and more
- Apply logical, lookup, and statistical functions to solve real-world problems.
- Sort, filter, and summarize data using PivotTables and advanced filtering tools
- Perform in-depth data analysis with Excel's What-If tools, including Goal Seek and Scenario Manager
- Create and customize a wide range of charts (bar, pie, line, scatter, etc.)
- Harness full potential of Excel by creating Pivot tables with slicers
- Build interactive dashboards and reports using Pivot Charts and dynamic data visualization techniques.
- Leverage Excel’s data consolidation and external data connections to integrate with other data sources.
- Share and collaborate on Excel workbooks in real-time using cloud-based features
- Secure your workbooks with data protection tools like encryption, cell locking, and version control
Skills covered in this course
Reviews
-
KKgothatso Leolo
The course was a valuable learning experience the course covered data visualisation and sorting of the pivot table. what I appreciated most was the practical examples related to the course to simplify the course. A great course indeed
-
PPuneet Sukheja
Very Good and very use full
-
SSebastian Navarro
excellent explanation
-
SSteven Bryson Collins
better english
