Another little tip is, instead of dragging the columns to change their widths, you can place your mouse right on the column separator and double-click. It will automatically change width to show all the data in the column.
I have been working with Excel for sometime - ( I thought I was quite good at it) in your beginners videos I learned quite a few tips. Thank you Garry.
Disclaimer: I’ve retired for almost 7 years as an Office Administrator. I forgot lots more than I realized, but when my husband and I wanted to keep track of food prices this video helped me create an Excel sheet on my Mac and have it on my iPhone to check when I was in the grocery store. I’m pleased with myself that I created an Excel spreadsheet but this video helped a lot. Ty.
I’ve been making some simple spreadsheets for years, but have learned a few great things from this tutorial. Thanks for your everyday and practical tips!
Thank you ever so much for this tutorial. I have forgotten every little thing I learned in school regarding Excel, and now I need this for work, so thank you!!
Absolutely brilliant! This kind of thing is so important yet very rare to find. Thanks. Watch all your videos and save most in a RUclips folder. Learn lots new every day.
A grueling experience if you've ever worked with Numbers, but still a great tutorial. I wish I had you as a teacher when I started out way back when 👨🏻🏫
NOT for true beginners, I am 56 and just learning how to use a computer and Microsoft. I did learn some things but way to advanced to keep up. I worked on it for about 2 hours, following (and backing up and pausing many times) before I gave up at absolutes. Great for people with more experience
Heyy Garry I'm from India I always show you videos. And I like the way you explain in deeply. Sinc last 1year I use MacBook Air . And I'm facing Mac "other storage" problem. I request you to please make a separate video on this .
Hi Gary. Thank you for so many great videos throughout the year. I wanted to ask about using a hard drive for Time Machine with my MacBook. I have tried using an external disk drive but it’s cumbersome since it’s not always connected to the MacBook. What would you suggest in order to have Time Machine doing back ups all the time.
One other tip that became a habit for me because of losing information: I always save my file periodically. You don't want to spend all that time on a file and there's a system issue or you lose your internet connection (believe me, for those of us that work at home, this happens more than I like!). I typically save it right after typing a title and then save periodically throughout working on it.
Good advice! I assumed that auto-save was enabled by default as with almost any other Mac app, but this doesn't seem to be the case if your Excel file is stored locally (i.e. NOT on OneDrive or SharePoint)😕
This is helpful, but is there any chance you could do a tutorial on how to use live preview on this version. I need to use it and I cannot find it anywhere.
Looking for some help. Attempting to create a small stopwatch seconds counter {Counting up, not down.) inside an existing spreadsheet. Three buttons: Start - Stop - Reset. I've added the "Developer" tab in the menu bar, but I'm at a dead end. ~ Thanks ~
You are trying to do that in Excel? I haven't explored any features of Excel that will let you do something like that. Why use Excel to do it? It doesn't seem like the right app. Get a stopwatch app instead. Or use the one on your phone.
Hello Gary, I hope you are doing well. In many cases, when I try to open Excel Documents that I created in Windows, I get an error message telling me that the file will only open in read only because it contains things that are not supported in this Mac version. It refers to Active X. Whatever that is. I use Office 365 to which I subscribe to. Any suggestions because I can’t figure out what ActiveX content is in this regular math Excel document. Just so you know, the file does open without error messages when I use my iPad Pro M1.
Help: At minute 8:49 my cost is not showing up automatically. If I click and drag from the top, it works that way. Any reason why it would not load as shown here? Thanks Gary.
This should be an tutorial series. Well done, as always!
Another little tip is, instead of dragging the columns to change their widths, you can place your mouse right on the column separator and double-click. It will automatically change width to show all the data in the column.
Thanks for this additional tip…
I have been working with Excel for sometime - ( I thought I was quite good at it) in your beginners videos I learned quite a few tips. Thank you Garry.
I've taken many classes over the years and I'm still so terrible using Excel, but this was actually helpful. THANK YOU!
Disclaimer: I’ve retired for almost 7 years as an Office Administrator. I forgot lots more than I realized, but when my husband and I wanted to keep track of food prices this video helped me create an Excel sheet on my Mac and have it on my iPhone to check when I was in the grocery store. I’m pleased with myself that I created an Excel spreadsheet but this video helped a lot. Ty.
I’ve been making some simple spreadsheets for years, but have learned a few great things from this tutorial. Thanks for your everyday and practical tips!
Thank you ever so much for this tutorial. I have forgotten every little thing I learned in school regarding Excel, and now I need this for work, so thank you!!
Absolutely brilliant! This kind of thing is so important yet very rare to find. Thanks. Watch all your videos and save most in a RUclips folder. Learn lots new every day.
Great! Please do more on Excel, especially PRINTING a sheet. Thanks, Thanks, Thanks so much!!!
Not me applying the lessons and feeling SMART!
Thank you so much! this video is so helpful!
Thank you so very much!! My goal is to get organized and with your tutorial you helped me a lot .Blessings Of Love and Light
I love all your videos. They are super useful and interesting to watch. Thank you so much for taking the time to make them.
A grueling experience if you've ever worked with Numbers, but still a great tutorial. I wish I had you as a teacher when I started out way back when 👨🏻🏫
NOT for true beginners, I am 56 and just learning how to use a computer and Microsoft. I did learn some things but way to advanced to keep up. I worked on it for about 2 hours, following (and backing up and pausing many times) before I gave up at absolutes. Great for people with more experience
A very informative video tutorial today. Oh my I have so much to learn. Thanks as always for the visuals! Thank you, Gary! 👍👏🏻❤️
Thanks bunches
Thank you sir. Great video
I love your videos Garry !
Good review. Thanks!
Great video! Thanks!
Heyy Garry I'm from India I always show you videos. And I like the way you explain in deeply.
Sinc last 1year I use MacBook Air .
And I'm facing Mac "other storage" problem.
I request you to please make a separate video on this .
See macmost.com/forum/how-do-i-delete-files-in-the-other-folder.html
Hi Gary. Thank you for so many great videos throughout the year. I wanted to ask about using a hard drive for Time Machine with my MacBook. I have tried using an external disk drive but it’s cumbersome since it’s not always connected to the MacBook. What would you suggest in order to have Time Machine doing back ups all the time.
Hi Gary,
Great video as always, however when you added the MISC category to the table it did not go into the chart?
One other tip that became a habit for me because of losing information: I always save my file periodically. You don't want to spend all that time on a file and there's a system issue or you lose your internet connection (believe me, for those of us that work at home, this happens more than I like!). I typically save it right after typing a title and then save periodically throughout working on it.
Good advice! I assumed that auto-save was enabled by default as with almost any other Mac app, but this doesn't seem to be the case if your Excel file is stored locally (i.e. NOT on OneDrive or SharePoint)😕
How do you do the end of last months date in an excel header?
lengendary
Is there any chance spell check working on Mac on excel ?
title : Microsoft Excel For Absolute Beginners
me : learn Microsoft excel with IT teacher at school
Gary, is the Mac version lacking any functionality from the windows version? As always, great job...
There are a few differences. You can Google to see what they are. I don't use Excel for Windows so I'm not the right person to ask.
@@macmost Keyboard shortcuts are different, NO PIVOT TABLES and VBA stuff.... Makes me a little disappointed
This is helpful, but is there any chance you could do a tutorial on how to use live preview on this version. I need to use it and I cannot find it anywhere.
Probably not. This is the only video I have on Excel. Mostly I cover Numbers.
Looking for some help. Attempting to create a small stopwatch seconds
counter {Counting up, not down.) inside an existing spreadsheet. Three buttons: Start - Stop - Reset. I've added the "Developer" tab in the menu bar, but I'm at a dead end. ~ Thanks ~
You are trying to do that in Excel? I haven't explored any features of Excel that will let you do something like that. Why use Excel to do it? It doesn't seem like the right app. Get a stopwatch app instead. Or use the one on your phone.
Shortcuts for excel is mac differs from windows can u do a video
Hello Gary, I hope you are doing well. In many cases, when I try to open Excel Documents that I created in Windows, I get an error message telling me that the file will only open in read only because it contains things that are not supported in this Mac version. It refers to Active X. Whatever that is. I use Office 365 to which I subscribe to. Any suggestions because I can’t figure out what ActiveX content is in this regular math Excel document. Just so you know, the file does open without error messages when I use my iPad Pro M1.
Help: At minute 8:49 my cost is not showing up automatically. If I click and drag from the top, it works that way. Any reason why it would not load as shown here? Thanks Gary.
Sorry, not sure why it isn't working for you.
Can you do the google mind map on the Mac?
I didn't know that Google had a Mind Map app of some sort. A search didn't turn it up. Where is it?
Are there any plans for masking a video with Outlook as well?
No, I have no plans to do that, sorry.
@@macmost Thanks for your reply og keep the good videos coming 🙏
Do you have videos about extract information from xml? On Mac is it possible?
What type of files? What type of information? What created the files? What do you want to do with the information and why?
What version of Excel were you using? I have excel 365 for Mac, and it does not look like yours.
At the start of the video I mention it is version 16.55.
How do I make a copy of the whole workbook?
Do you mean the file? Just duplicate it in the Finder.
Thank you so much!
As much as I like excel for Mac, it's a stripped down version.
👍👍👍👍👍🙏🙏🙏🙏🙏🙏🙏
not free :(
No, it isn't. If you want free use Numbers, or Google Sheets.
Noooo, Gary it’s Microsoft! Rather stay at your ground.
Yeah, but a lot of people use Microsoft Office on a Mac. Seeing how well this does on my channel...