MS Excel 2013 Basic/Advanced

Course Syllabus

The Basics:

• Creating a New Workbook: Learn how to start a new workbook from scratch and navigate the Excel interface.
• Navigating in Excel: Explore moving the cell pointer and navigating through worksheets.
• Using Excel Menus and Toolbars: Customize toolbars by hiding, displaying, and moving them for an optimized workspace.
• Entering Values and Selecting Cell Ranges: Input data into cells and select multiple cells effectively.
• Previewing and Printing Worksheets: Understand print setup and previewing options before printing.
• Getting Help from the Office Assistant: Use built-in help resources to resolve Excel-related queries.
• Saving and Re-Opening Workbooks: Save your progress and access previously saved workbooks.

Formatting a Worksheet:

• Headers, Footers, and Page Numbers: Add essential document details to enhance professionalism.
• Adjusting Page Margins and Orientation: Customize your page layout settings for printing.
• Print Titles and Gridlines: Set rows to repeat at the top of each printed page for easy reference.
• Formatting Fonts and Values: Change font style, size, and value display formats.
• Row Height and Column Width Adjustments: Modify rows and columns for a polished appearance.
• Changing Cell Alignment: Align cell content for better readability.
• Adding Borders, Colors, and Patterns: Enhance the look of your worksheet with visual formatting.
• Using Format Painter and AutoFormat: Quickly copy formatting and apply predefined styles.
• Merging Cells: Combine multiple cells to create a unified appearance.

Managing Your Workbooks:

• Switching Between Sheets: Navigate across multiple worksheets seamlessly.
• Inserting, Deleting, and Renaming Worksheets: Manage sheets within your workbook.
• Protecting a Workbook: Set up workbook protection to prevent unwanted changes.
• Hiding Columns, Rows, and Sheets: Simplify your view by hiding unnecessary data.
• Splitting and Freezing Panes: Keep important data in view while scrolling.
• Inserting Page Breaks and Advanced Printing Options: Manage how your data appears on printed pages.

Editing a Workbook:

• Entering Date Values and Using AutoComplete: Speed up data entry using date shortcuts.
• Editing, Clearing, and Replacing Cell Contents: Modify data quickly and efficiently.
• Cutting, Copying, and Pasting Cells: Master data movement within the worksheet.
• Using Drag and Drop for Moving Cells: An intuitive approach to reposition data.
• Paste Special Options: Perform advanced paste operations for data manipulation.
• Inserting and Deleting Cells, Rows, and Columns: Adjust worksheet structure as needed.
• Spell Checking and Replacing Information: Ensure data accuracy with built-in tools.
• Adding Cell Comments: Annotate cells with helpful notes.

Formulas:

• Creating Basic Formulas: Perform calculations using cell references.
• Calculating Totals with AutoSum: Quickly sum data in your worksheet.
• Editing and Copying Formulas: Adjust formulas as needed and replicate them.
• Fixing Formula Errors: Troubleshoot common issues in your calculations.
• Formulas with Multiple Operators and Ranges: Create complex calculations using various functions.

Working with the Forms Menu:

• Sorting, Subtotaling, and Filtering Data: Organize data for better analysis.
• Copying and Pasting Filtered Records: Extract and manipulate specific data sets.
• Using Data Validation: Ensure data integrity by setting criteria for entries.

Creating and Working with Charts:

• Creating and Formatting Charts: Visualize your data with different chart types.
• Moving, Resizing, and Editing Charts: Customize chart layout and design.
• Changing Chart Types and Working with Pie Charts: Display data with various chart formats.
• Adding Titles, Gridlines, and Data Tables: Improve chart readability.
• Formatting Data Series and Chart Axis: Enhance the appearance of your charts.
• Annotating Charts: Add notes or labels to explain data trends.
• Working with 3-D Charts and Customizing Fill Effects: Make charts visually appealing with 3D effects.
• Modifying a Map: Customize mapped data for geographic analysis.

Data Analysis and PivotTables:

• Creating and Modifying PivotTables: Summarize and analyze large data sets.
• PivotTable Calculations and Selections: Tailor calculations and displayed data.
• Grouping Dates and Updating PivotTables: Manage time-based data efficiently.
• Formatting and Charting PivotTables: Present PivotTable data visually.

Automating Tasks with Macros:

• Recording and Playing Macros: Automate repetitive tasks to save time.
• Assigning Macros to Shortcut Keys: Trigger macros with ease.
• Adding Macros to Toolbars: Streamline your workflow with custom macro buttons.

Working with Other Programs:

• Inserting Excel Data into Microsoft Word: Integrate Excel data within Word documents.
• Modifying Inserted Worksheets and Charts: Update data directly within Word.
• Linking Excel Charts to Word: Maintain a dynamic link between Excel and Word.
• Inserting Graphics into a Worksheet: Enhance worksheets with visual elements.