Gita's Page

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. […]

How-to Make an Excel Company Goal Tracker Thermometer Beer Ch

Very cool demo of how to create a custom “thermometer” styled chart ….

Create Speedometer chart in Excel!

Increadibly it is a pie chart cleverly layered on top of a donut chart with tricks such as no fill and other cool things.

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 […]

Certifications: Microsoft MOS Certifications – Getting Certified!

Background: It is time to get the I am certifiably awesome in MOS. I have been using the product for years and have been taking classes online through various training/online ed sites. This page helps me keep track of the goals and helps me plan out what needs to be accomplished in order to achieve […]

Self Test: Kaplan – Microsoft Excel 2010 Expert

Goal 1: I have purchased the Self Test Package through Kaplan with Online access to the Self Test Materials. https://www.selftestsoftware.com/profile/myaccount.aspx?n=1   This will help me pass the 77-888 – MOS: Microsoft Office Excel 2010 Expert      

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.

Lynda.com | 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  Lynda.com | Excel 2010: Macros in Depth with Dennis Taylor […]

Private Journal | Automating Business Development Reporting using Macros & SharePoint

Background: As I monitored how long it takes me to PREPARE reports vs. how much time I spend in analysis, I realized that that I was spending the lions share in the PREPARATION process. My reality check came with I realized that it this manual process was the main reason I was stressed, overworked and […]

Lynda.com | 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 | Amazon.com 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

Lynda.com | 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 […]

Lynda.com | 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 […]

Lynda.com | 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. […]

Welcome to my world!