
In this video I will give you a high level overview of the Excel workbook and all its features. If you are not a beginner that you may want to skip to the next video.
From the Home Tab
Adding Worksheets
Renaming Worksheet
Adding Color to Excel worksheet
Format Painter
Borders
Wrap Text
Formatting numbers
Conditional formatting
Merging Cells
Functions and Formulas tab
Data tab
Importing data from the internet
In this video we will create a Wireframe for a mobile application or Website. As we do this we will learn the following key concepts related to formatting your Excel Spread Sheet:
Creating Borders
Adding Colors
Creating Hyperlinks
copying Worksheets
Changing Text Font
Adding Images
Introduction to the Excel for Cyber Security Section. I will give an overview of what we will be building in the project
In this video I will introduce you to using VBA Macros to automate your processes in Excel.
Some concepts you will learn in VBA include:
For Loops
If Statements
Random Number Generators
Variables
Filters
VBA Function and Methods
Completed VBA template available to download in the resource section on the next video
In this video we will complete the VBA code and populate the first Discovered data column
I will also introduce the concept of Arrays/Lists
The Index() and Match() functions are very powerful search tools. We will use these functions to connect values from different datasets
Update the Status column of the excel sheet using a combination of If() and Match() statements
In this vide we will use and() functions and conditional formatting
Learn to organize your data with pivot table and charts
In this project we will download live stock and crypto currency data.
We will learn:
importing data to excel
Math Functions
Data Validation
Learn how to download live data to Excel using the Stock data type
Pull cryptocurrency pricing data from coinmarketcap.com into an Excel trade sheet using the data from the web, loading the top 100 currencies and integrating it with the existing templates.
Build a project Management template that will rival Microsoft Project.
Learning about the Indirect() function
Tired of generic Excel tutorials that leave you feeling lost? This course takes a different approach, equipping you with the skills and confidence to excel (pun intended!) in the workplace.
Why Excel?
Excel is the king of spreadsheets, a versatile tool used across industries for tasks like:
Project Management: Track project timelines, budgets, and resources with ease.
Product Management: Design sleek app prototypes and analyze user data within Excel.
Finance and Trading: Create dynamic trading sheets to analyze Bitcoin and other cryptocurrencies.
Presentations and Design: Craft compelling visuals for impactful presentations.
Automation: Simplify repetitive tasks and boost your productivity with Excel's automation features.
Learn by Doing: The Project-Based Approach
This course ditches the theoretical fluff and dives right into practical projects that mirror real-world scenarios. You'll build:
A Vulnerability Report: Learn valuable skills for cybersecurity professionals by constructing a report similar to those used in the field.
An App Template: Channel your inner product management guru by designing a user-friendly app template within Excel.
Customized Trading Sheets: Take control of your cryptocurrency investments with dynamic sheets to analyze Bitcoin and other markets.
This hands-on approach ensures you grasp the true power of Excel, learning only the functionalities you'll need for immediate effectiveness in the workforce.
Beyond the Basics: Embracing the Future of Work
We understand the workplace is evolving rapidly. As AI continues to transform how we work, this course goes a step further by including exclusive video tutorials demonstrating how to integrate AI tools directly into your Excel workflow.
By the end of this course, you'll be a confident Excel user, equipped with the skills to tackle real-world projects, integrate cutting-edge AI functionalities, and impress in any professional setting.