How to Learn Excel: A Guide for Beginners

Posted by Develop Admin
March 9, 2021

Microsoft Excel is an application used extensively by businesses of all sizes to organize and manage their data. This powerful tool is part of the Microsoft Office suite of software and makes it easy for you to store your data, analyze it, and report on what your data is showing. For a beginner, Microsoft Excel can be intimidating or confusing, but once you understand the core concepts, it’s really easy to start using it in your job!

Getting Started: How To Create An Excel Spreadsheet

When you open Excel and create a blank spreadsheet, you’ll see that across the top, there are a series of horizontal columns that are labeled alphabetically and vertical rows that are numbered. The point (or cell) where a row and a column intersect will consist of both a number and a letter. For example, the box or cell in the top left corner is A1 – column A, row 1. Below that is A2 – column A, row 2, and to the right of the first cell is B1 – column B, row 2. These codes or names are known as cell references and are used to reference a specific point on the spreadsheet.

A "cell" in Microsoft Excel

To get started, place your cursor in the chosen cell, enter your data and then either click to a new cell, press “Enter”, or press “Tab” to move to the next cell. Next, take notice of the two boxes located above the lettered columns. Here, a box labeled the “name box” and a “formula bar” can be found. The “name box” will display the cell reference that is currently selected while the “formula bar” will allow users to enter functions and calculations.

Performing Calculations in Excel

To perform basic Excel calculations, you’ll need to enter the desired formula into the “formula bar.” To do this, it is crucial to begin each one with “=” or the equals sign. When you want to add together the sum of the data within two cell references, simply enter the formula into this bar. For example, if you want to add cells B1 and B2 and display the result in B3, you would put your cursor in B3 and then enter: “=B1+B2” into the formula bar and then click enter. Excel will automatically calculate the total and display it in cell B3

Using the Name box and Formula Bar in Microsoft Excel

To perform other calculations, use the following formulas:

  • To subtract: =B1-B2
  • To multiply: =B1*B2
  • To divide: =B1/B2

Using the Ribbon

The “ribbon” is simply a different way of referring to the main menu within Excel that is found at the top of the screen. This main menu (or ribbon) is where you can perform several different tasks related to your spreadsheet. You’ll see there are tabs labeled “File”, “Home”, “Insert”, “Page Layout”, “Formulas”, “Data”, “Review”, “View” and “Help”. Using these tabs to navigate, you can perform several different functions such as creating a new spreadsheet, reviewing data, or viewing a list of formulas. Also located on the ribbon are several tools that allow you to customize the way that the spreadsheet looks. You can change the font color or style, create bold or underlined text and change text alignment. You can also delete rows or columns of data or blank spaces within the ribbon.

The Ribbon in Microsoft Excel

Saving Spreadsheets

After a spreadsheet is completed, you can save your work by simply pressing the “ctrl” and “s” buttons at the same time, or by selecting “Save” under the “File” tab within the ribbon. Once the spreadsheet is saved, you can share your spreadsheets or just store them in a folder on your computer.

As you can see, while Microsoft Excel might be a bit intimidating at first, it’s actually pretty simple when you understand the core functionality. Knowing how to properly use Excel can help you stand out in your job and make you an invaluable member of your team, and we have a full suite of online courses to help you learn.

Keep learning how to use Microsoft Excel today!

Microsoft Excel for Beginners

Introduction to Microsoft Excel

Excel is a powerful tool for organizing and managing data. This course for beginners using Excel 2019 will help you begin to build a solid grounding in the basics of Excel and guide you towards becoming more confident with spreadsheets.

Why Python Is Perfect For Beginners

Posted by Develop Admin
March 8, 2021

Are you interested in learning how to write your first simple Python code but aren’t sure where to begin? If so, you’ve come to the right place. Our Python for Beginners course set focuses on the fundamentals of Python programming and is built specifically for folks who are just getting started.

In this Python course set, you’ll learn how to write your first lines of Python code using a “Read-Eval-Print-Loop” – it’s not as scary as it sounds. You’ll also explore data types, reference types, and variables while learning the best ways to use these fundamental ideas when writing your own code in this online course.

What Is Python?

Python is a high-level object-oriented, interactive, and interpreted programming language. According to a recent Stack Overflow Survey, Python is among the top loved programming languages by data scientists, web developers, and software engineers because of its flexibility and object-oriented features.

Why Should You Learn Python?

There are numerous reasons to consider learning Python as your introduction to coding. For starters, learning to code can unlock many job opportunities in the tech industry. In fact, Python developers are among the top 5 most in-demand tech jobs!

Python’s versatility also allows you to do numerous things, both big and small. You can use it to build large-scale, comprehensive company solutions, or you can just write simple programs and scripts for your personal projects. In the world of server-side software languages, Python is one of the easiest languages to learn, write, and read.

Many of the world’s biggest companies run on Python, and it is also great for quick and straightforward prototypes. Python can be found everywhere in the world of computer programming because of its extreme scalability. For instance, Python is the foundation of many of the biggest sites and services on the Internet, including YouTube, Spotify, Reddit, and Pinterest.

What Makes Python Perfect for Beginners?

In addition to being extremely popular and used throughout the tech industry, Python has a number of unique features that make it particularly well-suited for someone who is just starting to learn to code:

  • Free: It is available for free, including for commercial purposes
  • Versatile: Python can help in solving problems in countless fields, including GUI development, data science, and scripting
  • Accessible: The core concepts of Python are simple and logical, and do not require any previous coding fluency
  • Open Source: Anyone can see, modify, and distribute Python as they see fit, and can contribute their own improvements back to it

From a software development standpoint, Python is also very simple to write and understand, thanks to the way it is built. These features will make more sense as you grow in your understanding and start to write your own code:

  • Dynamically Typed: No need to declare variables explicitly as it confirms variable types at runtime.
  • Multi-Paradigm: Python allows you to write a code in different styles, including functional, imperative, and object-oriented styles
  • Strongly Typed: It doesn’t let risky operations on unsuited types get ignored
  • Interpreted: It is quicker to experiment with compared to compiled languages

Ready to Write Your First Simple Python Code?

Python for Absolute Beginners

Introduction to Programming and Python

If you are new to programming, this course will help you understand the value of programming as a skill and why you might want to learn Python as opposed to some other programming languages.

Learn How To Use Microsoft 365 Admin Center

Posted by Develop Admin
February 26, 2021

As a systems administrator, one of the core apps that your users are likely to rely on is Microsoft Office 365. While Office has been around for years, Office 365 has some great new features, and allows you to manage everything from a central “admin center”. 

Our new “Microsoft Office 365 Administration” course set is designed to walk you through the initial setup, including how Office 365 is different from regular Microsoft Office. You’ll learn all about setting up and enabling the core apps for your users, including Exchange, Skype for Business, OneDrive, and SharePoint.

Microsoft Office 365 Admin Center Course Index

All of these new Microsoft Office 365 Administration courses are included in our Foundation subscription, along with 300+ other expert-led online courses that teach you networking & telecom, data science, project management, software development, devops, cloud technologies, and more. 

Now is the perfect time to start learning how to manage your team’s Microsoft Office 365 setup!

$9.99/month with free trial. Cancel anytime.