Course Instructor
Duration
5 hours, 7 minutes
Last updated
February 11, 2023
5
Students
33
An intermediate-level Microsoft Excel covering more text, date, lookup and math functions expands to formula auditing to efficiently complete complicated excel tasks with a career guideline for anyone with any skillset to analyse your data or finances in detail.
PRIVATE
More about the course
This course on improving formatting, organising data, highlighting essential information and creating formulas/links between sheets will improve your accuracy and productivity and help you better understand critical features to enhance efficiency.
These skills are essential for anyone going into investments, banking, or consulting and will also be helpful for administrators or those who track or analyse a lot of data.
Also, someone new to the workforce will find that employers are looking for candidates with at least intermediate Excel skills.
MS Excel Intermediate course is designed for anyone who works with Excel in the workplace. An industry-renowned entrepreneur with a tech background developed this roadmap to reduce cost and sharpen efficiency in any business sector.
You will be able to do the following by the end of this course
- Create and use named ranges
- Sort and filter columns of data
- Create and modify charts and graphics
- Create a PivotTable for the group and summarize data
- Insert functions into spreadsheets, including Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
- Create and modify Tables, and apply advanced Conditional Formatting
- Apply advanced charting tools
- Apply advanced PivotTable features, create a PivotChart, and filter data using Slicers and Timelines
Is this course for you?
This intermediate course is designed for those who work with Excel in the workplace and primarily for those who want to improve their skills with this program. Explore this intermediate Microsoft Excel course if you have used Excel before and want to expand your knowledge. You’ll be able to skill in improving formatting, organising data, highlighting essential information and creating formulas/links between sheets. Improve your accuracy and productivity by utilising list management, handling large worksheets more effectively and enhancing the formatting of your spreadsheet data by using conditional formulas. Enhance your understanding of key features.Why Choose Mastering Excel 2019 - Intermediate course?
- Conducted by industry experts
- Get Instant E-certificate
- Fully online, interactive course with Professional voice-over
- Developed by qualified professionals
- Self-paced learning and laptop, tablet, smartphone-friendly
- Tutor Support
Certification
Industry Expert Instructor
Rated Excellent on Trustpilot
Course Content
-
- Introduction FREE 00:02:00
- Using Named Ranges, Part 1 00:05:00
- Using Named Ranges, Part 2 00:06:00
- Using Named Ranges, Part 3 00:05:00
- Working with Date Functions, Part 1 00:09:00
- Working with Date Functions, Part 2 00:05:00
- Working with Date Functions, Part 3 00:04:00
- Working with Time Functions 00:06:00
- Working with Logical Functions 00:09:00
- Working with Conditional Functions 00:08:00
- Multiple Criteria Functions 00:05:00
- Using Nested Functions 00:05:00
- Using IFS and SWITCH Functions 00:06:00
- Working with Text Functions, Part 1 00:05:00
- Working with Text Functions, Part 2 00:05:00
- Working with Text Functions, Part 3 00:04:00
- Working with Text Functions, Part 4 00:09:00
- Working with Math Functions 00:07:00
-
- Sorting Data, Part 1 00:06:00
- Sorting Data, Part 2 00:06:00
- Filtering Data, Part 1 00:06:00
- Filtering Data, Part 2 00:08:00
- Filtering Data, Part 3 00:08:00
- Querying with Database Functions 00:07:00
- Using the Subtotal Function 00:05:00
- Using the Subtotal Feature 00:07:00
- Creating Tables 00:07:00
- Modifying Table Styles 00:07:00
- Summarizing Data in Tables 00:05:00
- Using the Quick Analysis Shortcut 00:02:00
- Customizing Conditional Formatting 00:06:00
- Using Formulas with Conditional Formatting 00:06:00
- Inserting Graphics 00:09:00
- Modifying Graphics, Part 1 00:06:00
- Modifying Graphics, Part 2 00:07:00
- What’s Next? 00:00:00