Microsoft Excel for Intermediates

+ View more

Course overview

Throughout the course, you will learn various intermediate-level techniques and tools that will enable you to work more efficiently and effectively with Excel spreadsheets. You will gain a solid understanding of advanced formatting options, data analysis tools, and formula functions to perform complex calculations and data manipulation.

The course will cover topics such as conditional formatting, advanced charting techniques, data validation, sorting and filtering data, working with tables and pivot tables, using functions like VLOOKUP and IF statements.

By the end of the course, you will have acquired the skills necessary to tackle more complex Excel tasks, analyze data with greater accuracy, and create dynamic spreadsheets that meet your specific needs. Whether you use Excel for personal or professional purposes, this course will empower you to become a more proficient Excel user and unlock its full potential.

What will i learn?

Cell Styles
Copy as Picture , Custom and Special Formats
Worksheet Backgrounds, Watermarks Autofill Non-Adjacent Cells and Autofill on Multiple Sheets
Highlight Cell Rules, Top/Bottom Rules, Data Bars, Color Scales
Insert a Table and Style Options, Add Rows & Columns, Perform A Function in A Table
Summarize with Pivot Table
Data Validation and Drop Down Lists
Removing Duplicates
Text to Columns and Concatenate, Importing and Exporting Data, Multiple Sheet References and Consolidating Data – With or Without Links Cell Names
Date Formulas
VLOOKUP, VLOOKUP Exact Match, HLOOKUP and HLOOKUP Exact Match
CHOOSE, IF Statement and IFERROR
SUM, SUMIF and SUMIFS, AVERAGE, AVERAGEIF and AVERAGEIFS, COUNTIF and COUNTIFS
SUBTOTAL Function, Case Formulas, Fix Number Fields, Trim Spaces and Substitute Text
Chart Types, Instant Chart – Pie Chart, Update Chart, Column Chart, Picture Fill, Adjust Chart Size, Line Chart, Scatter Chart, Sparklines Chart Styles and Chart Layouts
Axis Options, Chart Titles, Legends, Data Labels, Apply Themes, Arrange
Group & Ungroup, Sort Data, Sort Multiple Levels, Filter Data and Subtotal
Creating Pivot Tables, Choosing Fields, Pivot Table Layout, Filtering Pivot Tables, Modifying Pivot Table Data, Pivot Charts, Slicers and GETPIVOTDATA Function
Workbook Passwords Protecting, Workbooks Unlocking Cells, Documents Properties, Inserting Hyperlinks and Sharing A Workbook Track Changes
Accept/Reject Changes Mark as Final, Templates, Save As Web Page, Macro Enabled Workbook, Workbook Design, Excel Performance Killers and Report Design Principles

Requirements

Basic Excel Knowledge: It is recommended that you have a basic understanding of Excel's fundamental features and functions before enrolling in the intermediate course. Familiarity with tasks such as creating and saving workbooks, entering data, formatting cells, and using basic formulas and functions will provide a solid foundation.
Computer Skills: Basic computer skills are necessary to navigate through the Excel software and perform tasks such as opening and closing files, managing folders, and using keyboard and mouse functions.
Software: Access to a computer with Microsoft Excel installed is essential. The specific version of Excel required may vary depending on the course, but compatibility with Excel 2016, Excel 2019, Excel 2021 or Excel for Office 365 is common.

Curriculum for this course

25 Lessons 07:16:45 Hours

Microsoft Excel for Intermediates Videos

25 Lessons 07:16:45 Hours

GROUPING
00:14:12
CONCATENATE and TEXT Functions
00:21:15
CONCATENATE and TEXT Functions Quiz
0:20:00
Data Validation
00:29:58
Data Validation Quiz
0:20:00
COUNT, COUNTA, COUNTIF and COUNTIFS Functions
00:12:56
COUNT, COUNTA, COUNTIF and COUNTIFS Functions Quiz
0:20:00
DATA CONSOLIDATION 1
00:14:30
DATA CONSOLIDATION 2
00:10:55
SUBTOTAL 1
00:17:49
SUBTOTAL2
00:11:55
SUBTOTAL Quiz
0:20:00
PASSWORDS
00:19:12
SUM, SUMIF and SUMIFS Functions
00:28:28
SUM, SUMIF and SUMIFS Functions Quiz
0:20:00
IF Function
00:16:42
IF Function Quiz
0:20:00
NESTED IF Function
00:15:26
FILTER AND ADVANCED FILTER
00:18:54
VLOOKUP
00:18:17
VLOOKUP Quiz
0:20:00
VLOOKUP Part2
00:14:14
VLOOKUP Part3
00:10:22
HLOOKUP
00:12:51
Name
00:08:49

Frequently asked question

What prerequisites do I need for the Microsoft Excel For Intermediate course?

This course is designed for individuals who already have a basic understanding of Excel's fundamental features and functions. It is recommended that you have completed a beginner-level Excel course or have practical experience working with Excel.

What topics will be covered in the course?

The course will cover a range of intermediate-level topics, including advanced formatting, conditional formatting, data validation, sorting and filtering data, working with tables and pivot tables, using functions like VLOOKUP and IF statements, and advanced charting techniques.

Will I have hands-on practice during the course?

Yes, the course includes hands-on exercises and practical examples to reinforce your understanding of the concepts.

What version of Excel is used in the course?

The course is designed to be compatible with multiple versions of Excel, including Excel 2016, Excel 2019, Excel 2021, and Excel for Office 365. The techniques and concepts taught in the course are applicable to these versions.

How long is the course?

The course duration can range from a few days to several weeks. The format may include a combination of video lectures, hands-on exercises, quizzes, and assignments.

Can I apply the skills learned in the course to my job or everyday life?

Absolutely! The skills learned in the Microsoft Excel For Intermediate course are highly practical and applicable to various professional settings and everyday life. You will be equipped with the knowledge to efficiently manage data, perform complex calculations, and create professional reports and analysis, which can benefit your job, personal projects, or business ventures.