Discover lesser-known Excel features that can make everyday work more efficient. Explore productivity techniques that help you use more of the application’s capabilities.
Discover how to avoid common spreadsheet stumbling blocks and reveal ways to maximize the power of Excel.
At the end of the course, you will be able to:
• Explore keyboard shortcuts methods that helps you to work more efficiently instead of using a mouse.
• Organise and work with data productively by various data entry techniques, linking and entering data in multiple sheets and use of Quick Analysis tools
• Perform quick formatting dealing with numbers, dates and formulas
• Create PivotTables with formulas with structure references and Splitting PivotTable into Multiple Worksheets
• Use shortcut keys to create Charts and ease the effort of creating charts by using Recommended Charts.
• Uncover the hidden tools and use of Quick Access toolbars and Custom tabs
BENEFITS OF Microsoft Excel – 99 Pro Tips and Tricks TRAINING
Increased efficiency and productivity
Enhanced data analysis: Excel
Improved data visualization
Error detection and prevention
Explore the syllabus
Workbooks and Worksheets
• Navigational Techniques
• Zooming In and Out Quickly
• Copying and Moving Worksheets
• Custom Views
• Print Setups
• Inserting a Watermark
Organizing and Working with Data
• Data Entry Techniques
• Using AutoCorrect
• Entering and Linking Data across Multiple Worksheets
• Selection Methods
• Filling Blank Cells with Value
• Copying and Pasting Options
• Using the Quick Analysis Tool
Formatting
• Leading Zeros
• Adding Text to Numbers
• Managing Line Break within Cell
• Adding Comments Inside Formulas
• Creating Bulleted List
• Format Painter Tips
• Applying Formulas Based Conditional Formatting
Numbers, Dates and Formulas
• AutoSum Magic
• Managing Range Names
• Applying Formulas Based Data Validation
• Linking Text Boxes to Cell Contents
Tables and PivotTables
• Creating Table using Shortcuts
• Creating Formulas using Structured References
• Working with Recommended PivotTables
• Splitting PivotTable into Multiple Worksheets
• Extracting Records from PivotTable
Charts
• Working with Recommended Charts
• Setting Default Chart
• Creating Mini Charts using Sparklines
• Linking Titles and Labels with Cell Contents
• Dealing with Missing Data
Working with Hidden Tools
• Activate Hidden Commands to Quick Access Toolbar or Custom Tabs
• Using the Hidden Tools
A good place to start.
Tell us what you would like to learn or how you would like to collaborate. Our team will help with the next step.
Ready for your next step?
Let’s find the right training for you or your team.
