Archive for Learn

Digital Airbrushing – Practicing how to airbrush with a step by step guide

Digital Character Design and Painting (Charles River Media Graphics) by Don Seegmiller   This book has had a tremendous influence on my love of digital airbrushing. My hand drawing skills were good, and I had created several elaborate pen & ink drawings as a teenager. I needed more guidance with actually coloring in those pieces. […]

Excel2010 – Create a Scroll Bar for Chart Animation

I have been looking for both a beautiful and functional way to show a sliding timeline shart to represemt Trailing Twelve Month (TTM) data.    

Excel VBA – Looping using VBA

In this video, the author demonstrated how to code   For loop using VBA. About 1/2 way through he shows how to use FinalRow  in a loop to make it dynamic.    

Excel 2010: Advanced Filters – 5 Examples from ExcelisFun

I have been presented with a new challenge at work: the Color Chart aka DEB Chart 1. The gist of the challenge is extracting the right data based on a set of criteria that can be changed. I have never used Advanced Filter before, and this YouTube video by ExcellsFun. This video is 33:27 minutes […]

Conditional Formatting |

I thought this was an easy question to be able to answer but it ended up taking me FOREVER to find it. And this was the video that helped me I wanted to compare two columns side by side. The idea was to put them in order and highlight whenever the value was different. Sounds […]

Sales Forecasting and Reporting with Excel Files

Uses “Consolidation”

Fill Blank Cells in Excel

This very situation came up recently when a friend had a long list with some cells left blank that were supposed to be filled with the data in the first active cell above them. This 40 second video was just the thing we needed. A very useful tip/trick in quickly entering data in blank cells.

Excel 2010: Conditional Formatting

Learn Excel 2010 – “Select An Entire Table with VBA”: Podcast #16

Excel 2010 | Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2

Excel 2010 : Record and Edit an Excel Advanced Filter Macro

Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR …

The concept I leaned from this video helped me to create my first Macro for preparing a list that track about 100 key identifiers for a weekly report. Part of the preparation process was to order the key identifiers by fiscal period with other criteria requiring or statements. | Up and Running with VBA in Excel with Curt Frye

Current Status:  100% Competle This was definitely a great introduction to VBA and beginner concepts for programming. The examples were easy to understand and gave me the knowledge necessary to get a start on my first macro. 88% Complete as of 07/28/2013  Taking simultaneously with | Excel 2010: Macros in Depth with Dennis Taylor […] | Excel 2010: Macros in Depth with Dennis Taylor

Background I wanted to learn more about the automation capabilities of Excel. I have been soaking in these courses in my spare time and have used this as a foundation to develop my first macro that helps me prepare a weekly report. It used to take me close 4 solid hours to completely prepare this […]

Udemy Excel Bundle | Local Deal and a Great Buy

A family member happen to be checking out Amazon Local deals right at the perfect time and pinged me suggesting that I take a look.  Recently I have been sponging in all I can on Advanced concepts in Excel. When I say Advanced, I mean that I have already been creating Pivot Tables and slicers […]

Excel 2013 – Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH a

Excel 2010 – How to Use Conditional Formatting to Compare 2 Excel Lists

Trying Out Gallery Bank on LM Reno

[gallery_bank_album_cover album_id=1]

Create a Visual Web Part using Visual Studio 2010 – K. G. Sreeju Nair

Create a Visual Web Part using Visual Studio 2010 – K. G. Sreeju Nair. Bora Suggested This site for creating a visual web part using VS 2010

LESSON 6: SharePoint 2010 Development Training :- My Online Training | Train Signal

SharePoint 2010 Development Training – My Online Training | Train Signal.   I dove right into the training. I skipped over the first 5 chapters since I have already have a working test environment where the SharePoint 2010 is installed on the same machine as Visual Studio 2010. I have already played around with the […] |  X-QPACK2-GD/500

Welcome to |  X-QPACK2-GD/500. Could this please by my mobile SharePoint 2010 / Visual Studio Sandbox unit? It is even sand COLORED!

Adding SharePoint Project Items to SharePoint 2010 in Visual Studio 2010

Adding SharePoint Project Items to SharePoint 2010 in Visual Studio 2010 via Adding SharePoint Project Items to SharePoint 2010 in Visual Studio 2010.    

Getting Started (SharePoint Development in Visual Studio 2010)

Getting Started (SharePoint Development in Visual Studio). This section helps you start working with Visual Studio to develop SharePoint solutions that take advantage of Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010. SharePoint offers a Web-based collaboration platform. Visual Studio provides many project templates for creating SharePoint sites and content, including list definitions, workflows, […]

Accessing SharePoint 2010 List Data by Using LINQ to SharePoint

Accessing SharePoint 2010 List Data by Using LINQ to SharePoint.

SharePoint Online for Office 365 Developer Guide – Restrictions to Sandboxed Solutions

SharePoint Online for Office 365 Developer Guide. Topics of Interest include: Restrictions for Sandboxed Solutions To ensure stability for the rest of the farm, some artifacts and operations are not allowed in sandboxed solutions. Allowed and Disallowed Artifacts Not all types of Visual Studio projects for SharePoint can be configured as sandboxed solutions, regardless of […]

CodePlex – “Visual Studio – SharePoint List” Search Results

CodePlex – Project Directory. | “Visual Studio and SharePoint” Search Results

Useful Sharepoint Designer Custom Workflow Activities – Project Directory.

SharePoint Developer Tools for Visual Studio 2010 – Home

SharePoint Developer Tools for Visual Studio 2010 – Home. | ASP.NET Essential Training with David Gassner (6 hours 5 mins)

Back Story I have just gotten through the Foundations of Programming: Fundamentals with Simon Allardice and am prepared to begin learning ASP.NET. Sure enough,, has a class for that. I am taking this course as a prerequisite for Visual Studio Essentials Training. author: David Gassnersubject: Developer, Programming Languages, Web Development, Servers, Web,Programming Languages software: ASP.NETlevel: Beginner duration: 6h 5m released: Apr 28, 2009 DVD: purchase Course […] | Foundations of Programming: Fundamentals with Simon Allardice – (4 hours 47mins)

Back Story The scope of my “Wacky Portal” project for work has increased. The new scope cannot be done using just the out of the box (OOB) features or even SharePoint Designer. After consulting with my good friend and SharePoint expert, Bora, I have realized that I will have to work with Visual Basic 2010 […]

SharePoint Development Tasks – How Do I…?

This is a great resource for Microsoft SharePoint Foundation 2010. Published: May 2010 How-to Topics Examples:  How to: Access, Copy, and Move Files How to: Add a Column to a List How to: Add a Column to a Site How to: Add a Content Type to a SharePoint List How to: Add a Content Type […]

SharePoint : Describing Forms of URL Strings

Published: May 2010 Microsoft SharePoint Foundation uses various forms of URL strings, depending on the context and members that are being used. SharePoint Foundation parses URL strings to determine the form of URL based on a specified protocol (for example, http:) or on the placement of a forward slash (/) within the string. Depending on the […]

How to: Read the Value of a Field in a List Item

How to: Read the Value of a Field in a List Item.

Why LINQ beats SQL

Back Story I installed Visual Studio Premium 2010 on the test environment to start developing web parts for my “Wacky” project. Installing and launching the application was no problem. Now I just had to develop in it with little experience. Woo Hoo! As I was viewing every possible blog and video, I noticed that […]

SharePoint: Creating SharePoint 2010 Visual Web Parts in Visual Studio 2010 – YouTube

SharePoint: Creating SharePoint 2010 Visual Web Parts in Visual Studio 2010 – YouTube. | InfoPath 2010 – Essentials Training – (6 Hours 6 Min)

10/04/2012 – I am 2 hour into this video and am already thinking that this is  fantastic way to learn InfoPath 2010! I am actually going to use this at work tomorrow to help me build the form for the “Wacky Project!”  11/11/2012 – I just realized that yet again, I did not watch the closing […] | SharePoint Designer 2010: Creating Data-Driven Web Pages with Simon Allardice – (2 Hours 55 min) Course Description Explore how to use SharePoint Designer to create rich, highly visual web pages in SharePoint that connect, read, and even update information stored externally. Author Simon Allardice shows how to manage data sources that connect to different databases, web services, and XML files, without any coding necessary. It also covers how to […] | SharePoint Designer 2010: Building Custom Workflows with Gini Courter – (4 Hours 44 Min)

  09/25/2012 – Started Course This is awesome! I got through the first hour of the training but repeated some of the videos to better grasp the content. Gini goes over not only how to create workflows, but also best practices for creating and maintaining workflow. In particular, I was very impressed with  Chapter 11. […] | Interactive Data Visualization with Processing with Barton Poulson – (7 Hour 43 Min) | SharePoint 2010: New Features with Simon Allardice – (1 Hour 59 Min)

Back Story I need to unlearn SharePoint 2007 in order to build a department portal in SharePoint 2010. I have never used designer 2007 but have experience creating templates and organizing documents to form a functional document repository. author:Simon Allardice subject:Business software:SharePoint 2010 level:Intermediate duration: 1h 59m released: May 18, 2010 In SharePoint 2010 New Features, Simon Allardice […]

Welcome to my world!