Tag Archives: excel

Microsoft Excel, SQL & Internet Tips : How to Use the Pivot Table Wizard in Excel

Posted on by
Reply


Use the pivot table wizard in Excel and select what ranges should be included in a pivot table. Discover how to use the Microsoft Excel pivot table wizard with tips from a software developer in this free video on using Microsoft Excel. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Computers & Laptops : How to Make a Line Graph in Microsoft Excel

Posted on by
5


A line graph in Microsoft Excel is made by entering data into a spreadsheet, highlighting all of the data, clicking on the “Insert” tab and selecting “Charts” to find the line chart button. Create a line graph from a spreadsheet with IThelp from a software developer in this free video on computers. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

General Computer Tips : How to Create an Excel Formula

Posted on by
1


Creating an Excel formula in Microsoft Office is a great way to perform mathematical calculations based on data that’s already been entered or through other cells within the workbook. Navigate Excel and write a formula to sum up a complex range of data on a PC using tips from a software developer in this free video on general computer tips. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Microsoft Excel, SQL & Internet Tips : Entering Data Using SQL Management Studio

Posted on by
Reply


When using SQL Management Studio, data can be entered by opening a table and entering data into a text field. Use SQL Management Studio to enter data, and remember to save changes, with tips from a software developer in this free video on Microsoft SQL Management Studio. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Microsoft Excel, SQL & Internet Tips : Creating a Table in MySQL

Posted on by
5


When creating a table in MySQL, make the table before opening a parenthesis to put in the fields that exist in the table. Make a new table in SQL with tips from a software developer in this free video on using MySQL. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Microsoft Excel, SQL & Internet Tips : How to Use an HTML Editor

Posted on by
1


An HTML editor is different from a word processing program in that it is designed specifically to create HTML Web pages. Use an HTML editor, such as Kompozer, with tips from a software developer in this free video on using the Internet. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Microsoft Excel, SQL & Internet Tips : Using Microsoft SQL Credentials

Posted on by
2


When logging in to a structured query language (SQL) database, a person can sign in with their SQL credentials or with their Windows credentials. Use SQL server authentication with tips from a software developer in this free video on using Microsoft SQL. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Microsoft Excel, SQL & Internet Tips : How to Design a Web Site

Posted on by
3


Microsoft Word can be used to design a Web site by inserting pictures, inserting hyperlinks and manipulating text. Design a Web site that is personally customized with tips from a software developer in this free video on using the Internet. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Microsoft Excel, SQL & Internet Tips : How to Design a Web Site

Posted on by
3


Microsoft Word can be used to design a Web site by inserting pictures, inserting hyperlinks and manipulating text. Design a Web site that is personally customized with tips from a software developer in this free video on using the Internet. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown

Microsoft Excel, SQL & Internet Tips : How to Design a Web Site

Posted on by
3


Microsoft Word can be used to design a Web site by inserting pictures, inserting hyperlinks and manipulating text. Design a Web site that is personally customized with tips from a software developer in this free video on using the Internet. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown