Mastering Excel: Intermediate level
What you'll 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
Requirements
- Should complete the Excel basics course first but if the students have previous knowledge of Excel they will be able to take this course.
Description
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
Who this course is for:
- Microsoft Excel intermediate users, administrators, finance support workers, business owners, training an development creators
- Don't miss out, Excel is a great time saver, but if you don't know how to do something, Excel can be a great time waster.
Instructor
- 4.2 Instructor Rating
- 56 Reviews
- 421 Students
- 11 Courses
Since 1998, I have been working as a trainer for IT's Easy Training, specializing in Microsoft Office, Project and Visio. I have helped over fifteen thousand delegates master various Microsoft tools, especially Excel, Project and Access. I also teach Word, Visio, PowerPoint and Publisher. I enjoy discovering new features and sharing my expertise with my delegates. I customize my courses to suit the business objectives of my clients and offer email support and blog updates to assist them in applying their skills. I am located in the UK and travel throughout the country to provide training sessions.