PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

Close Notification

Your cart does not contain any items

Excel Tips and Tricks by Javier Sanz at Abbey's Bookshop,
Excel Tips and Tricks
— —
Javier Sanz

Excel Tips and Tricks

Javier Sanz

$18.95

Paperback

Not in-store but you can order this
How long will it take?
English
IngramSpark
23 September 2022
Funding of education & student finance; Educational equipment & technology, computer-aided learning (CAL); Finance
I researched the most looked up Excel questions on the Internet and responded them one by one in this book. Additionally, I added more content based on my professional experience as a Financial Analyst. This book covers everything you need to become an Advanced Excel user (i.e., Index-Match, Pivot tables, complex formulas, macros). You will find real-life examples that you could apply in your job as a financial analyst, data analyst, or similar.

Some examples from the book:

Elements covered1. 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!
By:  
Imprint:   IngramSpark
Country of Publication:   United States
Dimensions:   Height: 279mm,  Width: 216mm,  Spine: 4mm
Weight:   218g
ISBN:   9781088029435
ISBN 10:   1088029434
Pages:   62
Publication Date:  
Audience:   General/trade ,  ELT Advanced
Format:   Paperback
Publisher's Status:   Active

Javier is a finance professional with experience working in multiple countries. He loves learning and sharing skills with others. Originally from Spain, Javier lives in the United States with his wife and children.

See Also

Excel Tips and Tricks

Getting Research Funded

Five Essential Rules for Early Career...

Tseen Khoo

Hardback

$263 

Not in-store but you can order this

ADD +
Excel Tips and Tricks

The Debt Diet

Marquis Booker

Paperback

$23.95  $21.55

Not in-store but you can order this

ADD +
Excel Tips and Tricks

Lincoln's Big Adventure

Jordan Saez

Paperback

$22.99 

Not in-store but you can order this

ADD +
Excel Tips and Tricks

1008 Grams

Brandon Brooks

Paperback

$54.95  $46.40

Not in-store but you can order this

ADD +
Excel Tips and Tricks

Whippin Debt's Ass

Stenell Myers

Paperback

$24.99 

Not in-store but you can order this

ADD +
Excel Tips and Tricks

ICAEW ACA Certificate Level

6 Subjects Bundle

Azhar Ul Haque Sario

Paperback

$126.95  $101.91

Not in-store but you can order this

ADD +