Basic to Intermediate = 6 Hours in 3 x 2 hour units or 2 x 3 hour units over different days.
Excel Best Practice in Perth
Getting Acquainted with Excel
1. The Excel Environment
2. The Title Bar
3. The Menu Bar
4. The Standard Toolbar
5. The Formatting Toolbar
6. The Ribbon
7. The Quick Access Toolbar
8. Scroll Bars
9. The Formula Bar
10. The Zoom Bar
11. Saving
12. Sheets
Using Ranges etc
1. Using Ranges
2. Selecting Ranges
3. Using AutoFill (Text, Numbers, Custom)
4. Sorting
5. Delete Duplicates
6. Filtering
7. Search & Replace
8. Format Painter
9. Flashfill
Inserting Images
1. Pictures
2. Online pictures
3. Shapes
4. Smart Art
Creating Formulas
1. Using Formulas
2. Formula Functions (+, -, *, /)
3. Using AutoSum
4. What is a Cross-Check
5. Average, Count Numbers, Count Text, Max, Min
6. Currency Conversion
7. Absolute Reference
8. Circular Reference
9. GST Calculations
10. Date Artithmetic
Building a “real” Spreadsheet
1. Putting all above into practice
2. Insert Comments
3. Printing
4. Protection
Co-Editing
Excel Intermediate to Advanced = 6 Hours in 3 x 2 hour units or 2 x 3 hour units over different days.
SUMMARIZING DATA
• Advanced Subtotals
• Formatting the Subtotal Rows
• Adding and Copying with Subtotals
• Consolidating Data
• Introducing the SUMIF Command
• Working with the SUMIF Command
• Looking at AutoSum Tricks
• Utilizing Fill Handle Tricks
WORKING WITH PIVOT TABLES
• Creating a Pivot Table
• Rearranging Fields in a Pivot Table
• Explaining the Report Layout Options
• Using the Report Filters Feature
• Using Top 10 & Date Filters
• Handling Blank Cells
• Drilling Down in the Pivot Table
• Sorting a Pivot Table
• Formatting a Pivot Table
• Creating Custom Formats
• Explaining the Grouping Options
• Adding Formulas to a Pivot Table
• Changing a Calculation in a Pivot Table
• Replicating a Pivot Table
• Counting with a Pivot Table
CHARTING IN EXCEL
• Charts Refresher
• Moving, Sizing & Copying Charts
• Formatting Charts
• Formatting a Series
• Exploring the Home & Format Ribbons
• Deciding What Chart Format to Use
• Show a Time Series with Column or Line Charts
• Using Combination Charts
• Using Line Chart Accessories
• Using Bar Charts to Show Comparisons
• Using Component Charts
• Using Correlation Charts
• Exploring Other Charts
• Chart Lies Revealed & Advanced Chart Types
• Creating a Custom Layout
GETTING VISUAL
• Using Conditional Formatting
• Using Advanced Conditional Formatting
• Highlighting, Sorting & Filtering Columns
CREATING POWERFUL FORMULAS
• Auditing Formulas
• Shrinking the Formula Bar
• Understanding Errors
• Pasting Values
• Using Paste Special
• Breaking Apart Text
• Flashfill
• Converting Text to Numbers
• Using Date Functions
• Using the VLOOKUP and HLOOKUPFunction
• Using the Convert Function
• Using rounding Formulas
• Ranking & Sorting Formulas
TIPS & TRICKS
• Showing Off New Tips in Excel (Eg: Speak on Enter)
• Tips for Handling Worksheets
• Best Practice
• Validating Data
• Grouping
• Multi-Sheet and Dashboard
• Modelling Eg: Costing Sheet, Budgeting, Manhour tracking and Any model that may be useful
Fast Track Computer Solutions helping 1000’s in WA since 1985! Call Ivor NOW on (08) 9275-9188 or email ivor@perthsoftware.com