![Neil Malek](/img/default-banner.jpg)
- 194
- 2 696 895
Neil Malek
Приєднався 6 сер 2006
Pivot Tables? Better public speaking? Adobe Photoshop? SharePoint? Building websites? This channel is devoted to videos that will teach you how to do... just about everything. Be AMAZING at what you do.
Showing only Millions with Custom Number Formatting | Everyday Office 080
When communicating with numbers, precision often gets in the way of the message being understandable. With number formatting, we can chop off irrelevant digits, and just present a number like $34M. In this video tutorial, Neil Malek of Knack Training shows how to customize the number formatting for a cell to display the numbers like that.
Music: "Azure" by Danny O
djdanny.bandcamp.com
Music: "Azure" by Danny O
djdanny.bandcamp.com
Переглядів: 942
Відео
Creating Drop-Downs with Tables and Named Ranges | Everyday Office 079
Переглядів 1,1 тис.6 років тому
Making a Data Validation drop-down is very useful for guaranteeing the accuracy of your cells. Those drop-downs can be made dynamic (grow and shrink as the data changes) by a few different techniques, but most of them use volatile function - functions that constantly recalculate. That can significantly bog down larger spreadsheets, so the technique we're using today uses tables and named ranges...
Assigning Macros to the Quick Access Toolbar in Excel | Everyday Office 078
Переглядів 3,2 тис.6 років тому
When you create a macro, you can use the Macros button, or a custom keyboard shortcut to execute it. However, you can also place the macro on the Quick Access Toolbar, which gives a button to press, as well as a generic numbered keyboard shortcut. In this video tutorial, Neil Malek from Knack Training demonstrates how a macro for Center Across Selection can be placed on the Quick Access Toolbar...
Excel for Accountants - Automation with Macros Promo
Переглядів 6 тис.6 років тому
Excel for Accountants - Automation with Macros Promo
Recording Macros with Relative References in Microsoft Excel | Everyday Office 077
Переглядів 39 тис.6 років тому
Macros are scripts in the Office products that automate a multi-step process for you. In this video tutorial, we record a reference that selects cells by 'relative references' - meaning that their exact location doesn't matter, only the position relative to where you started. Neil Malek from Knack Training uses keyboard shortcuts to execute a macro that automatically highlights cells. Music: "A...
Recording Macros with Absolute References in Microsoft Excel | Everyday Office 076
Переглядів 3,1 тис.6 років тому
Automating your Excel functions is done with macros. Before learning to program, you can record the actions within Excel to create a simple macro. In this video, Neil Malek from Knack Training records a macro with absolute references, and assigns the macro to the Quick Access Toolbar. Music: "Azure" by Danny O djdanny.bandcamp.com
Creating Conditional Data Labels in Excel Charts | Everyday Office 075
Переглядів 14 тис.6 років тому
We can make labels appear on our charts that don't have to do with the raw numbers that built the chart - and we can make them show up or not based on whatever conditions we want. In this tutorial, Neil Malek from Knack Training demonstrates how to use data labels, the IF and MAX functions to make labels appear in certain circumstances. Music: "Misty" by Birocratic birocreatic.lnk.to/allYL Knac...
Creating Dependent Drop Downs in Excel | Everyday Office 074
Переглядів 1,2 тис.6 років тому
Learn to build dependent drop-down menus in Excel with Data Validation, the OFFSET, MATCH, and COUNTIF functions. Music: "Beautiful" by Julian Avila soundcloud.com/julian_avila Knack Training is a software and professional development training company from Orlando, FL. Neil Malek, principal at Knack Training, records software tutorials everyday through the series Everyday Office. Knack Training...
Conditionally Formatted Chart in Excel | Everyday Office 073
Переглядів 8 тис.6 років тому
Highlighting the essential messages of your charts is important - color-coding your chart dynamically can be very valuable. In this video tutorial, Neil Malek from Knack Training demonstrates that with an additional calculation column, your chart can change color on the fly. Music: "Leftovers 2" by Birocratic birocreatic.lnk.to/allYL
Create a Water Gauge Chart in Excel | Everyday Office 072
Переглядів 6 тис.6 років тому
Building a stylized chart with a 'ripple' of water on top is a multi-step process, but once you learn how to do it, you can make a lot of different effects happen. In this video, Neil Malek from Knack Training shows how to turn a simple stacked bar chart into a round fluid gauge with a superimposed percentage of fullness. Music: "Perfect Circle" by Andrew Applepie soundcloud.com/andrewapplepie
Excel Conditional Formatting for Past Dates | Everyday Office 071
Переглядів 4,6 тис.6 років тому
In a big table of records (in this case, events), can we color-code our entries based on how far in the future or past the event was? With Conditional Formatting, the TODAY function, and the EDATE function, we can build calculations and color-coding for any date range we're interested in. Music: "Late Night" by Julian Avila soundcloud.com/julian_avila Knack Training is a software and profession...
Neil Malek Speaker Reel
Переглядів 2046 років тому
Neil Malek is founder and principal at Knack Training, a business software and professional development training company in Orlando, FL. He presents at live workshops and conference sessions across the country about Microsoft Office and SharePoint, Adobe Creative Cloud, G Suite for Business, Presentation Design and Delivery, and other business topics.
Creating Custom Infographics using Icons and Excel | Everyday Office 070
Переглядів 20 тис.7 років тому
Have you ever wanted to make one of those charts that uses people instead of columns? Or any other graphic options? Using icons in your charts is incredibly simple. In this Excel tutorial by Neil Malek, you'll see how to 'fill up' an icon, or use multiple icons as the chart itself. Music: "Sunshine" by Julian Avila soundcloud.com/julian_avila Knack Training is a software and professional develo...
Creating Custom Image Shapes and Placeholders in PowerPoint | Everyday Office 069
Переглядів 14 тис.7 років тому
Do you want slides with images that default to rounded-corner rectangles, circles, diamonds, strips, or any other shape? Using Crop to Shape, editing Image Placeholders, and working with Slide Layouts, we can make that happen in PowerPoint. In this video tutorial, Neil Malek from Knack Training demonstrates two techniques for custom image shapes. Music: "Betrayal" by Andrew Applepie soundcloud....
Editing with the Selection Pane in PowerPoint | Everyday Office 068
Переглядів 1,5 тис.7 років тому
Isn't it frustrating when you can't select something that's behind another element in PowerPoint? With the Selection Pane enabled, you can not only select and edit anything you want, but you can also name elements on your page for easy use later. Music: "Marble" and "Orange Forest" by Danny O djdannyo.bandcamp.com Knack Training is a software and professional development training company from O...
Cut to the Spike in Microsoft Word | Everyday Office 067
Переглядів 1,3 тис.7 років тому
Cut to the Spike in Microsoft Word | Everyday Office 067
Vlog 003 | IAAP Summit 2017 New Orleans
Переглядів 1307 років тому
Vlog 003 | IAAP Summit 2017 New Orleans
Using Find and Replace to Swap Formatting and Styles | Everyday Office 066
Переглядів 1,7 тис.7 років тому
Using Find and Replace to Swap Formatting and Styles | Everyday Office 066
Building Pivot Tables in Google Sheets
Переглядів 45 тис.7 років тому
Building Pivot Tables in Google Sheets
Flash Fill Correcting Dates in Excel | Everyday Office 064
Переглядів 1,4 тис.7 років тому
Flash Fill Correcting Dates in Excel | Everyday Office 064
Setting Default Fonts with Word Styles | Everyday Office 063
Переглядів 1 тис.7 років тому
Setting Default Fonts with Word Styles | Everyday Office 063
Resetting Word Page Numbers with Section Breaks | Everyday Office 062
Переглядів 221 тис.7 років тому
Resetting Word Page Numbers with Section Breaks | Everyday Office 062
Mapping Tables in Excel Tables to Create a Visio Org Chart | Everyday Office 061
Переглядів 22 тис.7 років тому
Mapping Tables in Excel Tables to Create a Visio Org Chart | Everyday Office 061
Creating a Dynamic Chart with Spin Buttons in Excel | Everyday Office 060
Переглядів 4,4 тис.7 років тому
Creating a Dynamic Chart with Spin Buttons in Excel | Everyday Office 060
Using Tables for Dynamic Chart Data | Everyday Office 059
Переглядів 2317 років тому
Using Tables for Dynamic Chart Data | Everyday Office 059
Using the GETPIVOTDATA Function to Build an Excel Dashboard | Everyday Office 058
Переглядів 15 тис.7 років тому
Using the GETPIVOTDATA Function to Build an Excel Dashboard | Everyday Office 058
Creating a Spin Button for a Dynamic Excel Chart | Everyday Office 057
Переглядів 6 тис.7 років тому
Creating a Spin Button for a Dynamic Excel Chart | Everyday Office 057
Adding Data to a Visio Diagram from Excel | Everyday Office 066
Переглядів 12 тис.7 років тому
Adding Data to a Visio Diagram from Excel | Everyday Office 066
Creating an Organization Chart from a Spreadsheet in Visio | Everyday Office 055
Переглядів 20 тис.7 років тому
Creating an Organization Chart from a Spreadsheet in Visio | Everyday Office 055
Great Video, this was puzzling me a lot as to why I couldn't sort data once it was another column further in the Pivot Table, but now I've managed to understand thanks to your explanation. Keep it up!
Thank you so much
That's all well and good... how do you stop it showing the total number of pages, rather than just the number of pages in the section - i.e. if you choose the number format "x of xx" how do you make the xx be ONLY the number of pages in the new section?
Thank you so much! Solved a very frustrating problem!
Misleading, it's not a treemap from pivot table, it's treemap from regular table pasted from pivot table which doesn't work when pivot table is refreshed.
Help! I am having such a hard time adding a space after a colon to over 2700 lines of text (it's a script). I don't understand why I can find double spaces after a period and replace them with a single space, but can't find a single space after a colon and make it a double space. it just won't work. Can you help?
In outlook 2007 you could create a menu dropdown and have a list of templates/macroes under each button? IS there anyway to do that in 2019 please?
you are great
Thank you so much! I have been spending some time trying to figure out an easier way to access my template!
Hi dear, Why is this not possible in the mac?
I love how the spreadsheet functions. But the end goal was not accomplished due to "Your organization data contains 12 entries that are not in the organization..." error. I see some others have experienced this.
thank you so much
shoutout to those of us still using non-CC photoshop instead of current photoshop's AI magic
u schooled me, thanx so much!
🎉
thankyou!!!
problem I am having is that, I am using a kindle template and I have pasted text in it, now I think, although its one document but it has several sections and page numbering makes no sense. i need an easy way to start numbering the whole document like it had no sections or complications.
Thank you! I was fighting with this for an hour
This is ingenious! This will greatly help me; especially since they keep removing features from templates with newer versions.
I have created a dynamic range that works. But how do you include blank cells. If a cell is blank, then the formula doesn’t work on the next row
but this will not be interactive with slicer
Very cool. Thank you. But if I don’t want the graphic, how do I just get that info to show up in the big blue box? Have tried everything in Visio studio 😅
Super helpful, thank you!
thank you very much!!!!
Sub GetFormData() ' Note: this code requires a reference to the Word object model Application.ScreenUpdating = False Dim wdApp As New Word.Application Dim wdDoc As Word.Document Dim FmFld As Word.FormField Dim strFolder As String, strFile As String Dim WkSht As Worksheet, i As Long, j As Long strFolder = GetFolder If strFolder = "" Then Exit Sub Set WkSht = ActiveSheet i = WkSht.Cells(WkSht.Rows.Count, 1).End(xlUp).Row ' on this line, notice that the file extension is .docm. ' if you are using .doc files or .docx files, make sure ' you change this line to match up with that. ' strFile = Dir(strFolder & "\*.docm", vbNormal) While strFile <> "" i = i + 1 Set wdDoc = wdApp.Documents.Open(Filename:=strFolder & "\" & strFile, _ AddToRecentFiles:=False, Visible:=False) With wdDoc j = 0 For Each FmFld In .FormFields j = j + 1 WkSht.Cells(i, j) = FmFld.Result Next FmFld End With wdDoc.Close SaveChanges:=False strFile = Dir() Wend wdApp.Quit Application.ScreenUpdating = True End Sub Function GetFolder() As String Dim oFolder As Object GetFolder = "" Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose the folder", 0) If (Not oFolder Is Nothing) Then GetFolder = oFolder.Items.Item.path Set oFolder = Nothing End Function 'If you decide to use Content Controls instead of Form Fields '(which are found under the Developer Ribbon), you'll need to find every instance 'of FmFld and replace it with CntCtrl. ' Dim CntCtrl As Word.ContentControl 'For Each FmFld In .FormFields changes to For Each CntCtrl In .ContentControls 'WkSht.Cells(i, j) = FmFld.Result changes to WkSht.Cells(i, j) = CntCtrl.Range.Text
Move whatever field you want to sort by to the first column, collapse all columns, then you can sort by any data field. Then expand to see the other fields.
Thanks a ton. I found an instant solution and learning that's been pending..
Whenever I try to add a section, it selects ALL of the slides after the slide where I inserted the section. And I don't see a way to edit the slides under a section.
Valuable information, thank you!
It is not working
❤❤❤❤❤
Great video but I am having hard time restarting page numbers on new section 2. The first page of section two is 1 but then the second page of section 2 still says one? I have deselected the link as previous. Can you help please?
Thank you for this. It was very helpful!
Thank you!!!
This is super helpful!
great
Great Explanation. Thank you!
1:41 is where they show you where and how to find the setting…
Tks ❤
great, thanks!
How do I get the instructional text back if the filled-in text is taken out?
You saved, thank so much
I hope you can get back to me. Everything worked fine but the page numbering on section 2 starts at 1 but there are no numbers on the following pages. Example 1...2...3...4..so on.
Excellent. This was so easily explained.
Right on! You saved me so much time!
Hi Neil, thanks for this - how can you use a treemap so that when data changes, the tree map also automatically updates?
Thanks its very help. Also could you explain how this category rules can be executed automatically to all in coming emails. Instead us press run now option each time.
This was Brilliant. Thank you for the massive help.
Genius! But I still can't understand why Microsoft makes it so painful to use templates. It baffles the mind. I remember using templates in Lotus Notes decades ago and it was so easy. It has only been lately when I've considered using templates in Outlook to discover actually copying from old emails is often easier.😂
thank you!