How to Build Excel Interactive Dashboards
-
Frank
- July 15, 2021
- basics
- console
- dash board
- dashboard
- dashboard excel
- Dashboards
- Data
- Design
- dynamic
- dynamic dashboard
- easy
- Excel
- excel dashboard
- excel dashboard for beginners
- excel interactive dashboard
- filter
- how to
- interactive
- interactive dashboard
- interactive Kevin Stratvert
- kevin stratvert
- kpi
- kpis
- labels
- Learn
- Microsoft
- ms
- ms excel
- pivot
- pivot chart
- pivot table
- pivottable
- refresh
- report
- simple
- Slicer
- Slicers
- spreadsheet
- table
- Tables
- template
- templates
- timeline
- timelines
- Training
- Tutorial
- worksheet
In this step-by-step tutorial by Kevin Stratvert, learn how to create dynamic and interactive Excel dashboards. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. Best of all, you only need is out of the box Microsoft Excel – no plug-ins, etc.
Read More
Automate Excel with Python Using OpenPyXL
-
Frank
- June 23, 2021
- Automation
- Excel
- excel automation
- excel openpyxl
- excel python automation
- install openpyxl
- installing openpyxl
- openpyxl
- openpyxl automate
- openpyxl excel formatting
- openpyxl tutorial
- Python
- python automation projects
- python excel
- python excel automation
- python excel data
- python excel data processing
- python excel manipulation
- python excel tutorial
- python openpyxl tutorial
- python programming
- python projects
- Tech with Tim
- using python to automate excel
Tech With Tim shows us how to automate Excel using Python with OpenPyXL.
Read More
Fun Secrets in Microsoft Products
-
Frank
- June 3, 2021
- 666
- Browser
- control panel
- Cortana
- cortana games
- datedif
- doom
- doom 95
- easter eggs
- Edge
- edge browser
- edge surf
- edge surfing
- Excel
- frodo
- frodo's house
- Game
- Games
- god mode
- how to
- id software
- ipsum
- ipsum lorem
- kevin
- kevin stratvert
- lord of the rings
- Microsoft
- microsoft edge
- microsoft god mode
- microsoft windows
- microsoft word
- placeholder
- secret
- Secrets
- Services
- ski free
- stratvert
- Tutorial
- win 10
- win10
- WIndows 10
- windows 10 god mode
- windows god mode
- word
Kevin Stratvert unearths some of the best secrets in Microsoft products from a former and a current Microsoft employee.
Read More
Top 5 Best Hidden Apps on Windows 10
-
Frank
- June 1, 2021
- App
- apps
- calculate
- calculator
- comes with
- Computer
- convert
- converter
- currency converter
- dictate
- Dictation
- dictation tool
- download
- Excel
- forms
- Free
- help
- hidden
- how to
- included
- Install
- kevin stratvert
- Laptop
- Microsoft
- office app
- paint 3d
- PC
- PowerPoint
- record screen
- screen record
- screen recorder
- screen shot
- screenshot
- secret
- snip
- snip and sketch
- stratvert
- video editing software
- video editor
- Windows
- WIndows 10
- windows 10 app
- windows 10 apps
- word
- xbox
- xbox game bar
Kevin Stratvert teaches us about 5 hidden apps that come for free with Windows 10 that you probably didn’t know about.
Read More
How to use Office Scripts in Excel & Power Automate
-
Frank
- April 12, 2021
- automate
- automations
- beginners
- Business
- Code
- code editor
- create
- Excel
- excel code
- excel macro
- excel macros
- excel script
- how to
- in excel
- java script
- Javascript
- kevin stratvert
- macro
- macro excel
- macros
- macros in excel
- Microsoft
- Microsoft 365
- Microsoft Excel
- microsoft office
- office scripts
- onedrive
- Power
- power automate
- record
- record actions
- script
- scripts in excel
- share
- stratvert
- trigger
- type script
- TypeScript
- VBA
- Web
- work book
- work sheet
- workbook
- worksheet
In this step-by-step tutorial, Kevin Stratvert shows you how you can use Office Scripts in Excel on the web to automate repetitive and mundane tasks. Additionally, learn how you can trigger you scripts automatically using Power Automate. With Power Automate, you can set a Teams message, an email, or other app to trigger your script.
Read More
How to Create & Use Excel Macros
-
Frank
- April 2, 2021
- Advanced Excel tricks
- Excel
- Excel 2013
- Excel 2016
- Excel 2019
- Excel 365
- Excel for analysts
- excel macros 101
- excel macros advanced
- excel macros and vba
- excel macros for dummies
- excel macros leila
- excel macros vba tutorial
- Excel online course
- Excel tips and tricks
- Excel VBA
- Leila Gharani
- macro
- macros
- Microsoft
- Microsoft 365
- Microsoft Excel
- Microsoft Excel tutorials
- VBA
- XelPlus
- XelplusVis
Leila Gharani shows you how to to enable the Developer Tab, which allows you to record and run macros.
Read More
How to Build an Excel Dashboards in Under 15 Minutes!
Learn the tricks that allow you to build an Excel Dashboard super fast.
Read More
How to use VLOOKUP in Excel – Complete Tutorial
-
Frank
- March 11, 2021
- Beginner
- beginners
- between two worksheets
- Excel
- excel vlookup
- excel vlookup tutorial
- formula
- function
- h look up
- h lookup
- help
- HLOOKUP
- hlookup in excel
- how to do
- how to use
- how to use vlookup in excel
- in excel
- kevin
- kevin stratvert
- lookup function
- Microsoft
- Microsoft Excel
- multiple sheets
- stratvert
- Tutorial
- v look up
- v lookup
- vlook up
- VLOOKUP
- vlookup and hlookup
- vlookup formula
- vlookup in excel
- What Is
- x look up
- x lookup
- xlookup
- xlookup in excel
Kevin Stratvert provides this step-by-step tutorial where you will learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel.
Read More
How to easily automate boring Excel tasks with Power Query!
MyOnlineTrainingHub explains how ower Query can automate the boring and laborious tasks of getting and cleaning data, reducing time spent on these tasks down to the click of a button. Get the files for this lesson here: https://www.myonlinetraininghub.com/introduction-to-power-query
Read More
What is Microsoft 365?
-
Frank
- February 18, 2021
- 2019
- 360
- 365
- access
- buy
- editor
- Excel
- family
- family safety
- forms
- icons
- Install
- kevin stratvert
- Microsoft
- Microsoft 365
- microsoft office
- microsoft office 365
- Money
- ms
- o365
- Office
- office 2019
- Office 365
- office suite
- office.com
- Office365
- one drive
- onedrive
- outlook
- Personal
- personal vault
- PowerPoint
- publisher
- review
- skype
- Stock
- stock images
- stock videos
- stratvert
- template
- templates
- Tutorial
- vault
- videos
- Web
- what is microsoft 365
- what is office 365
- windows 365
- word
Kevin Stratvert explains all about Microsoft 365. Microsoft 365 is a subscription plan that includes the Microsoft Office suite (which includes apps like Outlook, Word, Excel, and PowerPoint), 1 TB of additional OneDrive storage and access to OneDrive Personal Vault, and 60 minutes of Skype calls per month.
Read More