Welcome to PK-AnExcelExpert.com. Here you will learn beginning to advanced level Excel tutorials. You can download our Useful Templates, Utility Tools and Other Excel Related Products.
Our Excel Products
- Sale/Purchase Software V1.0
- Attendance Management System V1.0
- PK’s Function Kit (Free)
- Task Management System V1.0
- PK’s Utility Tool V1.0 (Free)
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:
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-
Learn Sort and Filter in 6 Chapters with step by step example:
Sort:
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
Dashboards
Learn and free download advanced dashboard in excel
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
- Introduction
- Macro Recording
- Variables and Data type
- Comments
- Input Box and Message Box
- IF THEN ELSE
- Select Case
- Workbooks
- Worksheets
- Cells and Range
- Formatting
- Cut, Copy and Paste
- Sort and Filter
- Loops in VBA
- VBA and Worksheet Functions
- User Defined Functions
- Error Handling