31616 подписчиков
50 видео
Excel: Insert time date with the shortcut Ctrl+Shift+,(comma) and Ctrl+Shift+.(dot)
Exploring Python’s Powerful Built-in Zip Function
F12 Save as shortcut in Excel
Mapping and importing/exporting an XML schema with Excel.
Excel go to special window shortcut F5+Alt+S
Control Excel with Python & OpenPyXL course
Using Alt Enter to linebreak a formula in Excel
Control PDF with Python & PyPDF2
How to automatically fill a column with days of the week in Excel
How to create an XML file from an Excel document with Python.
Excel undo and redo shortcuts Ctrl+Z and Ctrl+Y explained.
How to add data to existing Excel spreadsheet tables with OpenPyXL.
Ctrl+F9 for minimizing and Ctrl+F10 for maximizing windows in Excel
Alt+H+E+A shortcut to clear values and formatting in Excel
Simplifying Data Filtering with Python’s filter() Function
Generate fake data with Faker and write to CSV file with Python.
Excel shortcut Shift+F11 for inserting Sheets and F11 for inserting Chartsheets.
Coding Coconuts 2 - OpenPyXL, Excel Tables and Removing AutoFilter
How to undo and redo in Excel, with shortcuts
Ctrl+F5 shortcut for windowed mode in Excel.
How to use Excels Flash Fill shortcut Ctrl+E
Using Python's Built-in Function Enumerate
Ctrl+R and Ctrl+D to copy cell values and formatting.
Hiding rows & columns in Excel with Ctrl+0 and Ctrl+9
Excel's Insert Function shortcut Shift+F3
Ctrl+Shift+Tab to switch between open Excel workbooks in reverse direction
alt+F11 shortcut to open the Visual Basic Editor (VBA)
Coding Coconuts #1 Part 2 Pandas, Plotly and Dash
