Online PC Support

OPS Technical Solutions : +1 833-522-1003

Welcome

How to Change Language on Google Chrome

Find out the easy steps shown in this video about How to Change Language on Google Chrome.

 

Go to the top right box, and select Settings.
– Go way down and click “advanced.”
–  Go  down and in the Languages section to Click
– Find the  languages are pre-loaded. To add a new language, click “Add,”  to select your language, click “OK.”

– After adding  your language,and to change the default language, drag it to the top to click “Display Google Chrome in this language.”
– To see the change you’ll need to close all Google Chrome windows and relaunch Chrome.
– After the Chrome is relaunched  it’ll show up in the language you set it to.
– To get it back to English, drag it  to the top and click on “Done.”

How to Take a Screenshot on Windows PC

Follow the steps shown in this video about how to screenshot on Windows PC.

  • Click on the screen you would like to capture
    – Press Ctrl + Print Scrn (Print Screen ) on Keyword.
    – Click the Start button
    – Click on All Programs – Accessories and Paint.
    – In the paint window, hold down the Ctrl key and then press and release the V key. The captured screenshot will appear within the paint window.
    – Save the image by clicking on the File drop-down menu located in the upper left-hand side of the toolbar and click on “Save As”.
    -In the Save as window, browse to your desired save location, enter a filename on the File Name: field, and click Save to save your screenshot.

How to fix windows 10 freezing Problems

Follow the steps shown in the video to learn about how to fix windows 10 freezing problems .

Follow the Steps : Sol 1: Update the drivers. To update the drivers with Driver Easy, click the Scan Now button Sol 2: You have to Clear computer’s temp files 1) Pess Windows key and R type temp and hit Enter. 2) Select all the files in the Temp folder and delete them. Sol 3: Run a memory check 1) Hold the Windows logo key on the keyboard and press R at the same time to invoke a Run command. Type mdsched.exe in the run box and hit Enter. 2) To check the problems immediately, click Restart now and check for problems. ( we suggest to check them immediately) 3) But in case you want to check later, click "Check for problems the next time I start my computer". Sol 4 : Run Disk Check 1) You need to close all open programs and files. 2) Click Start > File Explorer > This PC. 3) To locate the hard drive , right-click on it and choose Properties. 4) Just Go to the Tools tab and click Check. 5) If the hard disk drive is problem-free, you’ll see this: Windows will scan your system for corrupted files to fix them.

How to change Excel Cell Color using the ‘Conditional Formatting’

Follow the steps shown in this video and you will be able to change  Excel background color based on other cell value.

On The start Screen

  • Click on the Excel Sheet
  • Open the workbook where you want to make the changes
  • In current examples, we will set conditional formats
  • We have taken high value of 70 and low value of 55
  • Select the cells to be formatted .
  • In this example we are selecting the cells from B2 to B13
  • In the Styles group click Conditional formatting
  • Hover the mouse on Highlight Cell Rows and then to Greater Than to format the high values.
  • In the greater than window delete the value that appears and click on Cell F5 with the high values entered .
  • Click the drop down lists for formats and click Custom format
  • In the format cells window click the Fill tab and then click the color of your choice for the higher value .
  • Clock Ok . Click Ok again to close the greater than dialog box .
  • You can see the cells greater than value 70 are colored green .
  • Now to color the cells low t value you can apply second conditional formatting rule to the cell .
  • Select the cells to be formatted .
  • In this examples we are selecting the cells from B2-B13
  • In the Styles group click Conditional formatting
  • Hover the mouse on Highlight Cell Rows and then to less Than to format the low values.
  • In the less than window delete the value that appears and click on Cell F6 with the low values entered
  • Click the drop down lists for formats and click Custom format
  • In the format cells window click the Fill tab and then click the color of your choice for the higher value
  • Clock Ok . Click Ok again to close the less than dialog box
  • You can see the cells lesser than value 55 are colored red
  • In case you want to increase or decrease value you just need to change the value of high and low scorer. the changes would be done accordingly .

How to Make a FlowChart in Excel 2010

Looking for methods to create a flow chart in  Excel 2010, just follow the easy steps shown in this video.

Steps:

  • Open Excel
  • Click on insert tab  and go to the illustration group and then click Shapes .
  • Then select any shape on the flow chart section
  • Create the shape on the worksheet by clicking and dragging the mouse .
  • Insert more shapes from the insert group to complete the flow chart layout .
  • Select the desired shapes and align them by pressing the control key on your keyboard .
  • Now go to the arrange group , click align and choose the alignment option of your choice .
  • Repeat the same process to align the other shapes .
  • To add any text on the shape , select any shape and then right click on it and select add a text .
  • Type the required text in selected shape .
  • Repeat the process on other shapes .
  • Select the text box of any shape and then go to the home tab .
  • Choose thebasis text option from text box
  • Follow the same procedure for other text boxes of flow chart .
  • To add lines and arrows on the flow chart , go to the insert tab , click shapes and in the line section choose the preferred options .
  • You can create the shape by clicking and dragging the mouse.
  • Repeat the same process to create more lines in flow chart .
  • To edit the outline of the line or arrow select it and the shape styles group click shape out line.
  • Click on weight and then choose the line option , repeat the same option .
  • To change the style of the shapes of flow chart select the shape .
  • Open the shape style menu  and then choose the option of your choice .
  • Repeat the same process to change the style of other shapes in flowchart .
  • Done .

 

 

 

 

 

 

 

 

 

 

How to ROUNDUP a number in Excel

Do you want to round up a number, away from zero using ROUNDUP FUNCTION . Follow the steps shown in the video.

ROUNDUP function

Formula syntax and usage of the ROUNDUP function in Microsoft Excel.

Syntax : ROUNDUP(number, num_digits)

Number Any Real number required to rounded up.

Num_digits : Number of digits Required to round up.

If num_digits > 0, then number is rounded up to the specified decimal places.

If num_digits=0, then number is rounded up to the nearest integer.

If num_digits < 0, then number is rounded up to the left of the decimal point.

Call Now: +33 413 6803 97
Call Now: +33-413-6803-97
Call Now: +0800-183-3302