Beginner to Expert Level – Fundamentals, Charts, Pivot Tables, Micro, Functions, Formula & More. MS Excel
5 hours on-demand video & 8 downloadable resources
This Course includes:
Introduction
- What is Microsoft Excel
- Where Excel Is Used
- Microsoft Excel Marketplace
Microsoft Excel Fundamentals
- Microsoft Excel Startup Screen
- Creating & Save Document in Excel
- Font Styles and Size
- Data Handling Basics – Cut, Copy and Paste
- Text Wrapping and Alignment
- Dates and Times Formats
- Numbers Format
- Find and Replace
- Working With Rows and Columns (Column & Row Cells Insert, Delete, Hide, Unhide, Merge)
- Freezing Rows and Columns
- Working With Multiple Worksheets
- Saving and Printing
- Relative, Absolute, & Mixed Cell References
- Ribbon & Quick Access Toolbar
- Cell Borders and Merging
- Allow Text/Numbers Only in Excel
- Protect Ranges & Worksheets in Excel
- Save Multiple Excel Sheets in one PDF File
Filtering and Sorting Data
- Basic Filtering
- Advanced Filtering
- Data Sorting in Excel
Creating Charts In Excel
- Creating Charts
- Create A Bar In Bar Chart In Excel
- Progress Circle Chart in Excel
- Create Pie Chart
- Create Line Chart
- Create Column Chart
- Format Charts in Excel
- Area Chart in Excel
- Waterfall Charts in Excel
- Combination Charts In Excel
- Multi-Color Scatter Plot Chart in Excel
Import and Export Data
- Data from Text Files
- Import Data from Web to Excel
- Transpose Data in Excel
- Parse Data in Excel Using Various Functions
- Exporting Data to Text File
Pivot Tables
- Create a Pivot Table
- Pivot Tables Filtering
- Pivot Table Slice
- Pivot Table Grouping
- Advanced Pivot Table Techniques
Micro
- Create Macros in Excel
- Edit a Macro in Excel
- Create Macro Buttons in Excel
Essential Excel Functions & Formulas
- IF Formula
- AND Formula
- OR Formula
- SUM, SUMIF, SUMIFS Functions
- PERCENTAGE Functions
- TODAY Function
- NOW Functions
- CHOOSE Function
- AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS Functions
MATCH Formula - ROUND, ROUNDUP, ROUNDDOWN Formulas
- COUNT, COUNTBLANK, COUNTIF, COUNTIFS Formulas
- UPPER, LOWER Formulas
Who this course is for:
- Anyone can do to develop their career in Microsoft Excel.
Recommended Courses
- The Complete Microsoft Excel Pivot Tables and Pivot Charts
- Excel Data Analytics With Pivot Tables & Pivot Charts
Can I download Excel – Microsoft Excel Course Beginner to Expert 2024 course?
You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Excel – Microsoft Excel Course Beginner to Expert 2024 course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.com
Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
