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: