Microsoft Excel PivotTables Explained
-
Frank
- May 17, 2022
- calculated field
- Excel
- excel 2021
- Excel 365
- excel pivot
- excel pivot table
- excel pivot table tricks
- excel pivot tables
- Excel pivottables
- Excel PivotTables Explained
- Excel tips and tricks
- excel tricks
- formatting pivot table
- Grouping PivotTable Data
- learn excel
- pivot table
- pivot table excel
- pivot table from scratch
- pivot table grouping
- pivot table in excel
- pivot table slicers
- pivot tables
- pivottable
- pivottable from scratch
- PivotTable Styles
- Spreadsheets
In this Microsoft Excel 2021/Excel 365 training tutorial video, learn all about Excel PivotTables. We’ll go over creating a PivotTable from scratch and discuss the different elements of a PivotTable! Learn how to pivot a field, add totals, format numbers and errors, choose a report layout, apply formatting styles, and more! We finish off with […]
Read More
How to Create an Excel Dashboard for Schools with changing students images dynamically
-
Frank
- April 6, 2022
- dashboard
- dashboard design
- dashboard excel
- dashboard in excel
- dashboard powerpoint
- dynamic dashboard
- dynamic dashboard in excel
- Excel
- excel dashboard
- excel dashboard design
- excel dashboard templates
- excel dashboard tutorial
- excel dashboards
- excel dashboards and reports
- excel design
- excel interactive dashboard
- interactive dashboard
- interactive dashboard in excel
- interactive excel dashboard
- other level
- powerpoint dashboard
- school dashboard
- 엑셀 대시보드
Here’s an interesting video on creating a dashboard in Excel. Chapters: 0:00, Dashboard Features & contents Overview 1:25, workbook contents 1:50, 1st Dashboard background 2:27, 2nd Dashboard background 3:43, Left side buttons 5:47, Values & charts background 7:05, Main title and KPIs 10:06, Side menu background image 11:21, Students per educational stage column chart 16:12, […]
Read More
How to Make Named Ranges in Excel
Learn how to maker Named Ranges in Excel today.
Read More
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