Home

Welcome to PK-AnExcelExpert.com. Here you will learn beginning to advanced level Excel tutorials. My objective is to make you an expert in Excel. 

Advanced Excel

---

Learn Excel Shortcut Key to improve productivity

Format cells Ctrl + 1
Select font Ctrl + Shift + F
Select point size Ctrl + Shift + P
Format as Number Ctrl + Shift + 1
Format as Time Ctrl + Shift + 2
Format as Date Ctrl + Shift + 3
Format as currency Ctrl + Shift + 4
Format as percentage Ctrl + Shift + 5

Click to learn more Short cut Keys.

---

Learn useful Excel formulas with example:

• VLOOKUP
• HLOOKUP
• MATCH
• INDEX
• INDIRECT
• OFFSET

Click to learn more formulas.

---

Learn basic charts in Excel:

• Line Chart
• Column Chart
• Bar Chart
• Stacked Column Chart
• Stacked Bar Chart
• Pie Chart
• Doughnut Chart
• Area Chart
• Combo Chart

---

Learn Pivot table in 15 Chapters with step by step example:

• Chapter-1: Insert a Pivot Table
• Chapter-2: Data Sorting in Pivot Table
• Chapter-3: Filters in Pivot Table
• Chapter-4: Value Field Settings in Pivot Table
• Chapter-5: Columns in Pivot Table
• Chapter-6: Groups/Ungroup in Pivot Table
• Chapter-7: Report Layouts In Pivot Table
• Chapter-8: Subtotals and Grand Total
• Chapter-9: Pivot Charts
• Chapter-10: Slicers in Pivot Table
• Chapter-11: Timeline in Pivot Table
• Chapter-12: Refresh Pivot and Change Data Source
• Chapter-13: Calculated Fields/Items in Pivot Table
• Chapter-14: Show Details in Pivot table
• Chapter-15: Pivot Tables, Slicers and Timeline Styles

---

• Learn Data Validation in 10 Chapters with step by step example:

• Chapter-1: Whole Number Validation
• Chapter-2:Decimal Number Validation
• Chapter-3:List (Drop down) Creation
• Chapter-4:Date Validation
• Chapter-5:Time Validation
• Chapter-6:Text Length Validation
• Chapter-7:Custom (Formula) Validation
• Chapter-8:Input Message
• Chapter-9:Error Alert (Stop,Warning and Information)
• Chapter-10:Circle Invalid Data

---

Learn Conditional Formatting in 12 Chapters with step by step example:

Preset Rules-

• Chapter – 1: Highlight Cells Rules
• Chapter – 2: Top Bottom Rules
• Chapter – 3: Data Bars
• Chapter – 4: Color Scales
• Chapter – 5: Icon Sets

New Rules-

• Chapter-6: Format all cells based on their values
• Chapter-7: Format only cells that contain
• Chapter-8: Format only top or bottom ranked values
• Chapter-9: Format only values that are above or below average
• Chapter-10: Format only unique or duplicate values
• Chapter-11: Use a formula to determine which cells to format

Manage Rules-

• Chapter-12: Manage and Clear Rules

---

Learn Sort and Filter in 6 Chapters with step by step example:

Sort:

• Chapter-1: Data Sorting
• Chapter-2: Sort by Color

Filter:

• Chapter-3: Data Filter
• Chapter-4: Text, Number and Date Filter
• Chapter-5: Filter by color
• Chapter-6: Advanced Filter

---

Learn Fill feature in excel in 3 chapters:

• Chapter-1: Fill-Down,Up,Left,Right,Series and Justify
• Chapter-2: Auto Fill and Custom List
• Chapter-3: Flash Fill

---

Tutorial Videos

Watch the videos for

• Charts and info-graphics
• Excel Functions
• Dashboards
• VBA Tutorials
• Power BI Tutorial
• Excel Games

---

Dashboards

Learn and free download advanced dashboard in excel

• Performance dashboard
• Sales dashboard
• Process Dashboard
• Incentive dashboard

 

---

Excel Charts and Info-graphics

Learn world class Excel charts and info-graphics.

• Battery Chart
• Speedometer Chart
• Test tube Chart
• Progress Circle chart
• Moving Man Chart
• Dynamic Chart with check boxes

 

---

VBA Course

1. Introduction
2. Macro Recording
3. Variables and Data type
4. Comments
5. Input Box and Message Box
6. IF THEN ELSE
7. Select Case
8. Workbooks
9. Worksheets
10. Cells and Range
11. Formatting
12. Cut, Copy and Paste
13. Sort and Filter
14. Loops in VBA
15. VBA and Worksheet Functions
16. User Defined Functions
17. Error Handling