Upper Menu

Excel

personal.xlsb doesn't load

When Personal.XLSB in Excel fails to load

I spent several hours today creating an extensive Excel Macro to combine two reports exported out of QuickBooks Premier. I created a Customer:Job Status report and a Job Profitability report, blending them into an Excel table that would allow my client to filter by Job Status, and use Conditional Formatting to colorize it based on profit margin […]

Continue Reading 0

Learn Excel in 3 Hours Flat

Excel Class Description:

Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers. We focus on the tools that will be most useful to you at work.

It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques will work similarly in all versions of Excel.

The class will be recorded and saved in “My Class Recordings” for you to review at your convenience!

Instructional Level

Beginner to Intermediate

Course Length

3 hours

Course Credits

3 Oregon CPE, Certificate of Completion

Requirements

  • Microsoft Office 365 or a standalone copy.

Who should take this class?

  • Business owners and employees looking to analyze data for business decisions
  • Students and job-seekers looking to boost their employment marketability.
  • Beginners who want to start from scratch
  • Advanced students looking to fill in gaps in their knowledge.

What You’ll Learn

  • Moving around in a spreadsheet
  • Entering data
  • AutoFill Handle
  • Formulas Functions
  • Relative and Absolute Cell References
  • Formatting
  • Charts
  • Sparklines
  • Printing
  • Conditional Formatting
  • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

About Your Instructor

Alicia Katz Pollock is a Microsoft Certified Trainer, Microsoft Office Specialist, Master Level, and Microsoft Certified Application Specialist in Excel, Word, Access, PowerPoint, and Outlook.

Attend in Person, via Webinar, or Watch Later

If you are planning to attend our class in person, choose Live @ CityMac, 12310 N.E. Whitaker Way, Portland, OR 97230.

If you live outside the Portland, OR area you can still attend and participate in our live classes via webinar. When you register, choose “Webinar” as your ticket type. We’ll email you an access code and instructions for how to connect.

If you have a busy schedule, but don’t want to miss a class, choose “Watch Later” when you register. After your class has ended, we’ll send you a link to the class recording so you can take the class at your convenience. And, if you have questions, this option comes with a 10-minute followup phone call.

Continue Reading

Learn Excel in 3 Hours Flat

Class Description

Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

It doesn’t matter what version of the PC or Mac operating system you’re using. Techniques work similarly in Excel 2007, 2010, and 2013 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar.

Instructional Level

Beginner to Intermediate

Course Legnth

3 hours

Course Credits

3 Oregon CPE, Certificate of Completion

Requirements

<ul{text-align: left;}>

  • Microsoft Office 365 or a standalone copy.

Who should take this class?

<ul{text-align: left;}>

  • Business owners and employees looking to analyze data for business decisions
  • Students and job-seekers looking to boost their employment marketability.
  • Beginners who want to start from scratch
  • Advanced students looking to fill in gaps in their knowledge.

What You’ll Learn

<ul{text-align: left;}>

  • Moving around in a spreadsheet
  • Entering data
  • AutoFill Handle
  • Formulas Functions
  • Relative and Absolute Cell References
  • Formatting
  • Charts
  • Sparklines
  • Printing
  • Conditional Formatting
  • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

About Your Instructor

Alicia Katz Pollock is a Microsoft Certified Trainer, Microsoft Office Specialist, Master Level, and Microsoft Certified Application Specialist in Excel, Word, Access, PowerPoint, and Outlook.

Attend in Person, via Webinar, or Watch Later

If you are planning to attend our class in person, choose Live @ CityMac (formerly TD Curran), 12310 N.E. Whitaker Way, Portland, OR 97230.

If you live outside the Portland, OR area you can still attend and participate in our live classes via webinar. When you register, choose “Webinar” as your ticket type. We’ll email you an access code and instructions for how to connect.

If you have a busy schedule, but don’t want to miss a class, choose “Watch Later” when you register. After your class has ended, we’ll send you a link to the class recording so you can take the class at your convenience. And, if you have questions, this option comes with a 10-minute followup phone call.

Continue Reading

Learn Excel in 3 Hours Flat

Class Description

Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

It doesn’t matter what version of the PC or Mac operating system you’re using. Techniques work similarly in Excel 2007, 2010, and 2013 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar.

Instructional Level

Beginner to Intermediate

Course Legnth

3 hours

Course Credits

3 Oregon CPE, Certificate of Completion

Requirements

  • Microsoft Office 365 or a standalone copy.

Who should take this class?

  • Business owners and employees looking to analyze data for business decisions
  • Students and job-seekers looking to boost their employment marketability.
  • Beginners who want to start from scratch
  • Advanced students looking to fill in gaps in their knowledge.

What You’ll Learn

  • Moving around in a spreadsheet
  • Entering data
  • AutoFill Handle
  • Formulas Functions
  • Relative and Absolute Cell References
  • Formatting
  • Charts
  • Sparklines
  • Printing
  • Conditional Formatting
  • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

About Your Instructor

Alicia Katz Pollock is a Microsoft Certified Trainer, Microsoft Office Specialist, Master Level, and Microsoft Certified Application Specialist in Excel, Word, Access, PowerPoint, and Outlook.

Attend in Person, via Webinar, or Watch Later

If you are planning to attend our class in person, choose Live @ CityMac (formerly TD Curran), 12310 N.E. Whitaker Way, Portland, OR 97230.

If you live outside the Portland, OR area you can still attend and participate in our live classes via webinar. When you register, choose “Webinar” as your ticket type. We’ll email you an access code and instructions for how to connect.

If you have a busy schedule, but don’t want to miss a class, choose “Watch Later” when you register. After your class has ended, we’ll send you a link to the class recording so you can take the class at your convenience. And, if you have questions, this option comes with a 10-minute followup phone call.

Continue Reading

Google Docs: Sheets

Class Description

Google Docs is an online web-based suite of business apps that parallel Microsoft Office. Sheets is Google’s spreadsheet, like Excel. Take this class to learn how to use Sheets to create your own spreadsheets, share them with others, and import/export them with Excel.

Instructional Level

Beginner through Intermediate

Course Length

3 hours

Course Credits

3 CPE, Certificate of Completion

Requirements

Docs.google.com account.

Who should take this class?

  • Business owners and employees who leverage Google Docs for their business documents.
  • People who are familiar with Excel but need to make the switch.

What should you bring?

A laptop computer with a docs.google.com account.

What You’ll Learn

  • Moving around in a spreadsheet
  • Entering data
  • AutoFill Handle
  • Formulas and Functions
  • Relative and Absolute Cell References
  • Formatting
  • Charts
  • Sparklines
  • Printing
  • Conditional Formatting
  • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

About Your Instructor

Alicia Katz Pollock is a Microsoft Certified Trainer, Microsoft Office Specialist, Master Level, and Microsoft Certified Application Specialist in Excel, Word, Access, PowerPoint, and Outlook.

Attend in Person, via Webinar, or Watch Later

If you are planning to attend our class in person, choose Live @ CityMac (formerly TD Curran), 12310 N.E. Whitaker Way, Portland, OR 97230.

If you live outside the Portland, OR area you can still attend and participate in our live classes via webinar. When you register, choose “Webinar” as your ticket type. We’ll email you an access code and instructions for how to connect.

If you have a busy schedule, but don’t want to miss a class, choose “Watch Later” when you register. After your class has ended, we’ll send you a link to the class recording so you can take the class at your convenience. And, if you have questions, this option comes with a 10-minute followup phone call.

Continue Reading

Learn Excel in 3 Hours Flat

Class Description

Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

It doesn’t matter what version of the PC or Mac operating system you’re using. Techniques work similarly in Excel 2007, 2010, and 2013 for PC. The screen appearance may look a little different, but the tools function the same way. Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar.

Instructional Level

Beginner to Intermediate

Course Legnth

3 hours

Course Credits

3 Oregon CPE, Certificate of Completion

Requirements

  • Microsoft Office 365 or a standalone copy.
  • Who should take this class?

  • Business owners and employees looking to analyze data for business decisions
  • Students and job-seekers looking to boost their employment marketability.
  • Beginners who want to start from scratch
  • Advanced students looking to fill in gaps in their knowledge.
  • What You’ll Learn

  • Moving around in a spreadsheet
  • Entering data
  • AutoFill Handle
  • Formulas Functions
  • Relative and Absolute Cell References
  • Formatting
  • Charts
  • Sparklines
  • Printing
  • Conditional Formatting
  • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.
  • About Your Instructor

    Alicia Katz Pollock is a Microsoft Certified Trainer, Microsoft Office Specialist, Master Level, and Microsoft Certified Application Specialist in Excel, Word, Access, PowerPoint, and Outlook.

    Attend in Person, via Webinar, or Watch Later

    If you are planning to attend our class in person, choose Live @ CityMac (formerly TD Curran), 12310 N.E. Whitaker Way, Portland, OR 97230.

    If you live outside the Portland, OR area you can still attend and participate in our live classes via webinar. When you register, choose “Webinar” as your ticket type. We’ll email you an access code and instructions for how to connect.

    If you have a busy schedule, but don’t want to miss a class, choose “Watch Later” when you register. After your class has ended, we’ll send you a link to the class recording so you can take the class at your convenience. And, if you have questions, this option comes with a 10-minute followup phone call.

    Continue Reading

    Learn Excel in 3 Hours Flat

    Class Description

    Yes, you can learn Excel in 3 hours! Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

    Instructional Level

    Beginner to Intermediate

    Requirements

    • No prerequisite knowledge needed.
    • Techniques work similarly in Excel 2007, 2010, and 2013 for PC. The screen appearance may look a little different, but the tools function the same way.
    • Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar.
    • It doesn’t matter what version of the PC or Mac operating system you’re using.
    • Bring your laptop to class, or you can watch our demonstration.

    Who should take this class?

    This class is necessary training for business owners and employees looking to analyze data for business decisions, and students and job-seekers looking to boost their employment marketability.

    It’s designed for beginners who want to start from scratch, as well as more advanced students looking to fill in gaps in their knowledge. Since we specialize in what you “don’t know that you don’t know,” even seasoned users are guaranteed to glean essential nuggets of information to make using Excel easier than before.

    What You’ll Learn

    • Moving around in a spreadsheet
    • Entering data
    • AutoFill Handle
    • Formulas Functions
    • Relative and Absolute Cell References
    • Formatting
    • Charts
    • Sparklines
    • Printing
    • Conditional Formatting
    • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

    About Your Instructor

    Alicia Katz Pollock is a Microsoft Certified Trainer, Microsoft Office Specialist, Master Level, and Microsoft Certified Application Specialist in Excel, Word, Access, PowerPoint, and Outlook.

    Attend in Person or Online via Webinar

    If you are planning to attend our class in person, choose Live @ Vancouver Chamber of Commerce, 1101 Broadway,Vancouver, WA 98660.

    If you live outside the Portland, OR area you can still attend and participate in our live classes via webinar. When you register, choose “Online via Webinar” as your ticket type. We’ll email you an access code and instructions for how to connect.

    If you have a busy schedule, but don’t want to miss a class, choose “Watch Later” when you register. After your class has ended, we’ll send you a link to the class recording so you can take the class at your convenience. And, if you have questions, this option comes with a 10-minute followup phone call.

    Continue Reading

    Learn Excel in 3 Hours Flat

    Class Description

    Yes, you can learn Excel in 3 hours! Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

    Instructional Level

    Beginner to Intermediate

    Requirements

    • No prerequisite knowledge needed.
    • Techniques work similarly in Excel 2007, 2010, and 2013 for PC. The screen appearance may look a little different, but the tools function the same way.
    • Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar.
    • It doesn’t matter what version of the PC or Mac operating system you’re using.
    • Bring your laptop to class, or you can watch our demonstration.

    Who should take this class?

    This class is necessary training for business owners and employees looking to analyze data for business decisions, and students and job-seekers looking to boost their employment marketability.

    It’s designed for beginners who want to start from scratch, as well as more advanced students looking to fill in gaps in their knowledge. Since we specialize in what you “don’t know that you don’t know,” even seasoned users are guaranteed to glean essential nuggets of information to make using Excel easier than before.

    What You’ll Learn

    • Moving around in a spreadsheet
    • Entering data
    • AutoFill Handle
    • Formulas Functions
    • Relative and Absolute Cell References
    • Formatting
    • Charts
    • Sparklines
    • Printing
    • Conditional Formatting
    • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

    About Your Instructor

    Alicia Katz Pollock is a Microsoft Certified Trainer, Microsoft Office Specialist, Master Level, and Microsoft Certified Application Specialist in Excel, Word, Access, PowerPoint, and Outlook.

    Attend in Person or Online via Webinar

    If you are planning to attend our class in person, choose Live @ Vancouver Chamber of Commerce, 1101 Broadway,Vancouver, WA 98660.

    If you live outside the Portland, OR area you can still attend and participate in our live classes via webinar. When you register, choose “Online via Webinar” as your ticket type. We’ll email you an access code and instructions for how to connect.

    If you have a busy schedule, but don’t want to miss a class, choose “Watch Later” when you register. After your class has ended, we’ll send you a link to the class recording so you can take the class at your convenience. And, if you have questions, this option comes with a 10-minute followup phone call.

    Continue Reading
    css.php