Emelie Lindström - Productivity & Work Skills
Emelie Lindström - Productivity & Work Skills
  • 67
  • 662 572
Top 10 Excel Formulas & Functions You NEED To Know
Learn the top 10 Excel formulas & functions to avoid looking like a beginner in Excel through creating sleek spreadsheets, use effective advanced formulas and learning simple time saving tips and tricks that can save you hours when working in Microsoft Excel through this step-by-step tutorial.
S U B S C R I B E T O M Y N E W S L E T T E R
emelielindstroem.ck.page/newsletter
C H A P T E R S
00:00 Excel tip 1 - Sleek Excel sheets 1
01:42 Excel tip 2 - Sleek Excel sheets 2
03:12 Excel tip 3 - Sleek Excel sheets 3
04:15 Excel tip 4 - Sleek Excel sheets 4
05:21 Excel tip 5 - Sleek Excel sheets 5
05:41 Excel tip 6 - Simple time savers 1
06:35 Excel tip 7 - Simple time savers 2
07:36 Excel tip 8 - Simple time savers 3
08:22 What NOT to do
09:56 Excel file structure
10:44 Excel tip 9 - Advanced formula 1
11:58 Excel tip 10 - Advanced formula 2
14:07 Bonus tip!
Переглядів: 391

Відео

5 CV and Cover Letter Secrets Top Candidates Use
Переглядів 19714 днів тому
There is a reson why top candidates always get invited to interviews wherever they apply and it’s not only because of their achievements but because they have stellar CVs and cover letters. In this video you will learn the resume and cover letter secrets that top candidates have in common and use to get hired, whether it’s within management consulting, finance, strategy or what ever your dream ...
The Simplest Project Plan Ever (& How To Make It)
Переглядів 3023 місяці тому
Projects without a clear project plan fail. In fact, less than 70% of projects are successful. I will go through the simplest project plan ever, and even better, you can gain access to the project plan template for free! In this tutorial, I go through 6 simple steps for how to write a project plan that will make your project succeed and make you a better project manager. I go through risk asses...
How to talk to anyone and enjoy it (even as an introvert)
Переглядів 2933 місяці тому
Are social settings with new people draining and nerve-wracking? Imagine confidently gliding through gatherings, effortlessly networking with strangers and leaving a lasting impression, whether it is at a networking event, mingle, party or during a conference. Let's move from being the awkward introvert in the corner to speaking with anyone with confidence and ease, avoiding awkward small talk ...
Beginner’s Guide to Excel Pivot Tables (for Dummies)
Переглядів 7 тис.5 місяців тому
Discover why pivot tables are the ultimate game-changer in Excel. From novice to advanced, this tool empowers you to not only analyze but also visualize your data with precision and finesse. This is a beginner's guide to Microsoft Excel pivot tables (a 101 for dummies if you will), which will take you step by step through how to set up your first pivot table to extract data, insert slicers and ...
Create Amazing Powerpoint Presentations With the Pyramid Principle
Переглядів 5426 місяців тому
Design powerpoint presentations like a pro with the pyramid principle. Learn the secret method used by top management consultancy firms like McKinsey, Bain, BCG and others, to transform confusing Powerpoint presentations into captivating masterpieces through storytelling using the pyramid principle by Barbara Minto. Whether you're a seasoned presenter or a beginner, these Microsoft Powerpoint t...
Plan and Host Online Workshops Like a Pro [Step by Step Guide]
Переглядів 52810 місяців тому
Ready to take your workshops to the next level? Or are you unsure of where to start in planning for an online workshop? Here is how to do it! In this video I show you step-by step how you can plan and host an online workshop utilising Scrintal as the tool to create exercises. Check out Scrintal through the link below (Discount code EMELIE10 active) www.scrintal.com/?YT&PNS&A10293&d=EMELIE10 Scr...
Can Chat GPT Do Your Job For You?
Переглядів 701Рік тому
Are you tired of spending countless hours on mundane tasks at your job? Look no further! In this video, we will explore the true potential of Chat GPT, an advanced AI tool, and how it can help you save time and increase productivity in your daily work. Using Chat GPT's cutting-edge AI technology and natural language processing, you can streamline your workflow and optimize your work process. By...
DRASTICALLY Reduce Your Screen Time
Переглядів 805Рік тому
Are you tired of feeling constantly glued to your phone? Do you find yourself mindlessly scrolling social media for hours on end? It's time to take control in reducing screen time and improve your overall well-being. In this video, I will reveal the secrets to reducing your phone usage and taking back control of your life. From setting limits on certain apps to making your phone less appealing,...
Stop Sharing Screen! This is the Right Way to Share a Powerpoint Presentation in Microsoft Teams
Переглядів 10 тис.Рік тому
Are you struggling to learn which way to share PowerPoint presentations and other content in Microsoft Teams? Look no further! In this video, I will walk you through the correct way to share presentations in Microsoft Teams, making you look like a pro when sharing your next PowerPoint presentation. You'll learn all the tips and tricks you need to effectively share presentations with your collea...
You Need to IMPROVE Your Microsoft Teams Meetings
Переглядів 788Рік тому
Online meetings suck, there are technology issues, they run past the designated time and people keep talking simultaneously. But it doesn’t have to be that way, and you need to improve your Microsoft Teams meeting to keep your audience more engaged and have more effective online meetings. In order to improve your online meeting there are some things you need to think about when you host your Mi...
The Ultimate Guide to Falling Asleep Faster
Переглядів 350Рік тому
Sick of tossing and turning at night? Struggling to fall asleep can be frustrating and impact your overall health and well-being. In this video, I share proven ways of falling asleep faster and getting a good night's rest! If you have trouble sleeping and lie awake for long times every night, here are home concrete tips for how to fall asleep faster. I take you on a journey through the day for ...
Amazing Google Search Hacks You NEED To Learn
Переглядів 964Рік тому
Here are the best Google Search hacks you don't know about in 2023. Learning to use Google search to its fullest will help you in whatever type of research you are doing, whether it is a quick search for a question you want to be answered at the dinner table, deep research for a school or work project or a Google search hack that will make you look cool in front of your friends. These Google se...
Complete Beginner's Guide to Notion in Only 30 min
Переглядів 8842 роки тому
In this beginner's guide to Notion you will learn everything you need to know about how to use Notion. This Notion tutorial will teach you the basics of Notion as well as how to do aesthetic dashboards and databases using an example of a dashboard I use daily. The video is split into three different parts of how to use Notion as a beginner: the foundation, how to design a page and how to use da...
Microsoft OneNote tutorial for beginners
Переглядів 1,8 тис.2 роки тому
In this Microsoft OneNote tutorial for beginners, you will learn all the OneNote basics you need to get started with OneNote AND know why OneNote is superior to Microsoft Word. Here you will understand how to use OneNote in a step-by-step tutorial suitable for beginners. I go through all basics like tags, creating a page, sorting, making aesthetic pages, inserting file printouts and much more. ...
7 easy things to do this week to get organized
Переглядів 6602 роки тому
7 easy things to do this week to get organized
Daily planning: Plan your day effectively using the ALPEN method
Переглядів 8 тис.2 роки тому
Daily planning: Plan your day effectively using the ALPEN method
Inbox Zero - Get your email inbox under control! | Easy email management tips
Переглядів 3,6 тис.2 роки тому
Inbox Zero - Get your email inbox under control! | Easy email management tips
Stressed about work? - 6 ways to stop thinking about work in your free time
Переглядів 2,2 тис.2 роки тому
Stressed about work? - 6 ways to stop thinking about work in your free time
7 best tech pieces that will improve your life drastically (for real!)
Переглядів 6282 роки тому
7 best tech pieces that will improve your life drastically (for real!)
How to take notes in college | Easy note-taking methods for studying
Переглядів 1,5 тис.2 роки тому
How to take notes in college | Easy note-taking methods for studying
Outlook signature setup: Create an awesome email signature in minutes!
Переглядів 4,7 тис.2 роки тому
Outlook signature setup: Create an awesome email signature in minutes!
I never forgot a single task in 3 years - Here's how I did it! || Task management tips for work
Переглядів 15 тис.2 роки тому
I never forgot a single task in 3 years - Here's how I did it! || Task management tips for work
The Truth About Management Consulting
Переглядів 5022 роки тому
The Truth About Management Consulting
Understanding this will improve your productivity for life! | How to become more productive for real
Переглядів 9452 роки тому
Understanding this will improve your productivity for life! | How to become more productive for real
How to master hybrid meetings [Setup and best practices]
Переглядів 7 тис.2 роки тому
How to master hybrid meetings [Setup and best practices]
Are your files and folders a mess? Do this! | Digital file and folder organization tips
Переглядів 11 тис.2 роки тому
Are your files and folders a mess? Do this! | Digital file and folder organization tips
Feeling stuck in life? Start using a personal development plan!
Переглядів 6462 роки тому
Feeling stuck in life? Start using a personal development plan!
The BEST Microsoft Powerpoint tips and tricks for AMAZING slides (powerpoint hacks)
Переглядів 8002 роки тому
The BEST Microsoft Powerpoint tips and tricks for AMAZING slides (powerpoint hacks)
How to write meeting minutes LIKE A PRO [With meeting minutes example!]
Переглядів 456 тис.2 роки тому
How to write meeting minutes LIKE A PRO [With meeting minutes example!]

КОМЕНТАРІ

  • @Horseyqaqa
    @Horseyqaqa День тому

    Very helpful information! Great job!

  • @emelielindstroem
    @emelielindstroem 2 дні тому

    What was your biggest "aha" moment in Excel?

  • @m.rosser4345
    @m.rosser4345 2 дні тому

    Good Morning, I have come across your videos on my feed recently and have found them to be very informative and helpful. Thank you

    • @emelielindstroem
      @emelielindstroem 2 дні тому

      I am glad you like my videos! Thanks for letting me know 😊

  • @InereseimokumoLazarusseiyefa

    I love the idea

  • @angelosdeftereos6284
    @angelosdeftereos6284 7 днів тому

    A brilliant and easy to understand explanation. Thank you!

  • @AeroPR
    @AeroPR 8 днів тому

    Beautiful explanation! Thanks

  • @royalenono4752
    @royalenono4752 9 днів тому

    Thanks for this. I'm 14 years old, and I ran for student council and won as Secretary. Learning how to take minutes was crucial for my journey of being the Student council secretary, and because im responsible for the summary of the discussion.

  • @Horseyqaqa
    @Horseyqaqa 15 днів тому

    Really useful information, as always!

  • @emelielindstroem
    @emelielindstroem 16 днів тому

    What are your best CV tips and tricks?

  • @manuelagutierrezangel.3812
    @manuelagutierrezangel.3812 22 дні тому

    Very helpful

  • @brumbala08
    @brumbala08 26 днів тому

    The "Quick Access" tip is genius! How did I never realize I could control what showed up there? Thank you!

  • @MsEmo1995
    @MsEmo1995 29 днів тому

    Thank you so much for this , this is my second day at work and I don’t know what is Meeting minutes , this gave me an idea about it . Thank you very much

  • @dawilliams1887
    @dawilliams1887 Місяць тому

    I go to the calendar invite in Outlook and use the Send to One note feature. It launches avnew one note page, along with the meeting details (meeting name, date, time, invitees, agenda or info from the body of the meeying, etc). It saves lots of time.

  • @biancagarling9598
    @biancagarling9598 Місяць тому

    The waiting for list is exactly what I need!

  • @noorvibes8226
    @noorvibes8226 Місяць тому

    Like 🎉

  • @janelle3786
    @janelle3786 Місяць тому

    this is super helpful! Thank you so much!❤

  • @oludeleomotolanitumise5237
    @oludeleomotolanitumise5237 Місяць тому

    Very clear and useful. Thank you so much ❤

  • @anthonyuchenna7322
    @anthonyuchenna7322 Місяць тому

    Thanks for your concise explanation

  • @HolisticJuniper
    @HolisticJuniper Місяць тому

    Thank you so much! Every word was helpful. I was just recommended this system by a friend and wanted to get started ASAP. I have a lot going on and you've helped me shortcut the process. I really appreciate all your dedication and work to make this video.

  • @davidr4523
    @davidr4523 Місяць тому

    Great video. Without question, GTD is one of the top business books of all time. Here are 10 additional points to incorporate into your GTD plan: 1. Time block on a digital calendar all of your activities. Send alerts to your iPhone or smart watch to remind you. 2. Your digital note taking app such as OneNote will be your best friend. Capture all of your notes, information, activities, digital images in this app. Your emails and computer hard drive are not easily searchable. 3. At the end of each day, review your day and set up your schedule for tomorrow. You can still do your weekly review, but you need to schedule your top activities the night before. 4. Scan and upload into the cloud all your paper documents. All your digital documents should also be stored in the cloud. 5. Complete your most important activities in the morning. 6. If you are not making progress on an activity, then hire an expert or a delegate to an employee. Having people in your life definitely helps to get things done. Sometimes you are not motivated enough to complete task on your own. 7. Use the pomodoro method to focus on an activity. Highly effective. 8. Engage in an activity for just 10 minutes. Once you start, which is the hardest part, then momentum will kick in. 9. Listen to UA-cam videos on your project topic as much as possible. By doing so you will become more comfortable on the task. 10. Limit your activities to just 3 per day. During more will overwhelm you. Look at your calendar as much as possible during the day.

  • @lungilesithebe654
    @lungilesithebe654 Місяць тому

    This seems great, I wonder if it ever gets to become a rabbit hole of spending more time organizing than executing🤷🏾‍♂️

    • @emelielindstroem
      @emelielindstroem Місяць тому

      It definitely can! Organising is 100% my favourite way of procrastinating 😂

  • @mbalizondi869
    @mbalizondi869 Місяць тому

    Thanks so much for this. I used to write notes in my previous job more than a decade ago. I have been tasked by my current employer to help write minutes in a meeting we are going to have soon and i literally couldnt remember but im thankful to this page i will know exactly what to do.

  • @JennaHasm
    @JennaHasm 2 місяці тому

    Have you tried wearing eye covers and earplugs?

    • @emelielindstroem
      @emelielindstroem 2 місяці тому

      Yeah I have and I usually do that when I am travelling but I find that earplugs don't really help when someone is snoring next to you

  • @eggxecution
    @eggxecution 2 місяці тому

    good insight

  • @johncrever3415
    @johncrever3415 2 місяці тому

    I love it! The best tutorial out there. Thank you for helping me get up and started without getting sidetracked. 🙏🏽

    • @emelielindstroem
      @emelielindstroem 2 місяці тому

      Thank you for the kind words, that makes me really happy!

  • @mariamisselmou5189
    @mariamisselmou5189 2 місяці тому

    @nicole I like your videos. Do you have a online classes?

    • @emelielindstroem
      @emelielindstroem 2 місяці тому

      No I actually don't but it's something that I am thinking about creating! Are there any specific topics that you would be interested in diving deeper into?

  • @user-kq5gh5yj5t
    @user-kq5gh5yj5t 2 місяці тому

    I really like this video when I watched it some time ago. I ran across it again right now, and I enjoyed watching it again. I have read a lot about GTD, and this video seems to me to be a very concise and accurate presentation. The only thing I would change is to slow down the pacing of the presentation, since it gives a lot of very important information to be absorbed.

    • @emelielindstroem
      @emelielindstroem 2 місяці тому

      Wow that's amazing that you have watched it twice! Thank you so much! 😊 it is really difficult to get the pacing at the right level because I could easily talk about this topic for 45, but it could probably be condensed to a high-level 5 min summary as well

    • @user-kq5gh5yj5t
      @user-kq5gh5yj5t 2 місяці тому

      @@emelielindstroem Your video is what was amazing because you gave a clear presentation that made sense. There is a lot to the GTD method, so doing that clearly in any amount of time is not easy. Thanks again for such a thoughtful presentation!

  • @mlife952
    @mlife952 2 місяці тому

    So useful and articulate. 🎉

  • @J-lf9ig
    @J-lf9ig 3 місяці тому

    Hello Emelie, would you be open to a zoom call with me to show me how to complete my minutes for my corporation? I’ll pay you $100 usd to help me with this. Please, I would be so grateful if you said yes!!

  • @Horseyqaqa
    @Horseyqaqa 3 місяці тому

    Thank you so much for the template, that's going to come in handy!

  • @emelielindstroem
    @emelielindstroem 3 місяці тому

    When I created this video, I thought it wouldn’t make sense if I didn’t share the template that I created to help you all save some time, so I have worked to set up a solution to share files with you. So now i can proudly say that you can access the project plan template here: emelielindstroem.ck.page/project-plan. You will need to input an email but you can unsubscribe at any time 😊 Download, adapt and use it however you’d like!

  • @elinorlindstrom460
    @elinorlindstrom460 3 місяці тому

    Yes! It doesn't matter how polished and "perfect" the plan is if you keep changing the scope by adding new things

  • @emelielindstroem
    @emelielindstroem 3 місяці тому

    I have finally managed to get a link where you can download the meeting minutes template. You can find it here: emelielindstroem.ck.page/meeting-minutes-template . You will need to enter an email but you can unsubscribe at any time. I hope you enjoy it! 😃✏

    • @sharonadwoanyarko1695
      @sharonadwoanyarko1695 29 днів тому

      @emelielindstroem thank you for this video. Can you share a document of a minute you took with these steps?

  • @carstonfurdoople
    @carstonfurdoople 3 місяці тому

    This was a fantastic explanation, very clear and easy to understand!

    • @emelielindstroem
      @emelielindstroem 3 місяці тому

      Thank you so much! I'm glad you enjoyed it :D

  • @GuilhermeCardozo-hz8xp
    @GuilhermeCardozo-hz8xp 3 місяці тому

    This is very handy! Thanks for sharing!

  • @laceandpaperflowers
    @laceandpaperflowers 3 місяці тому

    Are you doing that on One Note app??

    • @emelielindstroem
      @emelielindstroem 3 місяці тому

      Yes! There are several different versions of the OneNote app so it could be that yours don't look exactly the same as mine :)

  • @Jay-du1ms
    @Jay-du1ms 3 місяці тому

    ❤❤❤

  • @denooos
    @denooos 3 місяці тому

    Many thanks

  • @abdulaziizmohammed4085
    @abdulaziizmohammed4085 3 місяці тому

    How i can get your meeting minutes template

    • @emelielindstroem
      @emelielindstroem 3 місяці тому

      You can find it here :D emelielindstroem.ck.page/meeting-minutes-template

  • @neilclay5835
    @neilclay5835 3 місяці тому

    Very useful, certainly one of the better summaries of GTD. Thanks

  • @tonyf2346
    @tonyf2346 3 місяці тому

    Excellent tutorial, thank you

    • @emelielindstroem
      @emelielindstroem 3 місяці тому

      I'm glad you liked it! Thanks for telling me!

  • @Horseyqaqa
    @Horseyqaqa 4 місяці тому

    These are some really useful tips!

  • @poettoad
    @poettoad 4 місяці тому

    As an introvert myself, I find talking to new people very fun and interesting, but the issue is always taking the first step to do so 😅 If someone approaches me first I'm more than happy to talk!

    • @emelielindstroem
      @emelielindstroem 4 місяці тому

      I fully agree haha. It is always easier when someone else approaches!

  • @koop_ss
    @koop_ss 4 місяці тому

    There's something that confuses me. If today's sunday and I add to the inbox that I got a meeting on thursday, but by weekly review is on friday, doesn't that mean that the meeting won't be in my calendar until friday which might make me miss it?

    • @emelielindstroem
      @emelielindstroem 3 місяці тому

      I understand where you are coming from, but in the same way as you wouldn't wait with adding an urgent task into the system, the same goes with calendar events. When using the system, you don't have to wait for the weekly review to complete steps 1-3 (capture, clarify and organize). When you have used GTD for a while it goes very quickly to do step 1-3 immediately and add the "task" into the right place. The weekly review is more so that you don't leave things unattended for for too long. Hope that makes sense :)

  • @zainabalghazaly628
    @zainabalghazaly628 4 місяці тому

    Pemantau minutes of meeting.. Really really inspired

  • @VirtualBusinessTasks
    @VirtualBusinessTasks 4 місяці тому

    How do I see the sheet of data it is pulling from? One of my clients had someone do a pt and it is pulling from a previous spreadsheet of data. They duplicated the spreadsheet so it is pulling from the previous year. How do I get it to pull from the current worksheet in this workbook?

    • @emelielindstroem
      @emelielindstroem 3 місяці тому

      It is the same principle as what I show starting at 09:29. On the "PivotTable Analyze" tab you can click on "Change Data Source" and there you can see where it is pulling the data from and also change the data source :)

  • @dr11_99
    @dr11_99 4 місяці тому

    Really Helpful Thankyou

  • @tamaralynn2069
    @tamaralynn2069 4 місяці тому

    Oh my goodness... I have avoided pivot tables for so long because I couldn't understand them at all. I'm so glad I decided to try again to learn and found your tutorial! This is a game changer for me. Thank you so much... you have magical teaching powers! 🪄

    • @emelielindstroem
      @emelielindstroem 3 місяці тому

      That makes me so happy to hear! I'm glad you liked the video, I strive to make all my videos super helpful and easy to follow :D

  • @TheCerealHobbyist
    @TheCerealHobbyist 4 місяці тому

    Great explanation. I get so anxious when my GTD is out of order. Starting a new job soon and getting back in the swing! What apps are people using these days? I have an iPhone and use both Mac and Windows, so something web based with an iOS app would be good. The new company uses Google Business if that makes a difference.

    • @emelielindstroem
      @emelielindstroem 3 місяці тому

      I am using TickTick for my personal tasks. It has a small cost each year but I think it's worth it because I think it works exactly the way I want it to. I have been using Notion for my work tasks because it is so incredibly customizable (however, a bit difficult to set up from scratch). But I also recently changed jobs so now Notion is not available to me anymore so I am in the same situation. I have been trying out Microsoft planner now because I like seeing tasks in a Kanban style, but I would also appreciate any tips :)

  • @DulfiqarIsmail
    @DulfiqarIsmail 4 місяці тому

    Wonderful.. OneNote got recording options?