A Tech Blog by David Kandie

Friday, January 23, 2015

What's new in Excel 2013

The first thing you’ll see when you open Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions.

Welcome to GMAIL tabbed inbox from Google

Welcome to Gmail's tabbed inbox by Google. Highlights: Now you are able to group emails based on tabs (Promotions, Social, Primary, Forums and updates).

We are hiring! - Business Development Officer at OpenCastLabs Consulting

How to create user fum

Wednesday, October 23, 2013

Introducing PowerPivot for Excel 2010

What is PowerPivot
 
PowerPivot is a free add-in to the 2010 version of the spreadsheet application Microsoft Excel. In Excel 2013, PowerPivot is only available for certain versions of Office. It extends the capabilities of the PivotTable data summarisation and cross-tabulation feature with new features such as expanded data capacity, advanced calculations, ability to import data from multiple sources, and the ability to publish the workbooks as interactive web applications. As such, PowerPivot falls under Microsoft's Business Intelligence offering, complementing it with its self-service, in-memory capabilities.
Prior to the release of PowerPivot, Microsoft relied heavily on SQL Server Analysis Services as the engine for its Business Intelligence suite. PowerPivot complements the SQL Server core BI components under the vision of one Business Intelligence Semantic Model (BISM), which aims to integrate on-disk multidimensional analytics previously known as Unified Dimensional Model, or UDM, with a more flexible, in-memory "tabular" model.
As a self-service BI product, PowerPivot is intended to allow users with no specialised BI or analytics training to develop data models and calculations, sharing them either directly or through SharePoint document libraries.
As part of the July 8, 2013 announcement of the new "Power BI" suite of self-service tools, Microsoft renamed PowerPivot as "Power Pivot" in order to match the naming convention of other tools in the suite.

Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology; fast manipulation of large data sets, streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint. 


How to download and install PowerPivot

Prerequisites:
  • Requires Microsoft Office 2010.
  • PowerPivot for Excel supports 32-bit or 64-bit machines.
  • PowerPivot requires a minimum of 1 GB of RAM (2 GB or more recommended).
Note: The amount of memory you need depends on the PowerPivot solution that you design.
  • Requires Windows XP with SP3, Windows Vista with SP1, or Windows 7
 Download PowerPivot Here

Important: If you are using the 32-bit version of Excel 2010, you must use the 32-bit version of PowerPivot. If you are using the 64-bit version of Excel 2010, you must use the 64-bit version of PowerPivot. The versions are not interchangeable. 

Install and configure PowerPivot for Excel 2010:
  1. Open the folder where you downloaded PowerPivot for Excel 2010.
  2. Double-click the PowerPivot_for_Excel.msi file, and then follow the steps in the wizard.
  3. After the installation is complete, click Finish.
  4. Click Start, click All Programs, click Microsoft Office 2010, and then click Microsoft Excel 2010.
  5. When Excel 2010 starts, a message appears asking if you want to install PowerPivot. Click OK.
  6. After installation completes, the PowerPivot tab appears in the Office 2010 ribbon.
In my next post we will see..oh my, you can analyze multiple data tables from Oracle, SQL, Excel, Text, Access and Much more!

Let's go.

Friday, August 2, 2013

Load or unload add-in programs

There are different types of add-in programs for Microsoft Office Excel that provide optional commands and features: Excel add-ins, such as the Analysis ToolPak and the Solver Add-in, are available when you install Microsoft Office or Excel. Additional add-ins for Excel can be downloaded from Downloads on Microsoft Office Online. Developers and solution providers usually design custom Component Object Model (COM) add-ins and automation add-ins. You must load an add-in before you can use it. After loading the add-in, the add-in program and its commands are available in one of the following locations: Data tab. The Analysis ToolPak and Solver Add-in are displayed in the Analysis group. Formulas tab. The Conditional Sum Wizard, Euro Currency Tools, Eurotool, and Lookup Wizard are displayed in the Solutions group. Add-Ins tab. The Add-Ins tab is added to the Ribbon, a component of the Microsoft Office Fluent user interface, when you load the first add-in for that tab. If you don't see the Add-Ins tab, you should exit Excel and restart it. Let us tell you how. Go to OpenCastLabs to learn more

Wednesday, July 24, 2013

Advanced Microsoft Excel Training at OpenCastLabs in Kenya, Uganda, Tanzania, Rwanda and Burundi

This is a unique post. It is a promo, it is an info source for you my dear reader. OpenCastLabs Consulting is a specialized training company operating in all the 5 Eastern African Countries commonly referred to as Eastern African Community. We specialize in Microsoft Excel as a productivity tool. Our classes are either monthly or a re conducted in your premise. Contact us here () for us to send you a no-obligation quotation for persons not less than 5 per group. You can also check our course listing here or a sample course on Advanced Excel for Finance Professionals () and Budgeting and Forecasting with Microsoft Excel () Hit me up anytime on info(@)opencast-labs.com or call/SMS +254 722 831 259 Any time go to