100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
WALL STREET PREP:EXCEL CRASH COURSE /EXCEL CRASH COURSE EXAM 2024 LATEST VERSION FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL CRASH COURSE.£16.34
Add to cart
WALL STREET PREP:EXCEL CRASH COURSE /EXCEL CRASH COURSE EXAM 2024 LATEST VERSION FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL CRASH COURSE.
WALL STREET PREP:EXCEL CRASH COURSE /EXCEL CRASH COURSE EXAM 2024 LATEST VERSION FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL CRASH COURSE.
WALL STREE T PREP:EXCEL CRASH COURS /EXCEL CRASH COURSE EXAM 2024 LATEST VERSION FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL CRASH COURSE . Excel Formulas - ANSWER -Start with the = sign The = sign tells Excel that the info that will follow the = sign should be treated as a formula and not as plain text Once you type in the = sign, use the arrow keys to navigate around the Excel workbook to find the cells you need for your formula Operations in Excel - ANSWER - Copying Across Formulas - ANSWER -Ctrl + C to copy, Ctrl + V to paste Open Format Cells Dialog - ANSWER -Ctrl+1 (Cmnd+1) Navigating Format Cells Dialog - ANSWER -Using the Arrow keys to get around the tab To get in a tab, either use Tab key or use Alt and the relevant letter Use Space to toggle check boxes Highlight a Contiguous Range - ANSWER -Ctrl + Shift + Arrows (Cmnd + Shift + Arrows) Combining Data in Two Sheets into Another Sheet - ANSWER -(1) Copy and paste the relevant headers into the third sheet (2) Type "=" in the relevant column in the third sheet and then use Ctrl PageUp/Down (Option Right/LeftArrow) to get to the first sheet and find the right data (3) Press "+" and then find the relevant data in the second sheet and press "Enter" (4) Ctrl+C to copy that formula and then apply it to the rest of the table (5) Delete and retype any important formulas (ex. Net Profit) (6) Add in formatting by Ctrl+C the table in sheet 1 or 2, moving to the upper corner of the table in sheet 3 and using Paste Special and then format: Alt+E+S+T or Ctrl+Alt+V+T (Ctrl+Cmnd+V+T) Paste Special - ANSWER -Alt+E+S (Ctrl+Cmnd+V+T) Let's the user dictate the specific attributes of a cell or highlighted region that should be pasted Open a New Workbook - ANSWER -Ctrl+N Toggle Between Workbooks - ANSWER -Ctrl+Tab (Cmnd ~) Referencing Cells from Other Workbooks - ANSWER -(1) Hit "=" (2) Hit Ctrl+Tab (Cmnd ~) to go to the other workbook (3) Find the relevant data and hit Enter How to Autofit a Range of Columns - ANSWER -(1) Select the columns by hitting Ctrl+SpaceBar (2) Hold down the shift key and use left and right arrow keys to highlight the range of columns (3) Hit Alt+H+O+I to autofit the columns Moving Around the Format Cells Dialog - ANSWER -Move across tabs with Ctrl+Tab Move counterclockwise across form elements with Shift+Tab Select a checkbox with Spacebar Freezing and Splitting Panes - ANSWER -Excel worksheets often become too large to allow users to view all of their contents on one screen 'Freezing Panes' and 'Splitting Panes' options provide users with the flexibility to select specific rows and columns that always remain visible when scrolling in the worksheet Panes - ANSWER -Portions of the worksheet that are bounded and separated by vertical and/or horizontal bars To Freeze Panes - ANSWER -Click the cell below the desired row and to the right of the desired column where you want to freeze panes Hit Alt+W+F+F to freeze To unfreeze, hit Alt+W+F+F again (View>Freeze Panes and then View>Unfreeze Panes) *Note: To create a horizontal freeze, go to the leftmost column! Splitting Panes - ANSWER -Allows users to scroll in both areas of the worksheet, while rows and columns in the non -scrolled area remain visible Directions: (1) Click the cell below the desired row and to the right of the desired column where you want to split panes and hit Alt+W+S (2) To un -split, click Alt+W+S again (3) Press F6 to move from pane to pane in a clockwise direction; press Shift+F6 to move from pane to pane in a counter -clockwise direction (View>Split) *Note: To create a horizontal split, go to the leftmost column! Redo - ANSWER -Ctrl+Y Entering an Active Cell - ANSWER -F2 (Fn+F2) Go to the Beginning of an Active Cell Formula - ANSWER -Ctrl+Home
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller teachme2expert. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £16.34. You're not tied to anything after your purchase.
