Advanced Excel – Part 1

Course Content

1.1 Conditional Formatting using Formula and Function: Row level formatting [Highlight entire row using Conditional formatting] 1 Quiz

Expand

Lesson Content

Row level formatting [Highlight entire row using Conditional formatting]

1.2 Conditional Formatting using Formula and Function: Conditional formatting with formulas using and() 1 Quiz

Expand

Lesson Content

Conditional formatting with formulas using and()

1.3 Conditional Formatting using Formula and Function: Conditional formatting with formulas using or() 1 Quiz

Expand

Lesson Content

Conditional formatting with formulas using or()

1.4 Conditional Formatting Using Both And and OR Formulas

1.5 Conditional Formatting using Formula and Function: Conditional formatiing with Vlookup() 1 Quiz

Expand

Lesson Content

Conditional formating with Vlookup()

2.1 What-If Analysis: Using goal seek 1 Quiz

Expand

Lesson Content

What-If Analysis: Using goal seek

2.2 What-If Analysis: Using data tables 1 Quiz

Expand

Lesson Content

What-If Analysis: Using data tables

2.3 What-If Analysis: Creating and editing scenarios 1 Quiz

Expand

Lesson Content

What-If Analysis: Creating and editing scenarios

3.1 Data Forms: Using forms to simplify data manipulation 1 Quiz

Expand

Lesson Content

Using forms to simplify data manipulation

3.2 Data Forms: Specifying criteria for finding records 1 Quiz

Expand

Lesson Content

Specifying criteria for finding records

4.1 Working with External Data: Querying external databases 1 Quiz

Expand

Lesson Content

Working with External Data: Querying external databases

4.2 Working with External Data: Importing text files 1 Quiz

Expand

Lesson Content

Working with External Data: Importing text files

4.3.01 Working with External Data: Power Query Editor- Loading-Saving Imported 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor- Loading-Saving Imported

4.3.02 Working with External Data: Power Query Editor- An Introduction 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor- An Introduction

4.3.03 Working with External Data: Power Query Editor- The Query List 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor- The Query List

4.3.04 Working with External Data: Power Query Editor- The Data Preview 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor – The Data Preview

4.3.05 Working with External Data: Power Query Editor- The Applied Steps

4.3.06 Working with External Data: Power Query Editor- The Home Tab 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor – The Home Tab

4.3.07 Working with External Data: Power Query Editor- The Add Column 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor – The Add Column

4.3.08 Working with External Data: Power Query Editor- The Transform Tab 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor – The Transform Tab

4.3.09 Working with External Data: Power Query Editor- The View tab 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor – The View Tab

4.3.10 Working with External Data: Power Query Editor- The Formula Bar 1 Quiz

Expand

Lesson Content

Working with External Data: Power Query Editor – The Formula Bar

5.1 Advance Pivot Table: Grouping options in pivot (Yearly, Quarterly, Date Wise, No slab wise) 1 Quiz

Expand

Lesson Content

Grouping options in pivot (Yearly, Quarterly, Date Wise, No slab wise)

5.2 Advance Pivot Table: Percentage option (Percentage of total, Percentage of column, Percentage of row) 1 Quiz

Expand

Lesson Content

Percentage option (Percentage of total, Percentage of column, Percentage of row)

5.3 Advance Pivot Table: Sorting 1 Quiz

Expand

Lesson Content

Advance Pivot Table: Sorting

5.4 Advance Pivot Table: Filtering 1 Quiz

Expand

Lesson Content

Advance Pivot Table: Filtering

5.5 Advance Pivot Table: Updating 1 Quiz

Expand

Lesson Content

Advance Pivot Table: Updating

5.6 Advance Pivot Table: Formatting 1 Quiz

Expand

Lesson Content

Advance Pivot Table: Formatting

5.7 Advance Pivot Table: Internal and External Source Data 1 Quiz

Expand

Lesson Content

Advance Pivot Table: Internal and External Source Data

Advanced Excel – Part 1-Course Feedback

Category	Technical Skills
No. of Lessons	29
Effort	10 – 15 mins, every 3 days
Course Duration	87 days
Lesson Formats	Assessments, Videos, Infographics
Level	Advanced
Language	English
Transcript	English
Certification	Yes

. //Disable PrintScreen