Select your dataset without all that clicking and dragging (Excel 2016/2013)

Posted on 4/19/18 2:04 PM by Get Schooled in Excel, in excel tips & tricks, in Microsoft Excel, in dataset

To select your entire dataset, do you always click and drag? For small groups of cells, this method works just fine, but as your dataset grows, you may find it awkward to drag outside the visible window. Sometimes the scrolling speeds up unexpectedly, and you have to really work to select your entire dataset and nothing more. Consider a faster approach: simply press [Ctrl][Shift][*] to select your entire dataset.

Once you click on a cell, you can select the remainder of that column by pressing [Ctrl][Shift][Down Arrow], or you can select the remainder of that row by pressing [Ctrl][Shift][Right Arrow]. Similarly, [Ctrl][Shift][Up Arrow] and [Ctrl][Shift][Left Arrow] select the dataset’s entire column above and to the left of the selected cell, respectively. Combine the arrows for even more options. For example, press [Ctrl][Shift][Up Arrow][Right Arrow] to select everything in the dataset above and to the right of the selected cell, and so on.

0 CommentsContinue Reading →

Microsoft CSP is a Great Place to Start, and Here’s How to Make it Better

Posted on 4/19/18 9:00 AM by Get Schooled in Azure, in cloud computing, in Microsoft, in Microsoft Certified, in scalable, in saleable

Microsoft CSP is a Great Place to Start, and Here’s How to Make it Better

The Microsoft Cloud Solution Provider program offers a great foundation for cloud solutions, but there’s much more to integrate around it to enhance the services, increase the value proposition, and complete the solution.

Microsoft created the Cloud Solution Provider program to focus its partner community on the two things Satya Nadella identified in his first address to Microsoft after becoming CEO, in which he said, “Microsoft will be the platform and productivity company.”

By “platform” he meant Azure. By “productivity” he meant Office 365, and now Microsoft 365.


0 CommentsContinue Reading →

Use echo to confirm malicious activity without execution (PHP)

Posted on 4/18/18 2:02 PM by Get Schooled in PHP, in php code, in Tips & Tricks, in echo

Hackers have all kinds of ways to infiltrate servers and access files unauthorized. If you find PHP code with a suspect source, it’s worthwhile to investigate it further and in great detail. Hackers frequently employ a method called obfuscation to hide their malicious code in plain sight. The best preliminary way to begin evaluating the code is to highlight everything differently so the unusual code, such as string declarations and concatenations, begin to stand out. Once those are identified, use echo to follow the suspect functions down their rabbit hole.

For example, for a suspect ‘$ItemName’, add ‘echo $ItemName’ and note its revealed function. Continue following the breadcrumbs with an echo function, even if the result is a huge mass of concatenations, until you reach the heart of the infiltration. This will reveal the depth of hack and confirm the malicious activity without executing it.

0 CommentsContinue Reading →

Create a series of same-sized shapes with the Convert Shape command (InDesign CS6/CC/CC 2014/CC 2015/CC 2017/CC 2018)

Posted on 4/17/18 8:00 AM by Get Schooled in Illustrator, in Adobe, in Adobe Illustrator, in Tips & Tricks

The Convert Shape command comes in handy when you decide mid-stream to change an existing shape, such as a rectangle, to something else, such as an ellipse. Just select the shape, choose Object > Convert Shape, and select your shape option from the pop-up menu.

0 CommentsContinue Reading →

big-data-big-career-big-income-certification

Posted on 4/12/18 9:00 AM by Get Schooled in Big Data, in virtual data center, in Technical Training and Certification, in data research

Big Data, Big Career, Big Income, Start Small

Data Scientist is the hottest career choice available in the tech industry. To earn the big income these professionals pull down you need a multi-disciplinary education that takes time to complete. Here’s a brief look at that curriculum with great suggestions as to where you can enter the Big Data business easily to begin your growth plan.

0 CommentsContinue Reading →

Virtualize Has Many Meanings

Posted on 4/2/18 9:00 AM by Get Schooled in cloud computing, in Virtual Servers, in virtualization, in Private Cloud, in technology, in future


Virtualize, Virtualize, Virtualize

There’s much to virtualize! Servers, storage, desktops, and all of it reduces costs, increases control, and facilitates cloud. The more you can virtualize the more valuable you become, so learning how to virtualize everything is a great strategy for maximum professional growth.

Saying “virtualization” to a technology expert is like saying “white” to an Eskimo. Everything in an Eskimo’s world is white, so they’ve developed many different words to describe many different kinds of white.

The same is true in IT. There are many kinds of virtualization, and all of them work together to create tremendous gains in efficiency, effectiveness, and cost-control.

0 CommentsContinue Reading →

Cisco - Quickly Remove Settings with a Config Command

Posted on 3/2/18 2:00 PM by Get Schooled in Cisco, in Information Technology, in Tips & Tricks

Modifying an interface configuration can be as tedious as picking white cat hair off a black cashmere sweater.
Typically, in order to remove unwanted items you have to go through each individual line and put “no” in front. If you need to completely re-do the configuration or are faced with a laundry list of changes, it is simpler and faster to restore the default configuration. Furthermore, it will reduce potential oversight errors.

0 CommentsContinue Reading →

Embrace arrow functions to write clean, condensed code(JavaScript)

Posted on 3/2/18 1:15 PM by Get Schooled in code, in javascript, in tips and tricks, in Tips & Tricks, in arrow function

Clean Javascript Code Makes You Happy

Modern web developers are constantly working on ways to simplify the development process and streamline code. Not only does this make code easier to write, but efficient code doesn’t need a long explanation when working on team projects or passing the baton to a fresh developer. 

0 CommentsContinue Reading →

Create digital lighting with HTML5 (HTML)

Posted on 3/1/18 5:24 PM by Get Schooled in html, in HTML5, in digital lighting

Amazing  Effects with the Canvas Tag

Electrifying lightning strikes are no longer limited to the night sky thanks to HTML5. Using the HTML5/CSS3 code provided here: http://cssdeck.com/labs/xq2cpb8s as a basis for your own development, you can create custom high-energy lightning animations that have engaging elements of interaction.

0 CommentsContinue Reading →

Configure the index to search custom columns (SharePoint)

Posted on 3/1/18 5:02 PM by Get Schooled in custom, in Microsoft, in SharePoint, in index, in Configure

Making Sharepoint User Friendly for search!

Custom columns are not searchable unless they are configured to be indexed. If you’re building custom columns and want to search them in the future, the fastest solution is to create them as site columns—which are indexed automatically. If you’ve gone too far for this option, you can index the custom columns by adding them to an established managed property.

0 CommentsContinue Reading →

    

Subscribe

Posts by Topic

see all

Lists by Topic

see all