Excel Tutorial for Christa NO EXCUSES 20 min per day

Plural Sight Videos !!!

Download each folder lesson and DO lesson:

https://drive.google.com/drive/u/0/folders/1aRM7mLY9v_I2vi3JlSiiirBirPfKBRDh

1. Beginner Lessons

Loading Data into Excel

Searching and Manipulating Data in Excel

 

2. Intermediate

Calculating Cell Values with Formulas

Recording and Managing Excel Macros

3. Advanced

Summarizing and Organizing Data in Excel

Exploring Data with PivotTables

Distributing Excel Workbooks

Charting Data with Excel

Original Plural sigh lesson is HERE

 

Youtube & Free!!!

Basic: Formulas and Functions

1. Excel Basic Formulas and Function

2. Sum all lookups

LookUps:

Lookups : Lookups will allow you to merge worksheets. E.g:  Match Invoices to Rates.

V Lookup : 30 min or less

Learn V Lookup for basic matching, e.g: match “Acme Inc” = “Acme Inc”

1. How to Do a VLOOKUP With Two Spreadsheets in Excel

Sample: VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

2. Excel VLOOKUP tutorial for beginners with formula examples

3. V Lookup Explained

Fuzzy Lookup : 30 min+

Learn Fuzzy Lookup for advanced matching, e.g: Match “ACME Inc” and “Florida ACME Inc”

1. Download Fuzzy Lookup Add-In for Excel

2. Watch Tutorial

 

Playlist Tutorials:

1. Excel Basics

2. Tips & Formulas 

 

 

 

Paid Courses:

1. Advanced Excel: Top 10 Excel Tips & Formulas

- $34.00 Video + includes sample workbook

Entity Framework 6 : Default Code First Conventions

EF 6 Code First Default Conventions :

1) Default Inheritance Type: Table Per Hierarchy (TPH)

2) foreign key properties

- Any property with the same data type as the principal primary key property and

- with a name that follows one of the following formats represents a FK for the relationship:

• <navigation property name><principal primary key property name>',
• '<principal class name><primary key property name>', or
• '<principal primary key property name>'

3) Primary Key Convention

-property is a primary key if a property on a class is named “ID” (not case sensitive), or the class name followed by "ID".

4) If FK on the dependent entity is not nullable, then Code First sets cascade delete on the relationship.

- Nullable:

public int? CountryId { get; set; }

5) Type Discovery:

- you define a context class that derives from DbContext and exposes DbSet properties for the types that you want to be part of the model.

6) exclude a type from the model

-use the NotMapped attribute or the DbModelBuilder.Ignore fluent

7) No PK or FK: Its a complex type. Complex Type rules include:

- type does not have properties that reference entity types and

- is not referenced from a collection property on another type.

.Net Database Connection String Samples

1. Web.Config Connection String

<configuration> <connectionStrings> 

<add name="myConnection" connectionString="server=localhost;database=mydatabase;" /> </connectionStrings> </configuration>

2. Get connection string using the ConfigurationManager class:
string conn = ConfigurationManager.ConnectionStrings["myConnection"].ConnectionString;
3. EF Reference Connection String in DB Context Ctor:
public class DatabaseContext : DbContext {
public DatabaseContext() : base("myConnection")
{ } }
4. SQL Server Connection String Integrated Security:
<connectionStrings>
<add name="sqlServer" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=True;" /> </connectionStrings>
5. SQL Server Connection String SQL Authentication:
<connectionStrings>
<add name="sqlServer" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=MyDatabase;User Id=user;Password=pwd;" /> </connectionStrings>

6. My SQL Connection String:
<connectionStrings>
<add name="mySql" providerName="MySql.Data.MySqlClient" connectionString="Server=localhost;Database=MyDatabase;Uid=user;Pwd=pwd;" /> </connectionStrings>

7. Oracle Connection String
Data Source=ABC.Company.OraDSName;User Id=myUid;Password=mypwd;
8. SQL Server by Database Name
<add name="MyDBStage" connectionString="Database=MyDBStage;Server=.\sql2012;Integrated Security=SSPI;"
      providerName="System.Data.SqlClient" />
9. Connection String using Model:
<connectionStrings>
    <add name="MyDBEntities" connectionString="metadata=res://*/Data.MyDB.csdl|res://*/Data.MyDB.ssdl|res://*/Data.MyDB.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=SP2013E\SPSQL;initial catalog=MyDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
10. MS Dynamics Connection String
<add name="Xrm" connectionString="Server=http://myCompany.crm5.dynamics.com; Domain=myCompany; Username=myUserId@myCompany.com.au; Password=Secret0102"/>
  </connectionStrings>
11. Named Connection String Integrated Security:
<add name="MyDBConnString" connectionString="Database=MyDB;Server=MyServer;Integrated Security=SSPI;"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
12. References:

Connection Strings Samples
MS Connection Strings

Guide to Connection Strings

.Net Framework vs .Net Core vs .Net Standard

What is .Net Standard and why does it show as a project platform type in Visual Studio when I click New Project?
Well, .net Standard is NOT a platform, it is a standard. If we remember that, then it makes sense. Think of .net standard as the mesh that maps the various platform version together for interoperability. See the below table:

What is .NET Standard?

.NET Standard is a specification (not an implementation of .NET) which defines the set of APIs that all .NET implementations must provide. It addresses the code sharing problem for .NET developers across all platforms by bringing APIs across different environments.
We can think of it as another .NET Framework, except that we use it to develop class libraries only. .NET Standard is a successor of the portable class library.
Ok, so .NET Standard specifies the APIs that need to be implemented.
But which APIs does it cover?
To answer this question in short – there are multiple versions of .NET Standard. Each version includes a set of APIs which we are going to cover in a while.

Update Android Property File

1. Download .prop file from phone to computer

2. Edit the .prop file using a text editor

3. Upload .prop file from computer to phone.

See below example script:

1. adb pull /system/build.prop c:\Temp\Phone

2. Edit Props:using notepad

3. adb push C:\Temp\Phone\build.prop /system/

Tweaks:

Chrome Extension Review: Pricing Tools for Comparison and Research

Price Comparison Chrome Extensions

Summary:

Yroo is the clear winner without a doubt :

- most accurate

- most stable providing consistent results

- cleanest design

- consistent and reliable

Get it Yroo - Price Comparison and Price Tracker

*************** Reviews ***************

pricescout

Amazon

found 3 prices, same as Yroo

http://prntscr.com/s7rvbz

Ebay

N/A

Performance:

Load time range: 4-6 seconds

CPU Impact: 5%

RAM: 5MB

Rating:

Pricing: 6 (Amazon: 9, Ebay: 0)

* Only works on amazon, Options screen is blank.

Browse Plus

Amazon

DID NOT WORK

Ebay

DID NOT WORK

Performance:

N/A

Rating:

Pricing: 0

* Only works on amazon

Cheaper Marker

Amazon

found 1 better price, compared to ebay

http://prntscr.com/s7r2v8

Ebay

N/A

Performance:

Load time range: 4-6 seconds

CPU Impact: 5%

RAM: 5MB

Rating:

Pricing: 6 (Amazon: 9, Ebay: 0)

* Only works on amazon

Honey

Amazon

found 10+ coupion code, no prices

http://prntscr.com/s7r1yo

Ebay

found 1 code, activated, no price compare

http://prntscr.com/s7r258

Performance:

Load time range: 1-3 seconds

CPU Impact: 5%

RAM: 5MB

Rating:

Pricing: 1, Coupon: 10

Yroo - Price Comparison and Price Tracker

Amazon

works ok, quick price compare, comapres to ebay and others

http://prntscr.com/s7qyrd

Ebay

works OK, 14 second load time, compares to google and walmart. ** did not compare to amazon?

http://prntscr.com/s7qzjv

Performance:

Load time range: 5-15 seconds

CPU Impact: 10%

RAM: 30MB

Rating:

7

* Works on all sites, a little slow when loaded with other ext's

Prickle

Amazon

works ok, quick price compare, comapres to ebay and others

http://prntscr.com/s7s4jt

http://prntscr.com/s7s5j9

http://prntscr.com/s7s5p3

Ebay

S/A

Performance:

N/A

Rating:

9

* Works on all sites, however the process is a pain:

1. select a price

2. enter email,

3. wait and go to my email to do a price check.

Very arduous. Too tedious. May be helpfule in a researching scenario, but not for day to day shopping.

PriceBlink Coupons and Price Comparison

Amazon

works 70% of the time, rest it did not pop up or displayed wrong product

http://prntscr.com/s7sb23

http://prntscr.com/s7saa3

Ebay

worked OK, 10 second load time, worked better than amazon.

http://prntscr.com/s7sas6

Performance:

Load time range: 5-20-never seconds

CPU Impact: 10%

RAM: 30MB

Rating:

5

* Besides Yroo this is the ONLY tool that kind of worked.

Yroo is the clear winner without a doubt :

- most accurate

- most stable providing consistent results

- cleanest design

- consistent and reliable

Rest of the add-on felt like hacks and/or beta products. For a solid and reliable price checking experience, go with Yroo.

For Price Researching

These extensions can come in handy to analyze price over time, site (retailer) and volume.

Camelicer and

Keepa

are 2 of the best! Plus PriceGeeks site has some of the best price analytics spanning ebay Ended auctions for deep price history data to spot those future price trends !

http://www.thepricegeek.com/

More….

smart-price-monitor

- Does not compare prices, only tracks. Must setup a price alert, use this for pricing research not for simple shopping price comparisons

- similar to Keepa - Amazon Price Tracker

price-tracker

- Does not compare prices, only tracks. Must setup a price alert, use this for pricing research not for simple shopping price comparisons

- similiar to Keepa - Amazon Price Tracker

Windows 10 : Windows Update Service Depends Notes

If utilizing one of the various recommendations to improve Windows 10 performance such as flavors of Black Viper or other service configurations, please note that there are new services in Windows 10 related to Windows Update. The following services have dependencies with Windows Update in Windows 10 thus when changing service status to boost performance be aware that you may break Windows Update or the installer process.

The default install of Windows 10 (Pro or Home) sets these services to run Automatically it is thus a best practice to audit changes to service configuration before and after any manual updates.

1. Windows Module Installer:

Also required for msi installs, e.g: .Net FR Runtime install/updates install via direct .msi/exe execution.

2. Windows Remediation Service

Added in a cumulative update. Microsoft announced that the Windows 10 KB4023057 update patch would enhance the service components’ reliability. The patch offers reliability improvements for the following versions of the Windows 10 operating system:‘ 1507 – 1803.

The exe assoc. with this service is Sedlauncher.exe normally in the C:\Program Files\rempl directory.

3. Microsoft Compatibility Telemetry

This is a system service in Windows 10 & is part of the Windows Customer Experience,  Improvement Program and Windows Update.  The executable file for this service is used for upgrading Windows to the latest Version and installing Service Pack Updates. It is located in the C:\\Windows\System32 directory and transfers telemetry data.

More Info regarding these services:

What is Windows Remediation Service

Fix or Disable the Windows Compatibility Telemetry Service

Methods to disable services:

Windows Remediation Service

1. Launch the Run dialog box by pressing Windows Key+R on your keyboard.
2. Inside the Run dialog box, type “services.msc” (no quotes).
3. Once the Services utility window is up, scroll down until you find the Windows Remediation Service.
4. Right-click it, then select Properties.
5. Now, go to the General tab.
6. Stop and Disable | Apply

Windows Compatibility Telemetry Service

1. Run | gpedit.msc

2. Browse to : "Computer Configuration >  Administrative Templates > Windows Components > Data Collection and Preview Builds".

3. Set Allow Telemetry = False

See Example here