Overview
What does the course cover?
This course builds on the Excel Level 1 foundations course to teach you how to use the essential tools in Excel. You’ll learn V and H lookup, CountIf and SumIf and database functions. You’ll work with charts, graphs, filters and lists, import different file formats (like XML data) and track changes in a spreadsheet.
Aims
Why take this course?
This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You’ll have powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.
Audience
Who would benefit?
If you work with Excel on a regular basis there is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to make the most of the functionality of Excel.
Course Preview
Each course contains high quality, professional video lessons, downloadable exercise files and real-world templates for you to use.
Course Details
Section 1: Sharing workbook with others
- Lesson 1: Sharing workbook with others
- Lesson 2: Save and Send options
- Lesson 3: Saving an excel file in a different file format
- Lesson 4: Using Hyperlinks
Section 2: Protecting and maintaining a workbook
- Lesson 1: Protecting and maintaining a workbook
- Lesson 2: Customising advanced properties
- Lesson 3: Saving as a template
- Lesson 4: Importing and Exporting XML data
- Lesson 5: Protecting a worksheet and workbook
Section 3: Track Changes
- Lesson 1: Track Changes
- Lesson 2: Turning on track changes
- Lesson 3: Accept and Reject changes
- Lesson 4: Sharing workbooks
- Lesson 5: Restricting Access to a shared workbook
Section 4: Naming Cells
- Lesson 1: Naming Cells
- Lesson 2: Naming a cell or a range of cells
- Lesson 3: Moving to named cells
- Lesson 4: To delete or edit a named cell
Section 5: Data lists
- Lesson 1: Data lists
- Lesson 2: Adding cutsom lists
- Lesson 3: Advanced sort options
- Lesson 4: Applying conditional Formatting
- Lesson 5: Applying Filters
- Lesson 6: Applying custom filters
- Lesson 7: Subtotalling a list
- Lesson 8: Grouping and outlining data
- Lesson 9: Data validation
- Lesson 10: Drop down menus using validation lists
- Lesson 11: Creating a table to manage lists
Section 6: Advanced Formulae
- Lesson 1: Advanced Formulae
- Lesson 2: V and H lookup Functions
- Lesson 3: SUMIF Function
- Lesson 4: COUNTIF Function
- Lesson 5: Arrays
- Lesson 6: Database Functions
Section 7: Advanced Charts and Graphs
- Lesson 1: Advanced Charts and Graphs
- Lesson 2: Trendlines
- Lesson 3: Dual Axes
- Lesson 4: Saving a Chart Template
- Lesson 5: Sparklines
- Lesson 6: Advanced Sparklines options
Skills You’ll Learn
What you’ll be able to do after the course
- Save and export Excel into different formats
- Protect workbooks and worksheets
- Import and export XML and CSV files
- Work with Vlookup and Hlookup functions
- Filter and subtotal lists
- Work with named cells and ranges
- Use validation in a spreadsheet
How You Can Apply These Skills
What you’ll be able to use these skills for
- Perform data analysis
- Lookup prices or products based on IDs or dates
- Create advanced charts
- Create charts with trend lines
- Understand more complex spreadsheets
- Use conditional formatting to highlight key data
- Share workbooks with other users
Certification
When you pass you will receive an internationally recognized accreditation certificate like this:
What’s next?
Upon completion, you can move onto Excel Level 3. After you have completed the 3 levels you will be ready to take the Expert and Specialist courses in Excel for advanced Certification and for preparation for the Microsoft Certification exams.
Careers that require these skills at this level?
Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.
Want to start learning today?
Joining is simple, easy and risk free with our 7 day money back guarantee.
