Home
Videos uploaded by user “Excel Ideas and Solutions”
creating drop down list in excel 2013
 
01:49
The video describes how to add simple lookup list in Microsoft Excel 2013. Free download is provoded on: www.excel.sos.pl/download/DropDownList.xlsx and www.excel.sos.pl/download/DropDownList.xls Tags: How to create drop down list in excel 2013, lookup list, dropdown list, dorp down, choose from list, MS Excel, point form the list, list of values
double click in excel - how to change cell's value by doubleclick
 
10:34
Excel macro that enables changing the cell's value on doubleclick event. Imporves usability. Free download: http://www.excel.sos.pl 11. - Excel 2013 xlsm file and 12. - Excel 97-2003 xls file from the list
Excel alerts reminders notifications - poup after Win startup - how to create
 
17:41
Message Box interactive notifications are displayed after openning excel file. Excel file can be opened on Windows startup. Alerts are created for all range of data depending on formulas for dates in cells as well as row 'status' row (active / finished). Please note (2017-07-23): New extensive version of the notifications for multiple file handling is available: https://youtu.be/VDZjHQLKrng Free download: http://www.excel.sos.pl 7. xlsm - Excel 2013 and 8. xls file - Excel 97-2003
Excel interactive notifications alerts windows popup for many multiple excel files
 
20:43
Message Box interactive notifications / alerts are displayed after openning single excel file which contains definition of other excel files with due dates to be investigated. Excel file can be opened on Windows startup. Solution enables multiple files / spreadsheets / workbooks definition. You do not have to modify analyzed excel files at all. Instead of it customizable setup is performed in single file. Alerts are created for all range of data depending on formulas for dates in cells as well as row 'status' row (ON / OFF). You can customize alert message per analysed spreadsheet. Free download: 1. Download example data file: www.excel.sos.pl/download/Book1.xls 2. Place it in: C:\Book1.xls on your disk. 3. Download solution file: http://www.excel.sos.pl/download/77_multifiles_one_alert_WITH_MSGBOX_PAGING_ONCHANGE.xls 4. Open it; during opening: - let 'Enable Editing', - let 'Enable Content' Msg box with entries from Book1.xls should be displayed. Check other solutions on: http://www.excel.sos.pl
how to create splash screen in excel
 
05:27
The guide - how to create splash screen in excel 2013 with the download on http://www.excel.sos.pl/download/splashscreen_demo.xlsm Tags: start screen, start up screen, welcome screen, splash screen in excel, excel splash screen, splashscreen, start screen, how to prepare, enable, display, start, make visible, enabling, praparing, displaying
How to create auto run macro in Excel - on open event
 
02:06
Excel macro that will run when the workbook is opened. Free download: http://www.excel.sos.pl 13. - Excel 2013 xlsm file and 14. - Excel 97-2003 xls file from the list
create survey in excel
 
10:58
With free download - how to create survey in excel Survey, questionnaire management in Excel (employee, purchase proposal or any other evaluation). Ready to use Excel solution with download to manage any survey: employee evaluation (HR), purchase proposal evaluation and any other. Download Excel 2013: http://www.excel.sos.pl/download/1.zip Download Excel 97-2003: http://www.excel.sos.pl/download/2.zip
How to build multi record INSERT and UPDATE SQL query with MS Excel
 
13:09
The video shows how to use Microsft Excel to prepare / build / construct SQL INSERT and UPDATE query / queries for multi / many records / rows of data. It can be especially useful for UPDATE clause queries because INSERT type has alternatives methods in provided SQL tools. It also demostartes the general usage of method to multi build queries with the usage of concatenate function. More examples on: http://www.excel.sos.pl Tags: MS SQL, My SQL, MS Excel, Oracle
free CRM in excel
 
25:19
Excel CRM free solution. Enables working with customer tasks in easy way. Stores customers contact data. You can plan tasks, manage tasks customer history, managing tasks status. I've focused on usablility (changing the stautus with double click, filtering for active task with due date equals or less than today, entering new cusotmer from task line, showing person, phone and email from task row). Please download and enjoy. Can be also treated as personal tasks manager of any kind. Free download: http://www.excel.sos.pl 9. - Excel 2013 xlsm file and 10. - Excel 97-2003 xls file
How to create lookup drop down list with multi - few cloumns in Excel
 
06:05
Excel macro that enables to choose value from lookup list with few columns to active cell. Drop down lookup list that includes few columns just in order to make the choice more acurate. Microsoft VBA macro enables mulit - 3 columns on drop-down list. You can free download: http://www.excel.sos.pl 15. - Excel 2013 xlsm file and 16. - Excel 97-2003 xls file
How to Enable Macros in Excel 2013 and 2010
 
00:30
Quick quide / tutorial how to enable / setup / turn on / start / initialise / macros / make working in Microsoft Excel 2013 and 2010. More videos with the downloads on my chanel and on hhtp://www.excel.sos.pl Tags: how to start VBA, how to run macro, enable macros excel, turn on macros in excel, marco excel, excel 2013, excel 2010, how to enable macros, tutorial
how to learn Microsoft Excel VBA -  self teaching method
 
03:17
The video contains simple example how to check how to perform actions using VBA coding in Microsoft Excel. It's a obvious but useful method of self teaching of VBA.
to do list in excel
 
07:18
To do task manager with elements of CRM. High usability. Free download: http://www.excel.sos.pl 9. - Excel 2013 xlsm file and 10. - Excel 97-2003 xls file from the list
Trailer - Excel Ideas and Solutions
 
00:52
Tutorials and FREE Download of Microsoft Excel Apps, including: Pop Up Reminders, Interactive Notifications, Alerts, CRM (Customer Relationship management), Task Manager, To Do-s, Hints, Interactive Dashboards and many other 'how to' tutorials. All solutions are ready for use after download. The tutorials include the code description. The VBA code includes notes.
how to find pairs for credit and debit in excel
 
17:36
Example macro finding exact pairs of values between entries from debit and credit sides. Download: http://www.excel.sos.pl
Task manager in Excel - free template
 
07:23
CRM task manager template. Includes usability features. Free download: http://www.excel.sos.pl 9. - Excel 2013 xlsm file and 10. - Excel 97-2003 xls file from the list
Splitting cell's value wihtout cutting off words - Excel VBA Macro
 
11:49
Microsoft Excel macro that enables splitting value into 2 parts (columns) of defined lenghts without cutting off the words in the middle. It's useful tool for data migration tasks. You can prepare easily the data from one format to new one. Using this solution You should prevent the data from cutinf off loses.The download below includes ready to use example with VBA macro. Download available from: http://www.excel.sos.pl 5. - Excel 2013 xlsm file and 6. - Excel 97-2003 - xls file
how to set the filter by macro in excel - define criteria conditions
 
06:34
Tutorial how to set the filter by macro in Excel. Example provides hard coded criteria and also parametrised criteria. Free download from: www.excel.sos.pl
windows startup with interactive excel notifications
 
01:05
Just presenting in use the result of the solution introduced in my another video: Excel alerts reminders notifications - poup after Win startup - how to create: http://youtu.be/yi6cmM3uta4 keywords: windows startup with interactive excel notifications Microsoft Excel alert alerts notification due date time task to-do to do windows startup
How to Enable Developer Tab in Excel 2013 and 2010
 
00:29
Quick quide how to show developer tab in excel 2013 and 2010. This is for the Microsoft Excel 2013 and also 2010. How to enable / make visible / turn on / add to ribbon developer tab. This is helpful for macros management. Tip, tutorial, giude, excel add developer tab, developer tab, Excel 2010 developer, excel 2013 developer tab, Excel 2013 developer, excel 2010 developer tab,
How to create mouseover in Excel - adding extended information as comment
 
08:21
Excel macro that provides extra linked information as comment on mousover. Free download: http://www.excel.sos.pl 9. - Excel 2013 xlsm file and 10. - Excel 97-2003 xls file from the list
Filtering with active cell's value - Excel Macro
 
15:46
Ready to use VBA Excel macro that enables filtering with ActiveCell's (selected cell's) value. Runs with different type of data. Contain turn on and turn off macros. Enjoy free download from: http://www.excel.sos.pl Position 3. - Excel 2013 xlsm Position 4. - Excel 97-2003 xls Video gives general description of macro structure. Code includes notes.
interactive charts in Excel - filtering with chart's column selection
 
09: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, data analysis in excel, vba - how to filter few charts, - how to make create charts interactive, - how to make create charts interaction in excel - creating interactiv chart charts in excel 2013 2010 2007 - filtering with chart's column selection how to filter charts in excel how to filter few charts in excel how to filter two charts in excel how to create dynamic chart in excel how to animate charts in excel how to make chart dynamic in excel how to create interactive dashboard in excel how to create dashboard in excel filtering few pivot charts with one filter filtering two pivot charts with one filter filtering few pivot tables with one filter filtering two pivot tables with one filter Tutorial pivottable pivot table chart pivotchart You can free download ready to use solution from: http://www.excel.sos.pl
contract agreement document management in Excel
 
11:24
Contract agreement document management solution in Excel. Enables attaching any files to excel rows, open them, and store additional information such as Due date, customer information in cells and manage the information (filter on Due date based criteria). Can also be treated as incoming / outcoming correspondence management. You can manage any list files. Free download from: http://www.excel.sos.pl 19. - Excel 2013 xlsm file and 20. - Excel 97-2003 xls file
interactive dashboard in excel
 
09:12
interactive dashboard in excel with the possibility of 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, data analysis in excel, vba - how to filter few charts, - how to make create charts interactive, - how to make create charts interaction in excel - creating interactiv chart charts in excel 2013 2010 2007 - filtering with chart's column selection how to filter charts in excel how to filter few charts in excel how to filter two charts in excel how to create dynamic chart in excel how to animate charts in excel how to make chart dynamic in excel how to create interactive dashboard in excel how to create dashboard in excel filtering few pivot charts with one filter filtering two pivot charts with one filter filtering few pivot tables with one filter filtering two pivot tables with one filter Tutorial pivottable pivot table chart pivotchart You can free download ready to use solution from: http://www.excel.sos.pl
how to map data in excel
 
11:50
The example show how to use Excel for semi automatic mapping. The solutions identifies one to many relationships. It is a simple example of semi automaitc master - detail solution. It can be used when building the tools for looking for appropriate substitutes or objects considered as equal. You can manually match the data using provided Microsoft VBA Excel macro. It's conditional filtering functionality obtained by horizontaly arranged view of spreadsheet. Free download is available at: http://www.excel.sos.pl keywords: how to map data in excel Microsoft Excel Software map data link match matching assign assignment migration master detail how to relate relationship linking details view master detail semi automatic find appropriate browse filter filtering
how to find pairs for credit and debit in excel -  macro explanation
 
08:06
Example macro finding exact pairs of values between entries from debit and credit sides. Download: http://www.excel.sos.pl
how to highlight data to be filled one by one in excel - simple wizard
 
08:25
Example of simple wizard in Excel which leads user in sequence which data should be filled in. Free download from: www.excel.sos.pl

Cleaning service bid cover letter
Example of a great cover letter for resume
How to write application to school principal for job
The best paper writing service
Civil service essay writing