Home

Sale Purchase SoftwareTask Management SystemAMS

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:

Click to learn more formulas.


Learn basic charts in Excel:


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



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

Preset Rules-

New Rules-

Manage Rules-


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

Sort:

Filter:


Learn Fill feature in excel in 3 chapters:


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.

Speedometer

 


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