Nicolas Boucher's Linkedin Analytics

25 Underrated Excel Shortcuts (I bet you don't know them) I made a curated list of 25 underrated Excel shortcuts that can save you hours (and impress your colleagues) 👉 You want even more shortcuts? Get my Top 100 Excel shortcuts in HD, for FREE! https://lnkd.in/eSiaeN6K Excel Shortcuts List: 1. Move to the next open workbook window: Ctrl + F6 2. Move to the previous open workbook window: Ctrl + Shift + F6 3. Insert current time: Ctrl + Shift + : 4. Paste values & formatting only: Ctrl + Alt + V > T 5. Apply or remove cell wrap: Alt + H + W 6. Clear all formats: Alt + H + E + F 7. Insert a line break in a cell: Alt + Enter 8. Insert a new comment in a cell: Shift + F2 9. Open cell options menu: Shift + F10 10. Paste special - transpose: Ctrl + Alt + V > E 11. Insert sparkline from selected data: Alt + N + SL / SW / SO 12. Enter full-screen mode: Ctrl + Shift + F1 13. Record a macro: Alt + F8 14. Open the Visual Basic editor: Alt + F11 15. Autofit column height: Alt + H + O + A 16. Hide a sheet: Alt + H + O + U + S 17. Unhide a sheet: Alt + H + O + U + H 18. Insert slicers: Alt + N + SF 19. Apply or remove strikethrough: Ctrl + 5 20. Expand or collapse the formula bar: Ctrl + Shift + U 21. Collapse sheet outline: Alt + A + H / J 22. Create names from selection: Ctrl + Shift + F3 23. Insert new worksheet: Shift + F11 24. Select an entire row: Shift + Space 25. Select an entire column: Ctrl + Space 👉 Interested in more Excel tips? Check our Top 100 Excel tips cheatsheet! https://lnkd.in/eSiaeN6K What’s your go-to Excel shortcut? Drop it in the comments—I’d love to learn more hacks! 👇

Top 100 ChatGPT Tips You probably use ChatGPT only at 5% of its potential With this cheat sheet, 10X the way you use ChatGPT 📚Download the high-quality PDF for free now: https://lnkd.in/eBG3fmSW I've spend weeks preparing these 100 tips for you Check these 100 tips, especially the shortcuts and advanced tips! Here’s a breakdown of the tips you'll find inside: 1. FRAMEWORKS – Structure your prompts better for better results • AIDA (Attention, Interest, Desire, Action) – Great for marketing & persuasion • STAR (Situation, Task, Action, Result) – Perfect for case studies & storytelling • 5W+H (Who, What, When, Where, Why, How) – Helps with research & planning • SMART (Specific, Measurable, Achievable, Relevant, Time-bound) – Goal setting made easy • BRAC (Bias, Risk, Assumption, Constraint) – Helps in risk assessment 2. SHORTCUTS – Work faster with these key commands • Open a new chat → Windows: Ctrl + Shift + O | Mac: Cmd + Shift + O • Copy last response → Windows: Ctrl + Shift + C | Mac: Cmd + Shift + C • Undo action → Windows: Ctrl + Z | Mac: Cmd + Z • Reset Zoom → Windows: Ctrl + 0 | Mac: Cmd + 0 • Keyboard navigation in ChatGPT → Scroll to Top: Windows: PgUp | Mac: Fn + Up Arrow 3. DATA – Use ChatGPT for powerful data analysis • Convert text to a table – “Turn this info into a table format” • Summarize data – “Summarize this dataset into key insights” • Create pivot tables – “How would you structure this as a Pivot Table?” • Automate tasks with VBA – “Write a VBA script to clean duplicate values” • Generate insights – “What are key takeaways from this dataset?” 4. ADVANCED – Unlock AI’s full potential Level up your ChatGPT usage with advanced techniques: • Train ChatGPT with specific prompts – “Use this reference doc to answer questions” • Automate sentiment analysis – “Analyze this text for tone and emotion” • Generate presentations – “Create a PowerPoint outline on AI trends” • Role-playing for problem-solving – “Act as a cybersecurity expert and advise on risks” • Code optimization – “Refactor this Python script for efficiency” Do you already use some of the tips provided? Did I miss something? 👉Claim your copy of the PDF for free now: https://lnkd.in/eBG3fmSW