Excel Tricks
Learn new tricks in Excel to be more effective and efficient in writing spreadsheets. All tutorials are presented with illustrations and example can be downloaded in Excel format.
Here are the recommended tricks for you:
1. Index and Match
2. Max and If
3. Roots of Quadratic Equation
4. Count Working Days
5. Data Validation
6. Equation Editor
7. Counting Formulas
8. Circle Invalid Data
9. Disabling Save As Function
10. Linest Function
11. Batch Printing
12. Lookup Pictures
13. Combo Chart
14. Highlight Every Other Row
15. 4 Data Entry Tricks
16. Interpolate from Table
17. Flash Fill
16. Remove Duplicates
17. VBA Obfuscation
About Us
Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.
Contact Us
Follow Us
© Copyright 2023 Excelcrib | Privacy Policy