Get Discount 5% Off
Subscribe to our newsletters now and stay up-to-date with new arrivals, updates and deals.
Currency
Some examples from the book:
1. 9 Excel functions you'll use 95% of the time. (SUMPRODUCT, SUMIFS, COUNTIFS, INDEX-MATCH-MATCH, IF, OFFSET, SUM, AVERAGE)
2. Excel functions for the other 5% of the time (MONTH, YEAR, MID, LEN, AND, OR, COLUMN, ROW, CONCATENATE, COUNT, COUNTA, EOMONTH, ROUND, LEFT, RIGHT, VALUE, VLOOKUP, HLOOKUP, IFERROR, ISNUMBER, MAX/MIN, TRIM, NETWORKDAYS, SUBTOTAL)
3. How to combine AND, and OR functions
4. How to delete blank rows
5. Unprotect a worksheet without knowing the password
6. Conditional formatting of cells
7. How to create a nested IF function
8. How to drag a formula to save time
9. How to reference Excel tables
10. How to show a number in thousands, millions, billions
11. Show me the last day of the month
12. How does Solver work? Solving a magic square
13. Extract text before or after space
14. How to color cells based on a condition
15. How to count colored cells
16. How can Excel fill in the blanks on a Word document?
17. Shortcuts to become super-efficient
18. Pivot tables are the bread and butter of Excel, here is why
19. Can Excel send emails?
20. Can Excel generate random numbers?
21. How to find text and replace it (works in formulas too)
22. When Excel shows: #N/A, #REF!, #VALUE!
23. When Excel doesn't scroll
24. How can I lock cell references in Excel?
25. How can I freeze a row and a column?
26. Where Excel saves temporary/backup/autosaved files
27. Which Excel version am I using?
28. Can I create an always-visible dropdown button?
29. What are circular references?
30. Can I combine two cells? Yes, two ways
31. How to save Excel as .pdf?
32. How can I print my entire spreadsheet?
33. How to create graphs with two axes
34. Excel without gridlines
35. How to split text into different columns
36. How to find and delete duplicates
37. How to create custom filters
38. How to create drop-down lists
39. How to extract text from a string
40. What is the order of Math operations in Excel?
41. How to calculate days between two dates
42. When to use the formula INT
43. How to move a chart using the arrows on the keyboard
44. Copy horizontally, paste vertically or vice versa
45. Can I break an Excel formula into different lines?
46. How to highlight the top 10 results
47. How do I password protect my workbook?
48. How can I select the entire sheet?
49. How to adjust column width quickly
50. How can I insert many rows/columns efficiently?
51. Excel deletes leading zeros, how to avoid it
52. The data status bar is your best friend
53. How to keep all text in one cell
54. Can I add a hyperlink in a cell
55. How to create a slicer to filter a pivot table?
56. Extract unique values from a list
...
And more!
You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).
You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).
If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.
We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.
When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.
Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.
Subscribe to our newsletters now and stay up-to-date with new arrivals, updates and deals.
Thanks for subscribing!
This email has been registered!
Product | SKU | Description | Collection | Availability | Product Type | Other Details |
---|