- Видео 44
- Просмотров 2 206 069
WinOffice
Добавлен 23 май 2014
Microsoft Office and Microsoft Windows tutorials.
If you would like a MS Ofiice feature demonstrated let me know.
If you would like a MS Ofiice feature demonstrated let me know.
Change Google Fit's TimeStamp to a readable Date format in Excel
Change Google Fit's TimeStamp to a readable Date format|| Change the time stamp of your Google fit data to a readable and understandable date and time format
You may be using Google fit to keep track of your weight and other fitness data. Google fit allows you to export your data, so you can analyze them in Excel.
But if you downloaded your Google fit data, you noticed that the date is in Unix timestamp format, which is not exactly very useful for a human.
If you already tried to Google it and none of the solutions worked that’s because the timestamp Google fit uses is in nanoseconds and not milliseconds.
Here’s the formula you can use to convert Google Fit’s Unix timestamp to a readable da...
You may be using Google fit to keep track of your weight and other fitness data. Google fit allows you to export your data, so you can analyze them in Excel.
But if you downloaded your Google fit data, you noticed that the date is in Unix timestamp format, which is not exactly very useful for a human.
If you already tried to Google it and none of the solutions worked that’s because the timestamp Google fit uses is in nanoseconds and not milliseconds.
Here’s the formula you can use to convert Google Fit’s Unix timestamp to a readable da...
Просмотров: 358
Видео
Add Captions to every table in a Word document using a few lines of VBA | Auto-numbering Word tables
Просмотров 419Год назад
Add Captions to every table in a Word document using a few lines of VBA|| Use VBA to automatically insert captions to every table in Word. Let’s see how we can save time and effort and add a caption to every table in a document at once, without having to go through each table and use the ribbon every time, by using less than half a dozen lines of VBA. First we define an integer variable that wi...
Automatically insert captions to every chart or Image in a Word document in seconds - Detailed guide
Просмотров 4,1 тыс.Год назад
Automatically insert captions to every chart or Image in a Word document in seconds using some VBA - Detailed guide You probably already know how to insert a caption to a chart or an image in a Word document. From the References tab, you click on Insert Caption and you can select the label that you would like to use. If you only have a couple of charts, it is not a problem, and with a few click...
Search in every PDF file in a folder||Search in multiple PDF files
Просмотров 5 тыс.Год назад
Search in every PDF file in a folder||Search in multiple PDF files Searching in a PDF file is one of the most useful features of a PDF reader, but being able to search in every PDF file in a folder can be even more useful. I will show you how you can search in every PDF file in a folder using the free Adobe Acrobat PDF reader. Chances are it is already installed on your PC, but even if it isn’t...
Sort your bibliography in Word in seconds easily
Просмотров 1,8 тыс.Год назад
Sort your bibliography alphabetically in Word in seconds and easily || Sort alphabetically the reference list in a Word Document In a document such as a thesis, or any other document that includes references, the reference list or bibliography at the end of the document, usually needs to be in alphabetical order. If you have a few sources, this is a rather simple process. A reference manager ca...
How to create a graph with two vertical axes in Excel
Просмотров 1,1 тыс.Год назад
Using a graph with two vertical axes can be quite useful when you would like to visualize two variables that use a different scale. A common example is temperature and precipitation, but it can be used with any two variables. First, select the data that you would like to visualize. Go to the Insert tab. Click on your preferred graph, I will go for a line graph here, and then click on more line ...
Create a Document Index in Word
Просмотров 14 тыс.2 года назад
Create a Document Index in Word || Create an index in Microsoft Word A document index provides an overview of the key concepts in a document and allows interested readers to easily find the relevant passages in the text. First of all, you need to identify all the words or phrases you would like to include in the document index and mark them accordingly. Select the work or phrase to include in t...
Convert your chart's axis to percentages the quick and easy way
Просмотров 39 тыс.2 года назад
Convert your chart's axis to percentages the quick and easy way || Here's how you can convert your chart's axis to percentages in Excel, without having to convert you data to percentages first. Like and Subscribe! Thank you! In this video i show you how you can convert your chart's axis to percentages, without having to convert your data to percentages first. Perhaps you downloaded data from th...
Convert numbers to percentages in Excel the quick and easy way
Просмотров 26 тыс.2 года назад
Convert numbers to percentages in Excel the quick and easy way || Convert your data in Excel to percentages without having to convert them to a number between 0 and 1 first Like and Subscribe! In this video, i show you how you can convert numbers, integers and decimals, to percentages without converting them to a number between 0 and 1 first. In order to be able to convert your numbers to perce...
Create your personal bookmarks in PDF files || Manage and format custom bookmarks in PDF
Просмотров 3833 года назад
How to create your own personal bookmarks in PDF files and manage and format your custom personal bookmarks in PDF files. Like and subscribe! Bookmarks in PDF files are a great way to organize your study and be able to find interesting passages and points of reference in PDF files, allowing you to become more productive and efficient. Download the free Foxit PDF reader and from the menu on the ...
Insert a Date Picker change the date to the full date format and modify the color, font, font size
Просмотров 7 тыс.4 года назад
Insert a Date Picker, change the date to the full date format and modify the color of the Date Picker and the font, font size and font color of the Date Picker's contents || In this video you can see how you can insert a Date Picker Content Control and change the date to the full date format, that includes the day of the week and the date, and modify the Date Picker's color and the font, the fo...
Modify, adjust and rename Word's Paragraph and Headings Styles (font, color, line spacing)
Просмотров 8 тыс.4 года назад
Modify, adjust and rename your Paragraph and Headings Styles (font, color, line spacing) in Word|| Here's how you can modify, adjust and rename the different Paragraph and Headings Styles in Word to make formatting your documents easier. By default, Microsoft is using Normal, Heading 1, Heading 2, etc. Text Styles to allow you to apply formatting to your document in a quick and concise way. But...
Mail merge with only select recipients - Mail merge filtering in Word
Просмотров 18 тыс.4 года назад
Mail merge with only select recipients - Mail merge filtering in Word In this video i show you all you need to know about mail merge with select recipients, allowing you to filter your mail merge recipients' list without having to filter or modify the list in your excel file. So, let's say you have an excel file that includes a list, that you would like to proceed with mail merge only with thos...
Remove any personal information and comments before sharing a Word document with others
Просмотров 15 тыс.4 года назад
In this video i go over how you can remove your personal information as well as any comments you have submitted before sharing a Word document with others. Perhaps you would like to share a Word document with other people online or in any other setting, but you wouldn't like to share your personal information with them. Here's how you can remove your personal information, such as your personal ...
How to insert a check box in Word 2010 and change the symbol to a check mark
Просмотров 63 тыс.5 лет назад
How to insert a check box in Word 2010 and change the checked symbol to a check mark In this video i go over how you can insert a check box in Word 2010 and change the checked symbol to the familiar check mark. First of all you need to make sure the Developer tab is visible, so from the File menu, go to Options and then Customize Ribbon and ensure that the Developer tab is checked. Now, the Dev...
How to load data in Excel 2010 from a CSV or text file
Просмотров 3,5 тыс.6 лет назад
How to load data in Excel 2010 from a CSV or text file
Conditional logic (if then else) using rules in mail merge in Word 2010
Просмотров 9 тыс.6 лет назад
Conditional logic (if then else) using rules in mail merge in Word 2010
Change the page orientation and size of a single paqe in a Word document [Word 2010, 2016]
Просмотров 320 тыс.7 лет назад
Change the page orientation and size of a single paqe in a Word document [Word 2010, 2016]
Insert and update an excel workbook into a word document
Просмотров 11 тыс.7 лет назад
Insert and update an excel workbook into a word document
Sort by more than one column in excel [excel 2010, excel 2013, excel 2016]
Просмотров 3187 лет назад
Sort by more than one column in excel [excel 2010, excel 2013, excel 2016]
Create a navigation pane in Word 2010 [Word 2013, Word 2016]
Просмотров 48 тыс.7 лет назад
Create a navigation pane in Word 2010 [Word 2013, Word 2016]
Easily move paragraphs and entire sections around in Word 2010 using the Outline view
Просмотров 14 тыс.8 лет назад
Easily move paragraphs and entire sections around in Word 2010 using the Outline view
How to add a custom watermark to your word document [Word 2010, Word 2007]
Просмотров 6 тыс.8 лет назад
How to add a custom watermark to your word document [Word 2010, Word 2007]
Change word & sentense case in word 2010
Просмотров 1,9 тыс.8 лет назад
Change word & sentense case in word 2010
Use Mail Merge in Word 2010 to create documents automatically using Excel data
Просмотров 111 тыс.8 лет назад
Use Mail Merge in Word 2010 to create documents automatically using Excel data
Paste Special in Excel: Quickly add, subtract, multiply, divide to/from a cell series in-place
Просмотров 17 тыс.8 лет назад
Paste Special in Excel: Quickly add, subtract, multiply, divide to/from a cell series in-place
Drop-down lists in Word: Insert, modify, use a format to style contents
Просмотров 313 тыс.8 лет назад
Drop-down lists in Word: Insert, modify, use a format to style contents
Multiple columns with different column length in Word 2010
Просмотров 56 тыс.8 лет назад
Multiple columns with different column length in Word 2010
Prevent others from editing your document in Word
Просмотров 44 тыс.8 лет назад
Prevent others from editing your document in Word
Create Internal and External Links in a Word Document
Просмотров 131 тыс.8 лет назад
Create Internal and External Links in a Word Document
Your accent is not a problem - I just want you to know that. However, the volume is low, your microphone is bad, and you're mumbling. Move away from the microphone if you can't figure out how to stop it popping every time you spit into it (a bit of foam between you and the microphone would do the job). AND FOR THE LOVE OF SANITY, SPEAK UP!! I gave up hoping you'd get to the point, also. Maybe put together a script or have a real think about what you're going to say before hitting that record button? Seriously, it was like listening to someone mumble in their sleep.
sound alive,FOOL!!!
Hi there, great video! Is there a way to have the macro scan a range of pages rather than the whole document?
Hi, and thanks! You can scan only a range of pages if you create a section in that range and then run the macro, properly adjusted of course. Afterwards you can remove the section, if you'd like. Let me know if you would like to tell you how. I haven't tested it, to be honest, but i don't see a reason why it should not work. Maybe you can do it for a range of pages without creating a section of course, but I will have to look into it. Good luck!
@@winoffice I'm not the most familiar with MS Visual Basic unfortunately. Absolutely no rush, let me know if you find something that works and I will Google around on my end.
@@geoffreyquipse6061 Ok, i will look into it and let you know.
Thanks ! issue solved
You are welcome! Glad it helped.
Thank You very much, what about autoCaption for Tables
You are welcome. For tables check my other video about tables specifically, here: studio.ruclips.net/user/videoAKCsw4HFKmc/edit
I was able to caption so many charts at once in my research document, Thank You
That's great! You are welcome!
Its not responding is it format code really 0/%?
Try 0\% if the forward slash doesn't work .
thank you so much!
You're welcome, Phil! Glad my video was useful.
I have created a drop-down list and a dependent drop-down list. However each selection has a long sentence entry and in a table. I need it to word wrap vertically. It keeps spreading out horizontally and messing up the table.
Maybe try adjusting the table properties. I don't know if and how you can wrap text in a drop-down list.
Thank you.🙏
Welcome!
Thank you very much
You are welcome!
Is there a way to hide or remove the percentage symbol at the end but keep the values the same ?
When you type the custom formula just omit the % symbol at the end.
Thank you
You're welcome!
Thank you so much 🙌
You're welcome! 😊
Didn't work! Dislike...
Thank you very much
You are welcome!
I have one issue. I have hundred images captioned manually. But later I came to know that we can auto caption images. I regret myself for learning things too late. So the problem is I am not able to insert table of figures because I added captions manually. Is there any way to insert table of figures even if I gave captions manually? All images have different captions and it will be even tiring and time consuming to convert manual captions into auto captions.
If you had used a caption, even if added manually, of course you would be able to add a table of figures. That's the usual way, i just provided a way to automate it. But, if you just added text above your images, and not an actual caption, you can't insert a table of figures automatically. I'll have to see if code can actually use the text in the paragraph above an image and use it as the caption text. It could take some time, though. I'm no VBA expert, i just share tips and some code from my work.
Thanks buddy
You are welcome!
Thanks, but I have problems if my second column is longer than one page, I just cant separate them
Hi. Obviously if your text extends to the next page, the layout changes. I'm not even sure what you are trying to do, to be honest.
Can you do the same to sort references using a numerical referencing system, in order of first time cited in a/the word document (i.e. 1 aaa 2 bbbb), can you provide a VBA code to do that? Thanks
Hi. You can sort your reference list numerically, if you have already numbered your references, for example [1]bla bla bla [2] bla bla bla etc. The code sorting the references in order of appearance in the text would be too complicated, if at all possible.
And how does it work the other way around? It can't be reset
Why it can't be reset? Change the format to number and you go back to numbers without percentages.
Thank you
You're welcome!
Wow, it worked like a charm! Thanks for this video! That saved me a ton of time!
Great to hear!
Thank you very much, finally I found solution 😍
Thankyou
You’re welcome! 😊
Well thank you sir
Welcome!
Thank you SO much for this. I'm working on a 150 page document with hundreds of images and the auto numbering on the captioning was driving me crazy! This is SO helpful!!! Quick question for you - If I add images to the document later, how can I "refresh" the image numbers so that they're updated? (When I tried to run the script again, it just added another set of captions, so I had two captions for every image) :( Also, is there a quick way to wipe out all captions that are already in the file?
❤
How to add captions for table? chart doesn't work.
See my other video specifically for tables and check the description for the code.
this has been my entire month and you solved it. Thank you
You are welcome! Wonderful to hear i was able to help!
Thank you so much, super helpful!
GOOD ONE
Thanks!
Thank you so much!
You're welcome!
Thanks for easy explanation ❤
Savedmy time
Great job!
Thank you! Cheers!
Thank you!!
You're welcome!
Is it possible to add captions on specific positions? For example only when the letter configuration "xyz" is visible?
It's possible to do many things, VBA is quite powerful. But, the more complex the task, the more complex the code. Not sure what you mean by when a certain letter configuration is visible.
How about doing the opposite? If I want the first column to go all the way down when there isnt enough text to fill the full page? Automatically my columns are the same length but i'd like the first one (left most) to go all the way down and the second one to end whenever the text ends. Is that doable?
That's the default Word behavior. First, it fills the leftmost column with your content, then it moves on to the next column. You must be doing something wrong, like inserting a page break when you shouldn't, if Word creates two columns of equal length, if your content is not long enough to fill both columns.
Not so fast, I don't want the comments to go away. I just want them to be anonymous. Is it possible?
No, you can't make the comments in a Word document anonymous. You can mark them as resolved or delete them, all of them or individual comments.
What is for mobiles android
can you copy/paste or export the results, rather than open up each instance of pdf file?
Is it possible to have percentage values above 100%. I need to reflect growth of more than 100% and the graph does not allow that
I haven't noticed a similar issue. Values over 100% are displayed as they should in my spreadsheet.
Thanks for your post, do you know the command line if I want to centrally align the figure name?
Hi. After you assign the label in your VBA code add the following code: Selection.Range.ParagraphFormat.Alignment = wdAlignParagraphCenter
@@winoffice it worked thankyou. Just there is a "full stop" at the end of the Figure label which I am trying to get rid off. For example, Figure 1-21. <--
I added the period in the code after the figure number, because this is how i usually format my figure labels. Notice the line: Title:=". ", _ note the period between the quotation marks. Remove the period and just leave the quotation marks and, voila, the period is gone from your labels. Good luck.
wow thankyou so much@@winoffice
You are welcome @sumayya9131 . Glad i could help!
Lifesaver. Thanks very much.
You're welcome! Glad it helped!
Thank you for good clear explanation
You are welcome! Glad it was helpful!
Hey thank you ❤️
You are welcome!
Thank you for this one. It has been very helpful.
You're very welcome! Glad it was helpful!
Thank you very much 🥰
Thank you 😊
You're welcome 😊
Thank you for this solution, however, I want my numbers converted from 100% - example 11 equals 100% and 10 equals 90% etc. How can I show this? My data is only changing to 11% or 10% etc