By: S.E. Williams
May 19, 2020
"Introduction to Excel" Course Review
By: S.E. Williams
May 19, 2020
Cybrary is offering an Introduction to Excel course by instructor Milan Cetic. This course can help information technology professionals, as every IT person will need a robust tool to conduct analysis, tracking, and reporting. In this course, you will learn the basic features of the program and how to use them to create nearly any type of tool to aid you in your cybersecurity management workflow.
What Can I Expect to Learn?
The Intro to Excel course will help you learn how to enter any data type (such as numbers and text) and how to use the basic user interface itself. You will also study how to create templates, understand data types, hide and protect cells and sheets, and use pivot tables and charts. The lessons will teach you how to print in your desired format to produce detailed reports and presentations. You will learn how to save your Excel files to various formats that can be used to interact with other programs. Last, you will gain a foundation in writing basic formulas, set functions, and logical operations that will help you develop the skill-set to write more complex functions and expressions.
Examples of Organizations Using Excel
The Excel program can be used beyond simple book-keeping. The U.S. Department of Homeland Security, finance-based companies, universities, and research institutions use Excel for data manipulation and analysis, business projections, cybersecurity assessments, cybersecurity control frameworks, budget planning, and KPI/KRI tracking. Excel has also been reported by The Hacker News1 as the ultimate template to plan and monitor your cybersecurity budgets. Organizations of many sizes use Excel because it is user friendly and easy to use. With the 2016 update of Excel, the new key features are located in the Ribbon Interface, which also enables interaction with other Office programs2.
The Benefits of Learning Excel
In this course, you will learn about four helpful formulas which are most commonly used:
- Mathematical formulas
- Text formulas
- Logical formulas
- Lookup Formulas.
Excel offers a variety of mathematical and trigonometry functions through a drop-down menu that will help you perform complex calculations. Text formulas are helpful when your information inputs are heavily dependent on word-type data. When used together, text-formulas can produce readable sentence-like output strings. In this class, you will also gain an understanding of how logical formulas can be helpful to produce both number-based or text-based data results, which can then be represented in various types of charts.
There are other practical features to learning and using Excel that you may not find in other spreadsheet programs. For example, as mentioned before, the ability to add text-based-data that can also be spell checked via the Review function. Excel also uses online referencing, which allows you to share spreadsheets between colleagues who may choose to review it in different languages. Text-based data can be manipulated and analyzed in Excel, spell checked for accuracy, and then read in multiple languages.
Another advantage of learning Excel is you don’t need to be a mathematical whiz to create formulas to accomplish your data-tracking goals. For example, formulas are included in the basic functions, and the program allows you to track dependencies between cells and values. Moreover, you will acquire skills that will help you edit values and formulas that can be reused for various projects. This is particularly helpful when working with automatic and manual recalculations used in repetitive series that may need to be adapted for special calculations.
Cybrary Courses that Align with Intro to Excel
The Intro to Excel course is a beneficial foundation course to other Cybrary courses, including Intermediate Excel, NMAP, Application of the MITRE Attack and Framework, and Excel 2016 – Core Data Analysis, Manipulation, and Presentation. Finally, learning Excel is a foundational tool for improving the management of cybersecurity projects.
Gain Knowledge In Excel With This Course:
(March 11, 2020). Use this ultimate template to plan and monitor your cybersecurity budgets. The Hacker News. Retrieved from: https
Gralla, P. (2017, May 12). Cheat sheet: The must-know Excel 2016 features. Are you getting the most from Microsoft Excel 2016? Familiarize yourself with the key new features. InfoWorld. Retrieved from: https