When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Beyond Basics: Excel Techniques for Smarter Analysis
From Data to Decisions: Intermediate Excel for Real-World Impact
This Course Includes
udemy
3.5 (16 reviews )
6h 41m 
english
Online - Self Paced
professional certificate
Udemy
About Beyond Basics: Excel Techniques for Smarter Analysis
Welcome to the course on Excel level 2. In this course, you will learn how to use advanced features and functions of Excel to create, analyze, and present data. You will also learn how to automate tasks, work with multiple worksheets and workbooks, and use data validation and protection tools. By the end of this course, you will be able to: - Apply conditional formatting and custom number formats to enhance the appearance of your worksheets. - Use formulas and functions such as IF, VLOOKUP, SUMIF, COUNTIF, and more to perform complex calculations and data analysis. - Create and modify charts, sparklines, and slicers to visualize and summarize data. - Use pivot tables and pivot charts to organize and manipulate large data sets. - Link, consolidate, and group data from multiple worksheets and workbooks. This course is designed for intermediate users of Excel who want to enhance their skills and productivity. To enroll in this course, you should have completed Excel level 1 or have equivalent knowledge and experience. You should also have access to a computer with Excel 2016 or later installed. We hope you enjoy this course and find it useful for your personal or professional goals. If you have any questions or feedback, please feel free to contact us at any time. Thank you for choosing us as your learning partner. Outline is below: · Conditional formatting · Average function/Count · Maximum function/Sum · Minimum function/SumIF · Basic Scenarios · Sheet Layout and design · Named Cells/Ranges · Absolute Referencing/ percentages · Basic Pivot Tables · Using 3-D Referencing · Goal Seek · Data Tables · Sheet and cell Protection · Linking Sheets and Workbooks · Using Array Formulae · Using Group and Outline/Saving Views · Naming Worksheets · Using the Subtotals Feature · Creating Templates · Basic Lookups/Basic IF
What You Will Learn?
- How to use Microsoft Excel Pivot tables to manage large data sets. .
- Save time with avoid common errors with Excel. .
- Learn how to use subtotals and other database features .
- Understand how to use the IF functions and lookups, such as Vlookup and Hlookup .
- Use conditional formatting to automatically colour up trigger cells .
- Learn how to use named cells and ranges and work with them in formulae .
- Create charts using advanced automated features and functions.