Do you often work with data at work or frequently extract data to create reports to update your leaders?
Microsoft Excel is a powerful spreadsheet program that allows you to make quick and accurate numerical calculations.
You will be more confident when you present formulated spreadsheets to highlight your key data narratives.
Go beyond Excel’s basic tools in this focused one-day workshop. Discover additional ways to manage data and complete spreadsheet tasks more efficiently.
AT THE END OF THE COURSE
Build confidence with conditional formatting, sorting, filtering and data validation. Practise IF, AND and OR, conditional and database formulas, then develop your ability to present information in charts.
Since this is a fast track course, you only learn what you need to be proficient and efficient.
BENEFITS OF Microsoft Excel Intermediate - Fast Track
Increased efficiency and productivity
Advanced Formulas and Functions
Data Cleaning and Formatting
Preparation for Advanced Excel
Explore the syllabus
Essential Excel Fundamental
• Customizing the Quick Access Toolbar
• Entering Content Automatically (AutoFill & Flash Fill)
• Using Paste Options and Paste Special Commands
• Applying Conditional Formatting
• Creating and Managing Conditional Formatting Rules
Working with Functions and Formulas
• Overview of Formulas and Cell References (Absolute & Relative)
• Cell and Range Names
• Using and Managing Defined Names
• Understanding Formula Errors
• Using Logical Functions (Nested IF, AND, OR)
• Using Conditional Count, Sum and Average Functions (COUNTIF, SUMIF, AVERAGEIF
• Using Database Functions (DSUM, DCOUNT, DAVERAGE)
Managing Workbooks and Protections
• Splitting and Freezing a Window
• Working with Multiple Workbook Windows
• Protecting Workbooks
• Protecting a Workbook Structure
• Protecting Worksheets and Worksheet Elements
Working with Data Ranges
• Creating Custom Number Format
• Sorting by One Column
• Sorting by Multiple Columns
• Sorting by Custom List
• Filtering Data
• Creating Custom AutoFilter
• Using Data Validation
• Using Subtotal
Creating and Working with Charts
• Choosing and Selecting the Source Data
• Using Quick Analysis
• Choosing the Right Chart
• Inserting, Moving, Resizing and Deleting Chart
• Elements of a Chart
• Modifying and Changing Chart Data
• Filtering Chart
• Changing Chart Layout, Style and Colors
• Working with Chart Labels
• Changing Chart Gridlines
• Changing the Scale
• Emphasizing Data
• Changing Chart Type
• Using Sparklines
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.
