Advance Excel Online Training Classes Day-1 Basic Knowledge

About this tutorial: Video duration: 27:52 A K SOFTWARES AND SERVICES 43/1, 1ST FLOOR, MAIN EAST AZAD NAGAR, KRISHNA NAGAR, DELHI-110051 Mob – 9310221060, 8750221060, 9136018988, Phone – 011-22007066-22005052 E-mail- aksoftware01@gmail.com Wabsite – www.busyak.in

BUSY 3

About this tutorial: Video duration: 21:32 A K SOFTWARES AND SERVICES 43/1, 1ST FLOOR, MAIN EAST AZAD NAGAR, KRISHNA NAGAR, DELHI-110051 Mob – 9310221060, 8750221060, 9136018988, Phone – 011-22007066-22005052 E-mail- aksoftware01@gmail.com Wabsite – www.busyak.in

Turn on Column Filters in Excel | Microsoft 365 | Tip 45

About this tutorial: Video duration: 4:34 In this video we provide a quick tip that will be helpful to those of you actually using Microsoft tools to perform your day to day job. Please let us know if you have any “how to” questions and we’ll try to put together videos in support of that […]

Access 2016 Forms: Basic Introduction To Forms

About this tutorial: Video duration: 19:3 Access 2016 training video on the basic introduction to a Form, and includes how to sort and filter records in a form. All 131 of my Access 2016 training videos contain everything you need to help pass the Microsoft Access 2016 (77-730) exam and become certified! PATREON: Kirt Kershaw […]

How to Apply Conditional Formatting with Excel Slicers

About this tutorial: Video duration: 5:40 How to Apply Conditional Formatting with Excel Slicers For more Excel tips and tricks visit me at In this video I’ll show you how to apply conditional formatting with Excel slicers. Excel slicers are a handy and easy to use filtering system that Excel has built in but you […]

How To Count Colored Cells In Excel || Count Cells Based On Cell's Background Color || dptutorials

About this tutorial: Video duration: 3:27 How To Count Colored Cells In Excel || Count Cells Based On Cell’s Background Color || dptutorials Code: Function GetColorCount(CountRange As Range, CountColor As Range) Dim CountColorValue As Integer Dim TotalCount As Integer CountColorValue = CountColor.Interior.ColorIndex Set rCell = CountRange For Each rCell In CountRange If rCell.Interior.ColorIndex = CountColorValue […]

Excel Dynamic Arrays (How they will change EVERYTHING!)

About this tutorial: Video duration: 7:1 Excel Dynamic Array formulas are new to Excel Office 365 (Insider for now). After this, everything will change! Complex tasks will be done with simple Excel formulas. Everything you wished Excel could do, can now be done! ★★ Link to complete Excel Dynamic Arrays Course: If you have Office […]

Excel VBA Introduction Part 29.12 – Filtering Outlook Items using Restrict

About this tutorial: Video duration: 24:17 By Andrew Gould – This video explains how to filter the items in the Outlook inbox using the restrict method. You’ll learn about the basic syntax of Jet filters in Outlook and how to apply them to filter a list of emails using a variety of properties such as […]

advanced filter microsoft excel

About this tutorial: Video duration: 4:46 The advanced filter feature in Microsoft Excel helps the user to extract information from the worksheet data based on multiple criteria. You can filter the data in place or copy the filtered data to a specific area of the worksheet.

Excel Auto Filter: How to quickly filter tables + keyboard shortcut to get even faster

About this tutorial: Video duration: 6:41 Excel Auto Filter: How to quickly filter tables + keyboard shortcut to get even faster Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this […]

interactive charts in Excel – filtering with chart’s column selection

About this tutorial: Video duration: 9:13 Filtering few charts by chart’s column mouse selection. Ready to use template with download. The interaction means manipulating filter criteria of few chart by pointing certain column of one of the analysis chart. The example is the answer for the questions: – how to perform, create interactive chart, charts, […]

Grouping Data with Power Query

About this tutorial: Video duration: 18:24 Check out my Blog: Grouping data is a common thing most analyst do. If you use Pivot Tables you are most likely grouping data. You can also group data with the Power Query feature in the Excel Power BI tools, but why would you want to do that if […]

Microsoft Access 2010 Tutorial for Beginners – How to Use Access Part 7

About this tutorial: Video duration: 1:2:55 This is a Microsoft Access 2010 Database Basic Tutorial for beginners. In this basic course Access video tutorial, you’ll learn how to add and assign commands including macros to a Command Button, add a Subform to a Form, add PivotTables and PivotCharts to your Table, Query, Form, Subform and […]

Office 2019 ist da!

About this tutorial: Video duration: 7:15 Hallo liebe Zuschauer, In den Kommentaren werden keine Fragen bzgl. Reparaturen beantwortet. – Anfragen zu Reparaturen bitte hier: ———————————————————————————————————- Windows 10 @ ComputerService MTK: Downloads @ComputerService MTK: Fernwartung @ ComputerService MTK: Sicherheits-Tipps @ ComputerService…

Microsoft Access 2010 Tutorial for Beginners – How to Use Access Part 6

About this tutorial: Video duration: 1:20:50 This is a Microsoft Access 2010 Database Basic Tutorial for beginners. In this basic course Access video tutorial, you’ll learn how to extract unique values and unique records from your Query, use of Wildcards to help in less refined Query searches, Parameter Query that prompts the user for a […]

Excel: Filter einfügen und Daten sortieren – Tutorial [2016, 2013, Dropdown, deutsch]

About this tutorial: Video duration: 11:58 Mit Excel kann man große Datenbestände in Form von Tabellen filtern und sortieren um so gezielt bestimmte Daten extrahieren zu können. Gleichzeitig können auch bestimmte Formeln so eingesetzt werden, dass sie nur die jeweils gefilterten Daten berücksichtigt werden. All das und viel mehr lernst du in diesem Video. Viel […]

excel 2010 tutorial 12

About this tutorial: Video duration: 13:43 excel 2010 tutorial 12

Microsoft Access 2010 Forms: Filter and Sort Records

About this tutorial: Video duration: 2:59 Microsoft Access 2010 training video on how to filter and sort your Form’s records. All 142 of my Access 2010 training videos contain everything you need to help pass the Microsoft Access 2010 (77-885) exam and become certified! UDEMY: $9.99 on any of my videos. Use code YOUTUBE18. Visit […]

8. Microsoft Access 2016: Filtering SQL Queries With a WHERE Clause

About this tutorial: Video duration: 8:43 In this video on Microsoft Access 2016: Filtering SQL Queries With a WHERE Clause, Steve Bishop give you a tutorial on how to filter the records of your query to just those rows containing the values you want. After watching this lesson you will know how to limit the […]

Sort Data Horizontally in Excel

About this tutorial: Video duration: 1:48 Sorting in Excel: – Sort data range horizontally according to row in Excel. In other words you can say reordering columns using horizontal sort from left to right. This way you can arrange a data range largest to smallest or smallest to largest from left to right. ?For more […]