We created this post to compile all the Excel articles we have already created in the Blog. We separated by important topics of Excel and we put links to our free ebooks on the subject. Enjoy!
Introductory Content
- Why you should know how to use Excel
- How Excel Works
- Get to know Excel 2013 news
- 3 Tips for making Excel an ally of your productivity
- 5 tips to streamline your work in Excel
- 10 tips that will help you use Excel
- 10 advantages of spreadsheets compared to systems
- 3 Ways to Use Worksheets with Systems
- Test your Excel level with 10 questions
- 10 Things You Did not Know About Excel
- How to make a spreadsheet for anyone who has done more than 200
Shortcuts
Use of Data
- Hiding rows and columns
- Pass data from column to row and vice versa
- Filling Strap
- Working with dates
- Learn how to consolidate data from multiple spreadsheets
- Learn how to pass data from PDF to Excel
- How to freeze panels
- Transferring data between different worksheets
- Saving a spreadsheet in different formats
- Learn to never lose a spreadsheet (even without saving)
- How to create dropdown list with data validation
- Gain productivity with the auto filter
- Using spreadsheets on more than one computer
Protection
- Spam protection with password
- Monitoring changes in a worksheet
- Control access to parts of your worksheet
Formatting
- All about cell formatting
- Formatting Numbers as Currencies
- 10 Border Styles
- Make your spreadsheets smart with conditional formatting
- Conditional formatting and its applications
Important Functions
- PROCV (VLOOKUP)
- PROCH (HLOOKUP)
- Conditional Functions
- I SOMASE (SUMIF)
- SEASONS AND SEALS
- Order
- Greater and Lesser
- Financial Functions
- Indirect
- Today
- Mean, median and standard deviation
Graphics
- 10 Excel Chart Types
- Chart with Color Change in Relation to Goal
- Chart with Combination Box
- Chart with Scroll Bar
- Speedometer Graphic
- Bar chart with lines
- Creating sparklines
Dynamic Tables and Charts
Macros and VBA
- Macro in Excel - What's Your Use?
- How to create your first macro
- Creating and Combining Macros
- Creating Your Own Role
Advanced
- Inserting YouTube videos into a spreadsheet
- Extend selection to the end of the worksheet without scrolling
- Test the worksheet in different screen resolutions
- How to use the solver command
- Learn how to create scenarios
Did you miss any posts? Give your idea down here what we do for you!
Thanks Gadelha, we will see to develop more. Hugs
Hi Rafael.
I would like posts related to Dashboard, I think it would be super interesting.
Congratulations on your work.
Thankful!
Hi Valter, I suggest you put this question on our forum - https://forum.luz.vc/
Excuse me, I need some help, and I do not know if this is where I ask, but if you can help me or indicate who can.
I have a Spreadsheet that I type in some readings, dates, and other data that are typed into an Aba.
In other tabs, the graphs refer to the readings and dates (one set on each tab).
I'm making a way for these graphs to be generated by periods that I choose instead of all the data entered (via Macro). I was able to find it on the internet and I could do bad the graphic only works on the same tab of the readings. I was not able to make this work on separate tabs (same macro for all chart tabs).
I await feedback and help.
Thank you for now.
Att
Hi Juliana, how are you?
When you talk button are you referring to shortcuts? If so, great luck out, we have a free ebook with 80 most commonly used Excel shortcuts. You are in this link: http://planilhas.luz.vc/ebook-excel-atalhos
If you want something different, just tell me what we do, hugs.
I wanted 50 excel buttons and their functions
Hi Lorrayne, unfortunately it is not possible to put this icon for printing ... but if you want, just select everything, paste in a word document for example and print there ... I hope I have helped and any post suggestions you want to see and we still don't have is just leave it here
The legal organization of the materials in one place, it would be even better if it had the print version icon. Is it possible to create this icon so that we can print?