Category Archives: Productivity

Downloading Embedded images

To download multiple embedded images from an email in Outlook as separate JPG files, follow these steps: Open the email > Click on the File tab > Select Save As > Choose the location where you want to save the images. In the Save as type drop down menu, select Web page, HTML only. > Click on the Save button. The images will… Read More »

Open Database Connectivity

Open Database Connectivity (ODBC) is designed to expose database capabilities via SQL. It improves the analytics process by giving users real-time access to data from multiple sources. Data can be transformed, within applications such as Excel and PowerBI, into reports and dashboards. Excel macros and scripting languages like PowerShell can automate the creation and distribution of reports via… Read More »

Web Searching 101

Boolean search Utilizes special words or symbols to limit, widen, or define the scope of your search. These include: AND, OR, NOT, and NEAR, as well as the symbols + (add) – (subtract) ” ” (quote). Boolean Operator Symbol Explanation Example AND + All words must be present in the results football AND nfl OR Results can include any of the words… Read More »

Dialog box keyboard shortcuts

Press this key To do this F4 Display the items in the active list. Ctrl + Tab Move forward through tabs. Ctrl + Shift + Tab Move back through tabs. Ctrl + number (number 1–9) Move to nth tab. Tab Move forward through options. Shift + Tab Move back through options. Alt + underlined letter Perform the command… Read More »

Windows keyboard shortcuts

Taskbar keyboard shortcuts Press this key To do this Shift + click a taskbar button Open an app or quickly open another instance of an app. Ctrl + Shift + click a taskbar button Open an app as an administrator. Shift + right-click a taskbar button Show the window menu for the app. Shift + right-click a grouped… Read More »

Windows logo key keyboard shortcuts

Press this key To do this Windows logo key  Open or close Start. Windows logo key  + A Open Action center. Windows logo key  + B Set focus in the notification area. Windows logo key  + C Open Cortana in listening mode. Notes This shortcut is turned off by default. To turn it on, select Start  > Settings  > Cortana, and turn on… Read More »