Go Premium for a chance to win a PS4. Enter to Win

x

Office Suites-Other

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.

Share tech news, updates, or what's on your mind.

Sign up to Post

How a small business owner can reduce the cost of Google Apps
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small business owners can support popular inbound email addresses, such as info@MySmallCompany.com, sales@MySmallCompany.com, support@MySmallCompany.com, etc., without having to pay the Google Apps fee for those "users". If the volume of such emails in your small business is reasonable, then all of them can be directed to another Gmail account on your domain. In the best case scenario, a one-person company can do fine with just a single Google Account user, saving the small business owner hundreds of dollars per year.

1. Sign into your Google Admin Console


Visit this link:

https://admin.google.com/AdminHome

Choose your Google Account and sign in with your password.

Step1

2. Bring up the Apps Settings


Click Apps.

Step2

3. Bring up the Google Apps Settings


Click Google Apps.

Step3

4. Bring up the Gmail Settings


Click Gmail.

Step4

5. Bring up the Gmail User Settings


Click User settings.

Step5

6. Enter the catch-all address


Scroll down until you find a section in the Gmail User Settings called Routing.

Enter the address of a real Gmail user in your account. This is where messages sent to unknown user accounts will be delivered.

Step6

7. Save the change to the catch-all setting


Click SAVE.

Step7
That's it! I hope you just saved yourself some money in Google Apps fees. Better in your pocket than Google's!

If you find this video to be helpful, please click the thumbs-up icon below. Thank you for watching!
3
 
LVL 15

Expert Comment

by:Allen Falcon
The downside of this approach is that any email sent to the domain, legitimate or not will be routed to the one user, which greatly increases the chances of spam and phishing attacks getting through.  It also provides a "legitimate" return address for spammers that use spoofing.

Other options are:
Setup specific nicknames for the user, such as info@, sales@, service@, help@ etc. This can be done from the User admin section, as noted in the video, by adding alias addresses.
Use the Groups feature to setup a "distribution list" for info@, sales@, etc to forward to the user

The advantage of these options is that you can also configure to user so that he/she can reply using the nickname/group name.  So, the user can reply as info@, sales@ etc OR their personal address.
0
 
LVL 56

Author Comment

by:Joe Winograd, EE MVE 2015&2016
Hi Allen,
Yes, those are downsides of the approach, as stated in Google's caveat shown in Step #6 above and why I took the time to read the caveat in full during the video. Thanks very much for providing your thoughts on other options — those are interesting ideas! I've used aliases/nicknames and groups/distribution lists with other email providers/client software, but not with Gmail. I'll check it out — appreciate the tip! Regards, Joe
0
Free Tool: Path Explorer
LVL 11
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Fix Code to fill Missing data in Excel. Loop through spreadsheet in VBA.
This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values where it is blank can be run.

This lesson shows the manual process to fill blanks, and the VBA code to implement it.

This is Part 2 in a 3-part series to discuss error handling in Excel.

Part 3 of this series will add errors to the code and then show how to fix them.  Part 1 of this Experts Exchange series suggested basic error handling code.

01. Set up the error handler


   At the top of the code for your procedure, the error handler is set up using     On Error GoTo Proc_Err

02. Dimension Variables


   Declare variable names and data types that will be used in this procedure.

03. Initialize Variables


   Initialize the values of variables that will be used in this procedure.

04. Calculate Variables


   Calculate the values of variables that be determined.

05. Give User a Chance to Back Out


   Issue a message box to the user and allow them to stop the process.

06. Determine the Last Row


   Determine the last row on the worksheet that needs to be written to.

07. Loop through each Row of Data and Save or Write Value


   Loop through each row and either save the value that is there, or write the last value saved if a value is needed.

08. Continue Looping until Done


   Continue looping until all values in the specified column are written.

09. Exit Code


   After the procedure code, a line label for the exit code (Proc_Exit: ) is used to signify what happens at the end of the procedure. This is code to gracefully exit.

10. Error Handling Code

0
 
LVL 22
This is Part 2 in a 3-part series to discuss error handling in Excel.  It can be watched independently of the other videos.  This presentation focuses on automating a manual process to copy values from one row to the next in a column of an Excel spreadsheet.

You will learn how to loop through rows using VBA.  This example copies values to blank cells, but you could do something else in your loop.

Part 3 of this series will add errors to the code and then show how to fix them.  
http://www.experts-exchange.com/videos/1518/Excel-Error-Handling-Part-3-Run-and-Fix-Bugs.html

Part 1 of this series reviewed basic error handling code.
http://www.experts-exchange.com/videos/1478/Excel-Error-Handling-Part-1-Basic-Concepts.html

Attached is the download file for this lesson, and the next: Books_ErrorHandling_02_Code2_CopyDownBlanks.xlsm
Books_ErrorHandling_02_Code2_CopyDo.xlsm
0
Creating a Launch Slide in PowerPoint
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint.

1. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide

2. Create a blank slide in PowerPoint by going to File – new-then click create slide

3. Delete the text boxes (just easier to see what is going on)

4. You can insert the background anytime, but you may wish to do it at the beginning so you can see how everything looks together

5. The title comes next. You can put in word art here or use the smart object later.

6. Choose one of the smart objects to insert and use. In this case I am using one of the ones with pictures (although this does require you to make 2 links for every presentation.

7. Depending on how many speakers there will be, you may need to increase the number of boxes shown by pressing enter to get additional entries and/or by duplicating the object.

8. IMPORTANT: duplicate the object before making any further changes

9. Once you have the right number of objects, go back to the first object and enter the data you want there, including pictures

10. Note that these boxes will auto resize the text to get it to fit. So be aware that in some cases it may not be readable. You will either need to fix the box size or the title

11. To make the links and have them work correctly, you will need to ungroup each object twice. The first ungrouping, ungroups them so they are no longer smart objects, the second one separates them from each other. You may wish to regroup at least the picture with the text AFTER you have completed the hyperlinking.

12. To create a hyperlink, right click on an ungrouped object, and choose Hyperlink. To link to another presentation you should put the presentation in the same directory as the “launch” slide and then in the dialog box choose it as an “Existing file or Webpage” then click Okay.

13. To make this show a panel discussion I am going to delete the bottom three pictures and the bottom 2 objects in group three. I will then resize the object I didn’t delete so it aligns with the bottom of the other groups.

14. I have several objects that won’t be linked. I will change the coloring of those to make it more obvious. Also the top four going across will not actually give talks – they are session leaders and are there only to introduce the others. Therefore I will change the colors on those as well and separate them to make it more obvious.

15. Finally I will change the master slide (go to view – slide master) to include our logos. You could also include the background here.

16. I’ll move the objects a little to accommodate the logos

9
Building Probability Models in Excel Part 7: Modeling a Correlated Two-Fund Investment
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a Monte Carlo simulation using the simulated returns.

1. Modeling a Simple Investment: Type in the means and standard deviations of the return of both of the funds, along with the correlation coefficient

2. Select B7:C7 and type =CORAND($B$5), then press Command+Shift+Enter

3. Copy down to row 16

4. Label the returns of fund 1 and fund 2

5. Enter =EXP(NORMINV(B7,$B$2,$B$3)) into cell E7 and copy down to E16

6. Enter =EXP(NORMINV(C7,$C$2,$C$3)) into cell F7 and copy down to F16

7. Label the $1 investment into fund 1 and fund 2

8. Enter =H6*E7 into cell H7 and =I6*F7 into cell I7 then copy both down to row 16

9. Enter =H16 into cell B25 and =I16 into cell C25

10. Select A25:C524 then click ToolsSimToolsSimulation Table


0
 

Expert Comment

by:Richard Shaw
In the SIM table (A25: A524) -- what is the meaning and use of the column A data?
0
Building Probability Models in Excel Part 6: Investment Modeling Using a Log-Normal Distritribution
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculate the 5% Value at Risk of the investment from the results.

1. Modeling a Simple Investment: Type in the mean and standard deviation of possible returns

2. Label column A “Return” in cell A5

3. Enter =EXP(NORMINV(RAND(),$B$2,$B$3) into cell A6 and copy down to cell A15

4. Enter 1 into cell B5 to represent $1 invested

5. Enter =B5*A6 into cell B6 and copy down to cell B15

6. Enter =B15 into cell B20

7. Select A20:B519

8. Click Tools > SimTools > Simulation Table

9. Enter 1000 into cell B17 and label “Initial”

10. Enter =$B$17*B21 into cell C21 and copy down to cell C519

11. Enter =PERCENTILE(B20:B519,0.05) into cell B18 and label 5% VaR

0
Building Probability Models in Excel Part 5: Modeling an Investment Using Discrete Random Variables
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over 500 iterations.

1. Modeling a Simple Investment: Type in the amount invested, the possible returns, and the corresponding probabilities

2. Label column A and B “Return” and “Wealth,” respectively in A11 and B10

3. Enter =DISCRINV(RAND(),$B$2:$B$7,$A$2:$A$7) into cell A12 and copy down to cell A21

4. Enter =D2 into cell B11

5. Enter =B11*A12 into cell B12 and copy down to cell B21

6. Create a Monte Carlo Simulation: Enter =B21 into cell B23

7. Enter =B21 into cell B23

8. Click Tools > SimTools > Simulation Table

0
Building Probability Models in Excel Part 4: Discrete Random Variables
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilities and outcomes with the =STDEVPR command.

1. Discrete Random Variables: Type in the set of outcomes and corresponding probabilities in cells A2:B6

2. Enter =SUM(B2:B6) into cell B7

3. Enter =DISCRINV(RAND(),A2:A6,B2:B6) into cell B9 and label “Profit”

4. Enter =B9 into cell B14

5. Select cells A14:B213

6. Click Tools > SimTools > Simulation Table

7. Enter =AVERAGE(B14:B213) into cell B11 and label “Mean”

8. Enter =STDEV(B14:B213) into cell B12 and label “StDev”

9. Enter =STDEVPR(A2:A6,B2:B6) into cell C12

0
Building Probability Models in Excel Part 3: Monte Carlo Simulations and Conditional Probability
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo simulation.

1. Download and Install SIMTOOLS: Search Roger Myerson on Google, and click on the first link

2. Follow the links to find the SIMTOOLS download and download it

3. Go to Excel add-ins, click Select and find the file

4. Check the square to the left of SIMTOOLS.XLAM

5. Click Select to install

6. Use SIMTOOLS to generate a Monte Carlo Simulation: Open the spreadsheet from the last tutorial that simulates 30 sales calls

7. Enter =IF(C2=E2,1,0) into cell B33 and enter =C4 into cell C33

8. Enter target number of sales =12 into cell C26

9. Select A33:C232

10. Click Tools > SimTools > Simulation Table

11. Calculate the Conditional Probability: Enter =IF(C34=$C$26,B34,”..”) into D34 and copy down to D232

12. Enter =SUM(D34:D232) into Cell F28 and label “# High Skill”

13. Enter =COUNT(D34:D232) into Cell F29 and label “Total Target”

14. Enter =F28/F29 into Cell F31


1
Building Probability Models in Excel Part 2: Simulating Sales Calls
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels.

1. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill level”

2. Enter =IF(RAND()<$C$2,1,0) into cell A2 and copy to A31

3. Enter =SUM(A2:A31) into cell C4

4. Simulating Calls With Two Different Skill Levels: Enter =2/3 into cell E2 for high skill and =1/3 into cell F2 for low skill

5. Enter =IF(RAND()<0.5, E2, F2) into cell C2

0
 
LVL 1

Expert Comment

by:ankitha reddy
nice one.. thanks for the video
0
Working with Templates
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
0
[Webinar] Cloud and Mobile-First Strategy
LVL 11
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Using Word Count
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
1
Using Mail Merge to Create Envelopes and Labels
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses.

1. Navigate to the “Start Mail Merge” button in the Mailings tab

2. Follow the step-by-step process until asked to find the address document

3. Locate the file and begin creating envelopes/labels

0
Creating Footnotes
This video shows the viewer how to set up and create Footnotes in their document.

1. Click on the References tab

2. Select "Insert Footnote"

3. Type in desired text

0
Creating an MLA Formatted Paper with Citations  and a Bibliography
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
2
Adding Watermarks to Your Documents
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
0
Working with Text
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
0
Printing Handouts in PowerPoint
This video teaches viewers how to create handouts from their slides and helps them decide how many slides to include per handout.
0
Applying Transitions
This video teaches viewers how to add transitions to their Slideshows and how to set up timing for the transitions.
0

Office Suites-Other

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.