by Laura | Jul 31, 2019 | Microsoft Excel Tips
You might find using a data entry form easier than entering information in a columnar format. Excel has an awesome feature called data entry forms. In order to be able to use data entry forms, make sure that your worksheet is set up with column headings. Excel uses...
by Laura | Jul 26, 2019 | Microsoft Excel Tips
The following table is a list of Alt-Key shortcuts that still work with current versions of Excel. File Menu Alt+F New Alt+F-N Open Alt+F-O Close Alt+F-C Save Alt+F-S Save As Alt+F-A Print Preview Alt+F-V Print Alt+F-P Send To Alt+F-D Edit Menu Alt+E Undo Alt+E-U Cut...
by Laura | Jul 24, 2019 | Microsoft Access, Microsoft Excel Tips
If you have data in Excel, you can bring that data into an Access table. For example, the following is a small database in Excel. You can link the Excel table into Access by clicking on the Excel icon in the Import & Link section of the External Data tab. When...
by Laura | Jul 8, 2019 | Microsoft Excel Tips
In Excel you have the option of entering data directly into a cell or by entering into the formula bar. It might be easier when initially entering straight data to enter it into the cell. But the formula bar makes it helpful when entering a formula (equation) or a...
by Laura | Jul 2, 2019 | Microsoft Excel Tips
If you have ranges of data that don’t fit on one range you can create, in effect, more than one graph type on the same graph. In the following example, there is a range of data in Column C indicating sales in one department and in Column D the percentage of sales from...
by Laura | Jul 2, 2019 | Microsoft Excel Tips
Depending on how your spreadsheet is set up you can do a few things. If your seconds are calculated from the time of day, you can convert the time to minutes and seconds. The cells in columns C and F are formatted with the general format. So therefore, you could...
