What Is Advanced Excel 2010

Subscribe now and save, give a gift subscription or get help with an existing subscription. Advanced Excel 2010 Course Objective: – Our Advanced Excel 2010 Training Course is an interactive hands-on program. We train participants step by step, from basic to advanced level functions of Excel.

1. Advanced Excel 2010 Tutorial
2. Advanced Excel Training

In this article, you will learn how to get color of the cell using VBA code.
We need to follow the below steps to launch VB editor.
Click on Developer tab

From Code group, select Visual Basic
Click on Insert, and then Module
This will create a new module.

Dear Twitpic Community - thank you for all the wonderful photos you have taken over the years. We have now placed Twitpic in an archived state. Advanced users of Excel are very familiar with various features of Pivot tables & can use them really well. Some of the advanced pivot table features are – relationships, multi-tale pivots, grouping, slicers, measures (Power Pivot) & summary by different type of metrics. Link tables with relationships and weave magic with multi-table pivots. Search the world's information, including webpages, images, videos and more. Google has many special features to help you find exactly what you're looking for.

Enter the following code in the Module

Advanced Excel 2010 Tutorial

Function ColorIndex(CellColor As Range)

ColorIndex = CellColor.Interior.ColorIndex

End Function

To get the color of the below cells, refer below snapshot
In cell B2, enter the formula as =ColorIndex(A2) & then copy down the formula in below cells.
Let us take one more example:
To know how many times a particular color has repeated (count by color), refer below snapshot
We can use COUNTIF function along with newly created UDFColorIndex function.

COUNTIF: Counts the number of cells within a range that meets the condition.

Syntax: =COUNTIF(range,criteria)

range: It refers to the range of selected cells from which the criteria will check the number of items that have found.

criteria: The criteria define which cells to count.
In cell D2, the formula would be =COUNTIF($B$2:$B$9,ColorIndex(D2))
By copying the formula in cell E2, we will get the count by colors.
This is how we can get the color of any cell.

Last updated on October 7th, 2020

The 'Copy and Paste commands not working' problem can happen for various reasons on a Windows computer. For example, if the computer becomes infected by a virus, then the clipboard stops working (CTRL+C or CTRL+V are not working and 'Paste' command is greyed out). In other cases, the 'copy-paste not working' behavior may occur after a Windows update, corrupted system files, improper shortcut key settings in Word application, etc..

This guide contains detailed steps to troubleshoot copy/paste problems in Windows, Word, Excel or other programs.

How to fix: Ctrl+C, Ctrl+V, Ctrl+X Not Working in Windows or Office applications.

Step 1. Scan your computer for viruses and malware.

Important: Before following the steps below, make sure that your computer is 100% clean from harmful programs like rootkits, malware or viruses. To accomplish this task, follow the steps in this Quick Malware Scan and Removal Guide, and then try to use copy/paste again. If the problem persists, then continue to the next step.

Step 2. Check Copy & Paste shortcuts keys in various applications.

To check the copy/paste shortcuts in Word:

1. From Word's main menu (File), go to Options.

2. Choose Customize Ribbon on the left.

3. Then click at Customize button next to 'Keyboard shortcuts'.

At Customize Keyboard options, choose:

• At Categories > Home Tab
• At Commands > EditCopy
• Now under Current keys you should have these two (2) shortcut keys by default:
• Ctrl+C
• Ctrl+Insert
• If you don't have the above two key combinations, click at the 'Press new shortcut key' box & then press the corresponding combination for the missing shortcut key (e.g. 'Ctrl+C') and press Enter.Perform the same operation for the EditCut * & EditPaste commands.*** In 'EditCut' command you should have these two (2) shortcut keys by default:
• Ctrl+X
• Shift+Del

** In 'EditPaste' command you should have these two (2) shortcut keys by default:

• Ctrl+V
• Shift+Insert

4. When done, check if the 'Copy Paste Not Working' problem is resolved. If not, continue to the next step.

Step 3. Run Word (or Excel) without Plugins.

Some times an extra plugin can cause serious problems in Word application. To ensure that you don't have a plugin that causes trouble in your Word functionality, run Word without any plugin. To do that:

1. Close Word

2. Press Window + R keys to open the RUN command box and type the following command: *

• winword /safe
• * Note: To start Excel in Safe Mode (without plugins) type: 'excel /safe'– Now Microsoft Word application should open in Safe Mode without any plugins loaded.

4. From Word's main menu (File), go to Options.

5. Choose Add-ins on the left.

6. At the right pane in Manage menu, choose the COM Add-ins and click Go…

7. Now uncheck to disable all additional plugins & click OK.

8. Close and re-open Word in normal operation.

9. Check if the Copy-Cut-Paste commands are working normally.

10. If the commands are working properly now, then go again at Add-ins and enable the extra plugins one by one to find out which one causes the problem.

Step 4. Uninstall Windows Update KB3057839

Sometimes Windows Security Updates can cause problems in your computer's operation. One of these updates is the KB3057839 security update that is reported to cause problems with Copy-Paste functions. So, follow the instructions below to uninstall the KB3057839 security update (if installed) and get back the copy-paste functionality in your computer.

1. Press Windows + R keys to load the Run dialog box.

2. Type the following command to open Windows Update and press Enter.

• wuapp.exe

3. Click at Installed Updates link on the left pane.4. Select the KB3057839Update and click Uninstall.

5. After the uninstall, check if the copy/paste commands are working. If yes, then prevent KB3057839 from being installed in the future. To do this:

6. At Windows Update panel, click Check for Updates.

7. Choose the Important Updates link.

Advanced Excel Training

8. Right-click at Update KB3057839 and select Hide update.

8. Press OK.

Step 5. Try to disable the security software.

Some security applications likeWebroot SecureAnywhere can cause the copy/paste not working problem. To ensure that, a simple solution is to temporary disable your security application and then see if the copy/paste commands are working normally.

In the case that you have Webroot SecureAnywhere installed on your computer, then open the program's interface and disable the 'Identity Protection' for the programs where the copy-paste commands don't work. To do that:

1. Double-click the 'Webroot' shortcut icon on your desktop:

2. Click the Identity & Privacy tab.

2. Click the Identity & Privacy tab.

3. Click Identity Shield on the left, then click View/Edit Protected Applications.

4. At Protected Applications panel, set to DENY the application(s) that you have problems while pasting.

Other tips to fix the copy-paste not working issue.

1. Uninstall any recent version of IE.

2. If you have the Skype Call to Click installed, uninstall it from Programs and Features in Control Panel. Additionally try to completely uninstall Skype and then re-install the latest version.

3. Use the System File Checker (SFC) tool to fix Windows corrupted files and services: To do that:

• Right-click at Command prompt shortcut (Start > All Programs > Accessories > Command prompt) and select 'Run as administrator'.
• In the command window, type the following command and press Enter.
• SFC /SCANNOW
• Wait and do not use your computer until SFC tool checks and fixes the corrupted system files or services.
• When SFC tool finishes, reboot your computer and check if copy/paste are working.

4. If you use a remote desktop connection to connect to a remote machine and copy & paste commands are not working when connected, then kill and re-run the remote desktop clipboard process 'rdpclip.exe'. To do that:

1. Right-click on the taskbar and select Task Manager.
2. Click the Processes Tab
3. Select rdpclip.exe
4. Click End Process
5. Click the Application Tab.
6. Click New Process.
7. Type rdpclip.
8. Click OK.

5.Repair your Office installation.

6. Check with another keyboard.

That's it!