Skip to content Skip to footer

Microsoft Excel Knowledge

Questions & Answers

Ctrl + Alt + FAQ : Laugh, Learn, and Level Up Your Microsoft Excel Knowledge

Click “File”, then “New”, then “Blank Workbook”. It’s like your PC is giving you a clean slate for your data adventure!

Click “File”, then “Save As”. Give your workbook a name and select a location. It’s like your PC is a librarian, carefully cataloguing your data!

Click “File”, then “Open”, and browse to your workbook. It’s like diving back into your data pool!

Click on the cell, row number, or column letter. It’s like your PC is playing a game of data ‘I Spy’!

Click on the cell and start typing. It’s like your PC is your data diary!

Select your data, press “Ctrl + C” to copy, and “Ctrl + V” to paste. Your PC is a master of data duplication!

Click on a cell, type “=”, then your formula. It’s like your PC is donning its mathematician’s hat!

Select your data, click “Insert”, then choose your chart type. Your PC is a data artist, ready to paint a picture with your numbers!

Select your cells, click “Home”, then “Conditional Formatting”. Your PC is ready to highlight the stars of your data show!

Click “View”, then “Freeze Panes”. It’s like your PC is stopping your data in its tracks!

Select your data, click “Data”, then “Filter”. It’s like your PC is your personal data detective!

Select your data, click “Insert”, then “PivotTable”. Your PC is ready to pivot your data perspectives!

Select a row or column, right-click, then “Insert”. It’s like your PC is making room for more data guests!

Select a row or column, right-click, then “Delete”. It’s like your PC is doing a data spring cleaning!

Select your cells, click “Home”, then “Merge & Center”. It’s like your PC is hosting a cell reunion!

Select your cell, click “Home”, then “Wrap Text”. Your PC is a wordsmith, fitting your words neatly into cells!

Click “Home”, then “Find & Select”, then “Replace”. It’s like playing data hide and seek with your PC!

Select your data, click “Data”, then “Sort”. Your PC is a data organiser, lining up your data just how you like it!

Select your cells, click “Home”, then choose your format in the “Number” section. It’s like your PC is a data linguist, speaking the language of numbers!

Click “File”, then “Protect Workbook”, then “Encrypt with Password”. Your PC is the bouncer for your data nightclub!

Select your data, click “Data”, then “Remove Duplicates”. Your PC is like a data referee, keeping the game fair!

Right-click on your cell, click “Hyperlink”, then enter your URL. Your cell is now a portal to the World Wide Web!

Select a cell next to your numbers, click “Home”, then “AutoSum”. Your PC is a speedy mathematician, summing up your data in a jiffy!

Right-click on your cell, click “New Comment”. Your PC is ready for a data discussion!

Type a pattern in one cell, start typing the next, and Excel should autofill the rest. It’s like your PC is a data psychic!

Select your cell, click “Data”, then “Data Validation”, and choose “List”. Your PC is ready to serve up some data choices!

In a cell, type “=VLOOKUP()”, then follow the prompts. Your PC is playing data detective, searching for clues in your dataset!

In a cell, type “=IF()”, then follow the prompts. Your PC is ready to get philosophical, dealing with data dilemmas!

Select your cells, click “Data”, then “Text to Columns”. It’s like your PC is a data magician, performing a splitting act!

Click “Data”, then “What-If Analysis”, then “Goal Seek”. Your PC is ready to play data fortune-teller, predicting what your numbers could be!

Click “Data”, then “Solver”. Your PC is ready to play data superhero, solving your number problems!

Click “Insert”, then “Header & Footer”. It’s like your PC is adding a hat and shoes to your data outfit!

Click “Page Layout”, then “Themes”. It’s like your PC is your data’s personal stylist!

Select your data and click the “Quick Analysis” button that appears. Your PC is a data wizard, ready to cast some analytical spells!

Click “Insert”, then “Pictures”. Your PC is ready to add a touch of art to your data!

Select your cells, click “Data”, then “Data Validation”. It’s like your PC is the gatekeeper for your data kingdom!

Click “Formulas”, then “Name Manager”. Your PC is ready to be your data name-keeper!

Click “Developer”, then “Record Macro”. It’s like your PC is ready to learn some data tricks!

Click “Data”, then “Get Data”, then “Launch Power Query”. Your PC is ready to power up your data!

Click “Data”, then “Manage Data Model”. Your PC is ready to pivot your data to the max!

Click “Insert”, then “3D Map”. Your PC is ready to take your data on a globetrotting adventure!

Select your row or column, right-click, then choose “Hide” or “Unhide”. It’s like your PC is playing a game of data peekaboo!

Click “Page Layout”, then “Orientation”. Your PC is ready to flip your data world around!

Click “Insert”, then choose “Shapes” or “Text Box”. Your PC is ready to get creative with your data!

Click “Review”, then “Read Aloud”. Your PC is auditioning to be the next Stephen Fry, narrating your data!

Select your area, click “Page Layout”, then “Print Area”. It’s like your PC is the director, deciding what data makes the cut!

Select your cells, click “Home”, then the small arrow in the “Alignment” section. Your PC is a data interior decorator!

Select your column, then double-click the boundary of the column header. Your PC is like a tailor, making sure your data fits just right!

Select a cell, click “Insert”, then “Sparkline”. Your PC is ready to add a little spark to your data!

In a cell, type “=INDEX()”, then follow the prompts. It’s like your PC is a matchmaker, pairing up your data!

Contact Form

    Contact Us

    Have questions?
    Get in touch!

    36 Cromer Road, West RuntonNR27 9AD
    Go to Top