What You'll Learn
- Overview of Excel Interface and Navigation
- Merging and Splitting Cells
- Absolute and Relative Cell References
- Using AutoSum and AutoFill for Efficiency
- Performing Text Manipulation with Functions (CONCATENATE, LEFT, RIGHT, MID)
- Using Data Validation to Control Input
- Removing Duplicates and Cleaning Data
- Adding Titles, Labels, and Legends to Charts
- Understanding PivotTables and Pivot Charts
- Creating Dynamic Reports with PivotCharts
- Performing Statistical Analysis with Functions (COUNTIF, SUMIF, AVERAGEIF)
- Adding Trendlines and Error Bars to Charts
- Designing Interactive Dashboards Using Excel Features
- Linking Data Between Multiple Sheets and Workbooks
- Editing and Debugging Macros Using the Visual Basic Editor
- Best Practices for Creating Effective Dashboards
Requirements
- No Prior Excel Knowledge is Needed.
- Beginners and Experts Will Learn a Lot From This Course.
Who This Course is For
- Anyone Interested in Becoming a Proficient Excel User.
- Anyone Curious to Master Excel in Short Span of Time.
- Build a strong foundation in Excel, even if you've never used it before.
- Take your Excel skills to the next level and impress your employer.
Your Instructor
Click Learning
Instructor at Udemy
4.1 Instructor Rating
4,512 Reviews
159,709 Students
34 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
Excel Data Analysis Visualization with Management Technique
Learn to Create Powerful Excel Data Visualizations and Apply Proven Management Techniques for Smart…
Free 100% Off
Today
Expires in 3 days
The Complete Microsoft Excel Course: Beginner to Expert
Master Microsoft Excel from the Ground Up – Learn Formulas, Functions, Pivot Tables, Data Analysis,…
Free 100% Off
Today
Expires in 3 days
Microsoft Excel - Excel Course For Beginners
Learn The Excel Essentials - Drop Down Lists, Charts & Graphs, Pivot Tables, Sorting, Filtering, LO…
Free 100% Off
Today
Expires in 3 days
Microsoft Excel Basic to Advanced: Ultimate Excel Mastery
Become an Excel expert: learn essential skills and advanced techniques in one course.
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.